Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: Backup & Restoration of Control Files using RMAN

  1. #1

    Post Backup & Restoration of Control Files using RMAN

    Using Autobackup of Control Files :

    Use the configure command to enable automatic backups of the control file :
    RMAN> configure controlfile autobackup on;

    Unfortunately, If all the control files are lost , then we use RMAN to restore the controls files.

    First connect to the target database , then issue a startup nomount command and lastly, restore controlfiles from autobackup command :

    RMAN> connect target /
    RMAN> startup nomount;
    RMAN> restore controlfile from autobackup;

    Anytime we restore a control file from a backup, we are required to perform media recovery on the entire database and then open it with the open resetlogs command. This is true even if we don’t restore any datafiles (because the control file’s SCN is no longer synchronized with the SCNs in the datafiles
    and online redo log files).

    RMAN>sql 'alter database mount';

    RMAN> recover database;

    RMAN>sql 'alter database open':

    released channel: ORA_DISK_1
    sql statement: alter database open
    RMAN-00571: ================================================== =========
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ================================================== =========
    RMAN-03009: failure of sql command on default channel at 11/02/2011 23:54:49
    RMAN-11003: failure during parse/execution of SQL statement: alter database open
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


    RMAN>sql 'alter database open resetlogs';

    Regards
    Sandeep
    Last edited by Hemant; 11-03-2011 at 06:41 PM.

  2. #2
    Oracle DBA
    Join Date
    Oct 2011
    Posts
    11
    Good post Sandy......it's helpful.
    Last edited by Hemant; 11-03-2011 at 06:42 PM.

+ Reply to Thread

Similar Threads

  1. RECOVERY SCENARIO: Complete loss of all database files including SPFILE using RMAN
    By devesh_ocp in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 04-25-2012, 10:26 AM
  2. RMAN Backup , List ,Configure and Report Backups
    By Hemant in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 4
    Last Post: 02-10-2012, 02:36 PM
  3. RMAN All major Restoration and Recovery Scenarios
    By Hemant in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 2
    Last Post: 02-05-2012, 11:29 AM
  4. Replies: 0
    Last Post: 01-01-2012, 04:59 PM
  5. Regarding Rman backup retention policy
    By ajaysingh in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 3
    Last Post: 11-09-2011, 07:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics