Help - Search - Members - Calendar
Full Version: Moving redo log files
Oracle DBA Forums > Oracle > Oracle Forum
Urian
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,
aussie_dba
"I want to move my redo log files."

Online redo or archived redo?

Is this homework?
Steve
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.