Back up Control Files structural changes - Oracle Control Files

Q.  Which files do the following structural changes occur?

1) Adding, dropping or renaming datafiles
2) Adding or dropping a tablespace, or altering the read / write state of the tablespace
3) Adding or dropping redo log files or groups

- Published on 12 Aug 15

a. Manage the Size of Control Files
b. Back up Control Files
c. Provide Filenames for the Control Files
d. All Mentioned above

ANSWER: Back up Control Files

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 28 Aug 15
    -The following is used to manage the control files for a database:

    - Back up control files - It is very important that you back up your control files.
    - This is true initially and everytime you change the physical structure of your database.
    - Such structural changes include:
    1. Adding, dropping or renaming datafiles
    2. Adding or dropping a tablespace, or altering the read / write state of the tablespace
    3. Adding or dropping redo log files or groups

    - Manage the size of control files - The main determinants of the size of the a control file are the values set for the MAXDATAFILES , MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY and MAXINSTANCES parameters in the Create Database statement that created the associated database.
    -Increasing the values of these parameters increses the size of a control file of the associated database.

    - Provide Filenames for the Control Files - You can specify control file names using the CONTROL_FILES initialization parameter in the database initialization parameter file.
    - The instance recognizes and opens all the listed file during startup and the instance writes to and maintains all listed control files during database operation.

➨ 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.)
▲