How to move control files?(m39)


I need to move my control files to a different file system. Is it as simple as shutting down the database, move the control files, change the control file parameter in init.ora and restarting the database?


Ans:

To Multiplex or Move Additional Copies of the Current Control File

1. Shutdown the database.

2. Exit Server Manager.

3. Copy an existing control file to a different location, using operating system commands.

4. Edit the CONTROL_FILES parameter in the database's parameter file to add the new control file's name, or to change the existing control filename.

5. Restart Server Manager.

6. Restart the database.
 

Hosted by www.Geocities.ws

1