Hi guys,

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
4. Rename
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.


Than YOU,

"I want to move my redo log files."

Online redo or archived redo?

Is this homework?

Urian,

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.