Wednesday, April 16, 2008

Relocating and Renaming Redo Log Members

1.Shut down the database.
SQL>conn / as sysdba
SQL>SHUTDOWN IMMEDIATE;

2.Copy the redo log files to the new location. You can use OS tools or you can use DBMS_FILE_TRANSFER package.

!mv /oradata1/redo1.log /oradata2/redo1.log

3.Start database in Mount stage but don't Open it.

SQL>Startup mount

4.Rename the redo log members.

ALTER DATABASE RENAME FILE '/oradata1/redo1.log' TO '/oradata2/redo1.log'

5.Open the database.

The redo log alterations take effect when the database is opened.

SQL>ALTER DATABASE OPEN;

Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)