- 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.
- EJB 3.0 Database Persistence with Oracle Fusion Middleware 11g: LITE
- Vulkan學習指南
- Photoshop CC摳圖+修圖+調色+合成+特效標準培訓教程(全視頻微課版)
- Yii 1.1 Application Development Cookbook
- Creo Parametric 5.0中文版從入門到精通
- NetLogo多主體建模入門
- Lighttpd
- AutoCAD 2017從新手到高手
- Seam 2 Web Development: LITE
- Solid Edge 機械設計基礎及應用
- Origin科技繪圖與數據分析
- Microsoft SQL Azure Enterprise Application Development
- FLUENT 15.0流場分析實戰指南
- SilverStripe 2.4 Module Extension, Themes, and Widgets: Beginner's Guide
- 3ds Max三維動畫制作項目式教程