Control file Backup

It is very important that you back up your control file, Bacause the control file records the physical structure of the database,you should make a backup of your control file after making changes to the physical structure of the database. You can create backup of control file by using this statement:

 
Alter database backup controlfile '/opt/nit/conback.ctl'

You can also backup of a control file to trace file.

Alter database backup controlfile to trace
 

You backup a control file after any change the physical structure of your database. Such includes as:

• Adding, dropping or renaming datafiles
• Adding or dropping redo log files or group
• Adding or dropping a tablespace 

  You can obtain control file information using these views as follows:

• V$CONTROLFILE
• V$PARAMETER
• V$CONTROLFILE_RECORD_SECTION
• SHOW PARAMETERS CONTROL_FILES

People who read this post also read :

Posted in: Control file