Creating New Control Files - Oracle Control Files

Q.  What are the following steps used to do?

1) Make a list of all datafiles and redo log files of the database
2) Back up all datafiles and redo log files of the database
3) Start up a new instance, but do not mount or open the database

- Published on 03 Aug 15

a. Creating Initial Control Files
b. Creating Additional Copies, Renaming, and Relocating Control Files
c. Creating New Control Files
d. Both A & B

ANSWER: Creating New Control Files
 

    Discussion

  • Nirja Shah   -Posted on 28 Aug 15
    - Following are the steps used for creating a new control file

    1. Make a list of all datafiles and redo log files of the database.
    2. Shut down the database.
    3. Back up all datafiles and redo log files of the database.
    4. Start up a new instance, but do not mount or open the database.
    5. Create a new control file for the database using the CREATE CONTROLFILE statement.
    6. Store a backup of the new control file on an offline storage device.
    7. Edit the CONTROL_FILES initialization parameter for the database to indicate all of the control files now part of your database as created in step 5 (not including the backup control file). If you are renaming the database, edit the DB_NAME parameter in your instance parameter file to specify the new name.
    8. Recover the database if necessary. If you are not recovering the database, skip to step 9.
    9. Open the database using one of the following methods:
    - If you did not perform recovery, or you performed complete, closed database recovery in step 8, open the database normally.
    ALTER DATABASE OPEN;
    - If you specified RESETLOGS when creating the control file, use the ALTER DATABASE statement, indicating RESETLOGS.
    ALTER DATABASE OPEN RESETLOGS;

    - Creating Initial Control Files - The initial control files of an Oracle Database are created when you issue the CREATE DATABASE statement.
    - The names of the control files are specified by the CONTROL_FILES parameter in the initialization parameter file used during database creation.
    - The filenames specified in CONTROL_FILES should be fully specified and are operating system specific.

    - Creating Additional Copies, Renaming, and Relocating Control Files - You can create an additional control file copy for multiplexing by copying an existing control file to a new location and adding the file name to the list of control files.
    - Similarly, you rename an existing control file by copying the file to its new name or location, and changing the file name in the control file list.
    - In both cases, to guarantee that control files do not change during the procedure, shut down the database before copying 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.)