Re: Clustering Server - How to move database

My suggestion:

1. Perform cold backup of database.
2. Create text backup of control file w/ alter database backup controlfile to trace, just in case. Print it out.
3. shutdown immediate database;
4. perform OS disk mount point name changes. Assuming only the disk mount point names have been changed .... then:
5. edit config$SID.ora and/or init$SID.ora files for control file, bdump, cdump, udump, and archive log disk locations.
6. Startup mount database;
7. rename all files, including redo logs to point to new mount point locations. If you get an error, then you have made a typo or the file is missing.
8. alter database open;

Have fun... Received on Sat Jul 17 1999 - 10:57:08 CDT