This discussion is archived
6 Replies Latest reply: Oct 20, 2012 1:07 PM by $phinx19 RSS

All Control File lost

$phinx19 Newbie
Currently Being Moderated
Hi ,

I know this question must have been asked several time. I just want to know the many ways in which we can have a DB up and running even if we do not have any backup of control file not even the trace of the same.

BR
Sphinx
  • 1. Re: All Control File lost
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    If you have backup controlfile to trace then :
    --assume script name is : osama.sql
    sql>startup nomount
    sql>@ osama.sql
    sql> recover database using backup controlfile;
    sqL. alter database open resetlogs;
    If no backup control file trace available then :
    sqL> ALTER DATABASE BACKUP CONTROLFILE TO trace;
    THEN
    sql> @osama.sql
    sql> recover database using backup controlfile;
    sqL. alter database open resetlogs;
  • 2. Re: All Control File lost
    vlethakula Expert
    Currently Being Moderated
    recreate control file using CREATE CONTROLFILE
  • 3. Re: All Control File lost
    Marco V. Expert
    Currently Being Moderated
    There could be several scenarios...

    - Your RMAN backup setting was configured using AUTOBACKUP ON;
    - You have flash recovery area enabled;
    - No Recovery Catalog:
    SQL> startup nomount;
    [oracle@localhost /]$ rman target /
    RMAN> restore controlfile from autobackup;
    RMAN> alter database mount;
    RMAN> recover database;
    RMAN> alter database open resetlogs;
    or
    - Your RMAN backup setting was configured using AUTOBACKUP OFF;
    - You have flash recovery area enabled;
    - No Recovery Catalog:
    SQL> startup nomount;
    [oracle@localhost /]$ rman target /
    RMAN> restore controlfile from 'path_of_a_backup_piece_containing_a_control_file';
    RMAN> alter database mount;
    RMAN> recover database;
    RMAN> alter database open resetlogs;
    or
    - Your RMAN backup setting was configured using AUTOBACKUP ON;
    - You have flash recovery area disabled;
    - No Recovery Catalog:
    SQL> startup nomount;
    [oracle@localhost /]$ rman target /
    RMAN> set dbid 1234567890;
    RMAN> restore controlfile from autobackup;
    RMAN> alter database mount;
    RMAN> recover database;
    RMAN> alter database open resetlogs;
    or
    - Your RMAN backup setting was configured using AUTOBACKUP ON and a non default format (example /MY_BACKUP);
    - You have flash recovery area disabled;
    - No Recovery Catalog:
    SQL> startup nomount;
    [oracle@localhost /]$ rman target /
    RMAN> set dbid 1234567890;
    RMAN> set controlfile autobackup format for device type to '/MY_BACKUP/%F'
    RMAN> restore controlfile from autobackup;
    RMAN> alter database mount;
    RMAN> recover database;
    RMAN> alter database open resetlogs;
    or
    - Your RMAN backup setting was configured using AUTOBACKUP OFF;
    - You have flash recovery area disabled;
    - No Recovery Catalog:
    SQL> startup nomount;
    [oracle@localhost /]$ rman target /
    RMAN> restore controlfile from '/app/oracle/product/11.2.0/dbhome_1/dbs/backup_piece';
    RMAN> alter database mount;
    RMAN> recover database;
    RMAN> alter database open resetlogs;
    or
    - Your RMAN backup setting was configured using AUTOBACKUP OFF and a non default format (example /MY_BACKUP);
    - You have flash recovery area disabled;
    - No Recovery Catalog:
    SQL> startup nomount;
    [oracle@localhost /]$ rman target /
    RMAN> restore controlfile from '/MY_BACKUP/backup_piece';
    RMAN> alter database mount;
    RMAN> recover database;
    RMAN> alter database open resetlogs;
    or
    - Recovery Catalog available:
    SQL> startup nomount;
    [oracle@localhost /]$ rman target /
    RMAN> connect catalog rman/rman@rmancat;
    RMAN> restore controlfile;
    RMAN> alter database mount;
    RMAN> recover database;
    RMAN> alter database open resetlogs;
  • 4. Re: All Control File lost
    Marco V. Expert
    Currently Being Moderated
    Here a link about the loss of a subset of control files
    http://dbaworkshop.blogspot.it/2012/10/how-to-restore-from-loss-of-subset-of.html

    The previous scenarios I mentioned in my above post will be available soon....
  • 5. Re: All Control File lost
    Aman.... Oracle ACE
    Currently Being Moderated
    $phinx19 wrote:
    Hi ,

    I know this question must have been asked several time. I just want to know the many ways in which we can have a DB up and running even if we do not have any backup of control file not even the trace of the same.
    This chapter from Backup and Recovery guide should cover all the cases of the control file's loss , including the one that you have mentioned.
    http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV90045

    Aman....
  • 6. Re: All Control File lost
    $phinx19 Newbie
    Currently Being Moderated
    Hi All,

    Thanks a lot.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points