Back up the control file to a binary file - Oracle Control Files

Q.  Back up the control file to a binary file (duplicate of existing control file) using the following statement

ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/backup/control.bkp';

- Published on 04 Aug 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 28 Aug 15
    - Use the ALTER DATABASE BACKUP CONTROLFILE statement to back up your control files. You have two options:

    - Back up the control file to a binary file (duplicate of existing control file) using the following statement:

    ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/backup/control.bkp';

    - Produce SQL statements that can later be used to re-create your control file:

    ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

    - This command writes a SQL script to the database trace file where it can be captured and edited to reproduce the control file.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)