Loading Consent Dialog

Incomplete Recovery   «Prev 

Recovering an Oracle Database through RESETLOGS

1) To start recovery through RESETLOGS, the DBA makes a backup of the current control file.

2) After completing the restore, the DBA exits the operating system and returns to the SERVER MANAGER.

3) Then the DBA finds the change number, 6262122, at the completion of the last incomplete recovery in the alert log.

4) The DBA completes the first part of the recovery.

5) The DBA access the operating system (8) to restore the current control file from the backup made in step 1

6) Before starting the recovery process, the DBA mounts the database.

7) The DBA queries V$LOG view to check whether the data was recovered to the current log sequence number and the response shows that the recovery is successful.