How to recover Control file in oracle

/* I have already backup control file to trace */

SQL> ALTER DATABASE BACKUP CONTROLFILE TO trace;

/* modify and run your trace file and your control file is up to date */

SQL> STARTUP MOUNT;

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE;

SQL> ALTER DATABASE OPEN;

Up the database

Advertisements

7 thoughts on “How to recover Control file in oracle

  1. Hello All,
    I want to backup my control file into a specific location. I issued the
    command ‘ALTER DATABASE BACKUP CONTROLFILE TO TRACE’. The statement executed
    fine and I could see the trace file in trace location. Now I want to backup
    my control file to a specific location, I issued the following query: ‘ALTER
    DATABASE BACKUP CONTROLFILE TO c:\controlfile.bkp’. This statement is
    creating a binary file at the specified location which I do not want. Can
    any one give me a solution?

  2. You have done the right thing by backing up the control file in trace. Trace file can be read. But if you backup your control file to a location then it will be in binary format.
    And by your question it is not clear that what you dont want. Is it that you dont want to backup the control file at the specified location or you dont want the binary file to be created.
    If it is second that you dont want to happen then it is not possible I guess.

  3. if u dont want binary format means you should give command like alter database backup controlfile to trace as ” /path”;

  4. SQL> ALTER DATABASE BACKUP CONTROLFILE TO trace;

    if i use this command where can i find that backup file i mean any one can tell me location or path

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s