- Perform complete or incomplete user-managed recovery. - Identify situations where incomplete recovery is necessary. - Perform complete or incomplete recovery by using RMAN. - Perform incomplete recovery based on time, SCN, log sequence, restore points, or the cancel method. - Recover an automatically backed up control file. - Complete Incomplete Control file RO TBS. - User-managed recovery. - User-Managed Recovery:. - Restore all database files from a backup and then recover the database:. - Restore the damaged data files from a backup and then recover the data files:. - RECOVER DATABASE. - Complete Versus Incomplete Recovery. - Complete recovery brings the database up to the present, including all data changes made to the point in time when the recovery was requested.. - Incomplete recovery brings the database up to a specified point in time in the past, before the. - Missing transactions after incomplete recovery Restore from. - data files Data files containing Recovered Changes applied. - log Online Redo log. - Incomplete Recovery. - Data files containing committed and. - PIT-recovered data files Undo applied. - Restored data files from as far back as necessary. - Incomplete Control file RO TBS. - Incomplete Recovery (notes only slide). - Situations Requiring Incomplete Recovery. - A backup of the control file is used to open or recover the database.. - Types of Incomplete Recovery. - There are four types of incomplete recovery:. - Time-based recovery. - Cancel-based recovery. - Change-based recovery. - Types of Incomplete Recovery (notes only slide). - Performing User-Managed Incomplete Recovery. - Recover a database until time:. - Recover a database until cancel:. - Recover using the backup control file:. - RECOVER DATABASE UNTIL CANCEL;. - RECOVER DATABASE UNTIL. - To perform user-managed incomplete recovery, follow these steps:. - Shut down the database.. - Restore data files.. - Mount the database.. - Recover the database.. - Open the database with the RESETLOGS option.. - User-Managed Time-Based Recovery:. - You decide to perform incomplete recovery to restore the database back to its state as of 15 minutes ago.. - User-Managed Time-Based Recovery Steps (notes only slide). - User-Managed Cancel-Based Recovery:. - The missing redo log is not archived.. - Recover the database as follows:. - Restore all data files from the most recent backup.. - You already have a valid backup, so mount the database.. - Execute RECOVER DATABASE UNTIL CANCEL. - Execute ALTER DATABASE OPEN RESETLOGS to open the database.. - Performing Incomplete Recovery by Using RMAN. - Restore all data files.. - Recover the database by using UNTIL TIME , UNTIL SEQUENCE , or UNTIL SCN. - Open the database by using RESETLOGS. - Time-Based Recovery Using RMAN: Example. - RECOVER DATABASE;. - Incomplete Recovery Using Enterprise Manager. - Incomplete Recovery and the Alert Log. - The following are some best practices regarding the alert log in incomplete recovery scenarios:. - Is stored in the control file. - RECOVER DATABASE – FLASHBACK DATABASE – FLASHBACK TABLE. - Incomplete Recovery: Best Practices. - Investigate and verify that incomplete recovery is necessary.. - Incomplete Recovery Best Practices (notes only slide). - Recovering a Control File Autobackup. - Control file RO TBS. - Recovering a Control File Autobackup (notes only slide). - Creating a New Control File. - Redo log file 1B Redo log. - Redo log file 2B Redo log. - Recovering Read-Only Tablespaces. - Read-only. - Read-only Read-only. - Control file backup to be used for recovery if current one lost. - Complete Incomplete Control file. - Recovering Read-Only Tablespaces (notes only slide). - Read-Only Tablespace Recovery Issues. - Special considerations must be taken for read-only tablespaces when:. - Re-creating a control file. - Renaming data files. - Using a backup control file. - Read-Only Tablespace Recovery Issues (notes only slide). - Recover a control file autobackup. - Recover read-only tablespaces. - Practice Overview: Performing Incomplete Recovery
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt