|
-
Originally posted by Rohit
Hi
Shutdown the database
Copy the file to the new location
Startup mount
Alter database rename file 'old path' to 'new path';
Alter datbase open;
Query the V$logfile
This is a case study of how NOT to do it in a 24x7 environment.
1. add new log files in your new location.
2. switch logfile until you are using one of your new log files.
3. drop the old log files.
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
|