timbolesdatabaseadministratorseniorstaff

timbolesdatabaseadministratorseniorstaff内容摘要：

• 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。