Online backup of a Control File

Can you take online backup of a Control File If yes, How?

Questions by Pragati.rch

Showing Answers 1 - 12 of 12 Answers

fbchua

  • Oct 17th, 2008
 

Yes you could take a online backup of a control file.

SQL> alter database backup controlfile to trace;

This will create a text copy of your controlfile. You could use this text file to recreate your controlfile.

dj_dj_dj

  • Feb 19th, 2010
 

Dear,

      Control file is the backbone of the Oracle Database. It stores structure of the database. Some of the information stored by Control file includes:

1) Startup and shutdown of the database.
2) Log switch and checkpoing information.
3) Tablespace brought online from offline etc...

     As the first point itself states that control file is used even when Database is shutdown. Loss of info from controlfiles require recovery.


Regards
Dharmendra Jaiswal

  Was this answer useful?  Yes

dj_dj_dj

  • Feb 19th, 2010
 

Dear Friends,


      alter database backup control file to trace ------------------- creates a script for recreating the controlfile. It doesn't take backup by any means.



Regards
Dharmendra Jaiswal

  Was this answer useful?  Yes

vishnu1122

  • Feb 19th, 2010
 

I agree that backing up control file to trace is useful when we need to recreate the control file. But at the same time Alter database BACKUP controlfile to Trace is a means of taking backup of control file. In the command itslef we use the word BACKUP... :-)

dj_dj_dj

  • Feb 21st, 2010
 

I do not agree with you. Backup controlfile to trace would create just  a Scripts for recreating the controlfile. It does not backup the controlfile even when the word backup is used in the command. Remind you control file is used even when database is shutdown. It stores complete database structure. Hence it could not be backed up while database is open.

Regards
Dharmendra Jaiswal.

  Was this answer useful?  Yes

jeevith273

  • Aug 25th, 2010
 

Alter database backup controlfile to trace as 'Path/control.ctl'
it backs up the control file to the location specified..
Or else
Controlfile online backup can be done by using RMAN
RMAN> backup current controlfile;

jeevith273

  • Aug 30th, 2010
 

>>Alter database backup controlfile to 'PATH/control.ctl';

The above query will backup the controlfile in binary format which is not editable and can be used for restore and recovery...
or
We can use RMAN to backup a current controlfile

RMAN>backup current controlfile;

  Was this answer useful?  Yes

venu

  • Sep 1st, 2012
 

Code
  1. SQL> ALTER DATABASE backup controlfile TO trace AS <PATH>


Specify the path where you want to store the controlfile backup.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions