Thursday, November 8, 2007

Moving Control Files in Oracle

1. SQL> alter system set control_files='new_file1_location','new_file2_location','new_file3_location' scope=spfile;
2. SQL> shutdown immediate;
3. move/copy control files to new location
4. SQL> startup

No comments: