CONTROLFILE REUSE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: CONTROLFILE REUSE

  1. #1
    Join Date
    May 2002
    Posts
    15
    This command is often suggested eg. during database creation, or controlfile creation (when cloning a database).

    But I don't understand what the 'REUSE' keyword actually does. Is it somehow 're-using' an existing controlfile, but if so, which one?

    Or.....does it always follow the CONTROLFILE command?

    Cheers,
    Don

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    CONTROLFILE REUSE Clause
    Specify CONTROLFILE REUSE to reuse existing control files identified by the initialization parameter CONTROL_FILES, thus ignoring and overwriting any information they currently contain. Normally you use this clause only when you are re-creating a database, rather than creating one for the first time. You cannot use this clause if you also specify a parameter value that requires that the control file be larger than the existing files. These parameters are MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES.

    If you omit this clause and any of the files specified by CONTROL_FILES already exist, Oracle returns an error.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width