- Mastering Oracle Scheduler in Oracle 11g Databases
- Ronald Rood
- 266字
- 2021-04-01 14:12:53
Chapter 2. Simple Chain
At first sight, chains might look a little intimidating. Often, there is a lot of code which can be difficult to go through when you are trying to identify particular problems or issues. But fear not, things are not as bad as they seem. Chains are useful and can reduce a number of potential issues.
In many systems, problems are hidden in the form of scheduled tasks that rely on one task to be completed before the next task is started. A nice example of this is a cold backup, which is performed in three individual sections:
- Shut down the database.
- Copy the database files to a remote location.
- Start up the database.
In the example above, when the cold backup was implemented, step 2 originally took four minutes. Therefore, the administrator decided that step 3 could be started five minutes after step 1 was completed. However, after a few weeks the database grew bigger and the copy phase of the backup took 20 minutes. This is what we might call a time bomb. Everything looks as though it is working fine. The database will run after the backup is completed and data files apparently get copied to a remote location. However, what will happen if the storage is hit by a power failure? In this case, a good backup is needed. But this backup does not exist because the original timings are no longer valid. Had the backup been implemented using a chain, this disaster could easily have been prevented. This chapter will show how this can be done.
- Moodle 2.0 E/Learning Course Development
- 性能測試從零開始
- Illustrator實(shí)例教程:Illustrator 2021(電子活頁微課版)
- Adobe Photoshop 網(wǎng)頁設(shè)計(jì)與制作標(biāo)準(zhǔn)實(shí)訓(xùn)教程(CS5修訂版)
- AutoCAD快速自學(xué)寶典(2018中文版)
- 3ds Max/VRay室內(nèi)設(shè)計(jì)材質(zhì)、燈光與建模速查超級手冊
- AI圖像處理:Photoshop+Firefly后期處理技術(shù)基礎(chǔ)與實(shí)戰(zhàn)
- 3ds Max 2014從入門到精通
- 跟儲君老師學(xué)Excel極簡思維
- 新媒體美工一冊通(全彩)
- 中文版CorelDRAW X6基礎(chǔ)培訓(xùn)教程(第2版)
- 量化投資與FOF投資:以MATLAB+Python為工具
- Photoshop CC摳圖+修圖+調(diào)色+合成+特效實(shí)戰(zhàn)視頻教程
- Power Query從入門到精通
- AutoCAD 2016中文版基礎(chǔ)教程(全圖解視頻版)