Using Oracle Enterprise Manager You can use the Recovery Wizard to restore and recover your database. On the Range Selection page you must enter a date and time to restore to a previous point. You use Instance Management or the Console to open the database after the job has completed. You can view the status of the job by selecting the Active and History page tabs in the Console’s Job window. | RMAN Incomplete Recovery Objectives After completing this lesson, you should be able to do the following: Perform an incomplete database recovery by using UNTIL TIME Perform an incomplete database recovery by using UNTIL SEQUENCE Incomplete Recovery of a Database Using RMAN 1. Mount the database. 2. Allocate multiple channels for parallelization. 3. Restore all datafiles. 4. Recover the database by using UNTIL TIME, UNTIL SEQUENCE, or UNTIL SCN. 5. Open the database by using RESETLOGS. 6. Perform a whole database backup. Incomplete Recovery of a Database Using RMAN The restore and recovery process for incomplete recovery follows the same procedure and syntax as complete recovery, except that all datafiles need to be restored from the past backup. Note The target database must be in mounted state. You can restore using RMAN only if the backups were taken or registered with RMAN. Specifying the Restore Time Using Oracle Enterprise Manager You can use the Recovery Wizard to restore and recover your database. On the Range Selection page you must enter a date and time to restore to a previous point. You use Instance Management or the Console to open the database after the job has completed. You can view the status of the job by selecting the Active and History page tabs in the Console’s Job window. RMAN Incomplete Recovery UNTIL TIME: Example RMAN> RUN { 2> ALLOCATE CHANNEL c1 TYPE DISK; 3> ALLOCATE CHANNEL c2 TYPE DISK; 4> SET UNTIL TIME = ‘2001-12-09:11:44:00'; 5> RESTORE DATABASE; 6> RECOVER DATABASE; 7> ALTER DATABASE OPEN RESETLOGS; } RMAN Incomplete Recovery UNTIL TIME: Example At 12:00 . on Tuesday, December 9, 2001, you immediately shut down the database and begin recovery after determining that the EMPLOYEES table was dropped. The approximate time of failure is known and the database structure has not changed since 11:44 . You can use the UNTIL TIME method: 1. If the target database is open, perform a clean shutdown. 2. Mount the target database. Do not | RMAN Incomplete Recovery Objectives After completing this lesson, you should be able to do the following: Perform an incomplete database recovery by using UNTIL TIME Perform an incomplete database recovery by using UNTIL SEQUENCE Incomplete Recovery of a Database Using RMAN 1. Mount the database. 2. Allocate multiple channels for parallelization. 3. Restore all datafiles. 4. Recover the database by using UNTIL TIME, UNTIL SEQUENCE, or UNTIL SCN. 5. Open the database by using RESETLOGS. 6. Perform a whole database backup. Incomplete Recovery of a Database Using RMAN The restore and recovery process for incomplete recovery follows the same procedure and syntax as complete recovery, except that all datafiles need to be restored from the past backup. Note The target database must be in mounted state. You can restore using RMAN only if the backups were taken or registered with RMAN. Specifying the Restore Time Using Oracle Enterprise Manager You can use the Recovery Wizard to restore and .
