Thursday 22 May 2014

Creating backup control file


How to create backup control file?

Control file is a binary file that consists of database structure, RMAN backup information, SCN number etc. But we can backup that file either into readable format or in to regular binary format.

Backing up control file to trace location in binary format:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;   -->the created backup file in this process will be stored in user_dump_dest location with random name
ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/backup/control.bkp';    -->the created backup file in this process will be stored in /oracle/backup/ path with control.bkp name   

Backing up control file to trace location in Readable format:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '\u01\dba\my_control.sql';    -->the created backup file in this process will be stored in /u01/dba/ path with my_control.sql file name 
We can read the database structure (CRD files, sizes, locations, SCN and RMAN information) in my_control.sql file in text format. This helps us in recreating control file whenever we lost control file from it's location.


No comments:

ORA-600 [kwqitnmphe:ltbagi], [1], [0] reported in the alert log file.

ORA-00600 [kwqitnmphe:ltbagi] Cause: This issue arises in 12.1.0.2. The error occurs because there are still Historical Messages without...