|
-
Moving control files is an easy thing to do:
1. look in your init.ora file for the control_files parameter. All control files should be listed there.
2. Shutdown the database
3. copy each file to its new location (cp /u01/control01.ctl /u02/control01.dbf)
4. compare the control files to make sure they were not corrupted by the copy (diff /u01/control01.dbf /u02/control01.dbf)
5. edit the init.ora file to tell the database where to find the control files
6. start the database
Note: The control file contains vital information about the state of the database. I like to have three copies of the control file; each on a seperate disk/controller pair.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|