Jun 30 2008, 07:35 AM
I want to move my redo log files. is this the correct way to do it.
1. Shutdown the database.
2. Copy (not move) the redo log files from the old location to the new location using OS command.
3. Startup & mount the database but do not open.
SQL> Startup mount
SQL> Alter database rename file
'c:\source_loc\redo01.log' to 'd:\dest_loc\redo01.log';
5. Now open the database
SQL> Alter database open.
Jun 30 2008, 07:45 AM
"I want to move my redo log files."
Online redo or archived redo?
Is this homework?
Jun 30 2008, 08:05 AM
That is one way of doing it. Another is to create new redo log groups in the new location with "alter database add logfile group", then switch logs until you are using only the new groups. Once done you can drop the old redo logs with "alter database drop logfile group" and clean up the OS files.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here