RelationalDBDesign RelationalDBDesign


Incomplete Recovery   «Prev 

Performing Recovery with backup control file

  1. Suppose you have connected as sysdba to the database ORCL. You are told that the tablespace STUDENT is dropped. To make sure this tablespace is not there, type SELECT TABLESPACE_NAME FROM DBA_TABLESPACES at the prompt and press Enter.
  2. To start the recovery process, first shutdown the database. Type SHUTDOWN IMMEDIATE at the prompt and press Enter.
  3. Now you need to make a backup of the current control file in your operating system. To access the operating system, type HOST at the prompt and press Enter.
  4. To make a backup of the current control file, type COPY C:\ORANT\DATABASE\CT11ORCL.ORA C:\ORANT\DATABASEX at the prompt and press Enter.
  5. Suppose you have a batch file, do_restore_dcfile.bat, to help you restore all the datafiles and the control file from the most recent backup (There was one made on Feb. 13, 2000, before the tablespace was dropped). Type DO_RESTORE_DCFILE at the prompt and press Enter.
  6. To access the Server Manager, type EXIT and press Enter.
  7. Now you go to your alert log file and you find that the tablespace was removed at 2000-02-21:14:04:13. To start the recovery process, type STARTUP MOUNT at the prompt and press Enter.
  8. To start the recovery, type RECOVER DATABASE UNTIL TIME `2000-02-21:14:04:00'USING BACKUP CONTROLFILE; at the prompt and press Enter.
  9. To continue the recovery process, type AUTO at the cursor and press Enter.
  10. To synchronize datafiles with the control file and redo log files, type ALTER DATABASE OPEN RESETLOGS; at the prompt and press Enter.
  11. To make sure the tablespace STUDENT is recovered, query the DBA_TABLESPACES again. Type SELECT TABLESPACE_NAME FROM DBA_TABLESPACES; at the prompt and press Enter.
  12. You have successfully performed the recovery with a backup control file. Do not forget to make a whole database backup after each incomplete recovery. This is the end the Simulation.