【文章內(nèi)容簡(jiǎn)介】
? Data Retention Times ? Acceptable Mean Time To Recovery (MTTR) 22 Beyond the Basics ? Encryption – Storage of Encryption Keys – Access to Encryption Keys ? Design of Database – ReadOnly Tablespaces – Tablespace Partitions ? Compression Algorithms 23 Is Your Backup Good? ? Backup Log ? Physical Check ? Logical Check ? Only good if you can recover 24 HOW TO BE SURE YOU CAN RECOVER 25 What Is Your Source? ? Memory / Experience ? Oracle Documentation / Books ? Inter Search Engines ? Coworker ? Monitoring Tools (. Oracle Enterprise Manager) ? Customized Documentation 26 Are You A Single Point Of Failure? 27 BACKUP AND RECOVERY DOCUMENT 28 Documentation Is Your Friend ? Good Business Sense ? Every System Is Different – Boosts Ability to Concentrate ? Gain Experience and Knowledge ? Refine Backup / Restore Policies ? Refine Procedures 29 Bamp。R Document 20200 ft View ? Overall Backup Strategy ? Architecture Summary ? Script Listing and Description ? Procedures ? Test Documentation 30 Overall Backup Strategy ? Types of Backups And Reasons – Physical ? Hot / Cold ? Full / Incremental – Exports ? Full ? Schema, Table, (Transportable) Tablespace ? Tools ? Scheduling ? Notification ? Retention Policies (Time and Offsite Location) ? System Specifics 31 Architecture Summary ? Server Configuration ? Tool Integration ? Database Configuration 32 Tools and Technology Available ? Media Failure – Restore Media from Backup – Recover using RMAN or SQL Commands ? Full ? Partial – Tablespace pointintime