|
-
(Assumes oracle software will not be moved.)
1. Shutdown database (normal or immediate)
2. copy all datafiles (from v$datafile) from /u01 to /u02
3. copy all control files (from v$controlfile) from /u01 to /u02
4. copy all log files (from v$logfile) from /u01 to /u02
5. edit init.ora or config.ora and change location of control_files parameter from /u01 control files to /u02 control files.
6. startup mount - the database will now read enough info from the init.ora file to manipulate the control files.
7. alter database rename file '/u01/file1.dbf' to '/u02/file2.dbf' for all your data files and log files.
8. alter database open
9. shutdown
10. startup
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
|