Restore Control Files

You can restore the control files that stores the physical structure of the database. Before you restore, you must locate the file. When you locate the files, ensure that the database is in the Open state.

Follow these steps:

  1. Log in to the computer where you want to restore the control files.
  2. Locate the control files using the following command:

    3. SQL> SHOW PARAMETER CONTROL FILES;

  3. Change the state of the database to nomount or shutdown before you restore the control files.

    4. SQL> STARTUP NOMOUNT;

    SQL> SHUTDOWN IMMEDIATE;

  4. Log in to the Arcserve UDP Console.
  5. Restore the Control file using the Restore Wizard. For more information on the restore process, see How to Restore From a Recovery Point.
  6. Log in to the destination computer.
  7. Navigate to the specific folders and verify that the control files are restored.
  8. Mount the database to begin the database recovery:

    9. SQL> STARTUP MOUNT

  9. Enter the RECOVER command with the USING BACKUP CONTROLFILE clause.

    10. SQL> RECOVER DATABASE USING BACKUP CONTROLFILE

  10. The database recovery process begins.
  11. (Optional) Specify the UNTIL CANCEL clause to perform an incomplete recovery.

    12. SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL

  12. Apply the prompted archived logs.
  13. Note: If the required archived log is missing, then it implies that a necessary redo record is located in the online redo logs. It occurs because unarchived changes are located in the online logs when the instance failed. You can specify the full path of an online redo log file and press Enter (you may have to try this a few times until you find the correct log).
  14. Enter the following command to return the control file information about the redo log of a database:

    15. SQL>SELECT * FROM V$LOG;

  15. (Optional) Enter the following command to see the names of all of the member of a group:

    16. SQL>SELECT * FROM V$LOGFILE;

  16. Example: After applying the prompted archived logs, you may see the following messages:

    17. ORA-00279: change 55636 generated at 24/06/2014 16:59:47 needed for thread 1

    ORA-00289: suggestion e:\app\Administrator\flash_recovery_area\orcl\ARCHIVELOG\2014_06_24\ O1_MF_1_2_9TKXGGG2_.ARC

    ORA-00280: change 55636 for thread 1 is in sequence #24

    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  17. Specify the full path of the online redo log file and press Enter.
  18. Example: E:\app\Administrator\oradata\orcl\redo01.log
  19. Note: You have to specify the full path multiple times until you get the correct log.
  20. The following messages are displayed:

    21. Log applied

    Media recovery complete

  21. Open the database with the RESETLOGS clause after completing the recovery process.

    22. SQL> ALTER DATABASE OPEN RESETLOGS;

    The lost control files are recovered.