Backing Up Control Files - Oracle 10g

Use the ALTER DATABASE BACKUP CONTROLFILE statement to back up your control files. You have two options:

  1. 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';
  2. 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.

Recovering a Control File Using a Current Copy

This section presents ways that you can recover your control file from a current backup or from a multiplexed copy.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 10g Topics