天天看点

How to add one or more control files

How to add one or more control files

When we have one control file, now want to add one or more control files, there is many method to do it,but the better way is:

1.       Shut down the database with NORMAL or IMMEDIATE options.

2.       Copy the single control file to its new location. Rename it if you want or need to.

3.       Modify your INIT.ORA paramter file. Change the CONTROL_FILES parameter to point to both control files.

4.       Startup the database.

It is so simplely,but I think the best way is to hava more controle files that is in difficult folder.

Usually I have three control files for every database.