Moving Online Redo Log Files


Steps:
  • Shutdown the instance
  • Use operating system commands to move the datafile.
  • Mount the database and use ALTER DATABASE to rename the log file within the database.
  • Opening the Database
% sqlplus "/ as sysdba"
SQL> shutdown immediate
SQL> !mv /u06/app/oradata/OCM/redo_g03a.log /u03/app/oradata/OCM/redo_g03a.log
SQL> !mv /u06/app/oradata/OCM/redo_g03b.log /u04/app/oradata/OCM/redo_g03b.log
SQL> !mv /u06/app/oradata/OCM/redo_g03c.log /u05/app/oradata/OCM/redo_g03c.log
SQL> startup mount
SQL> alter database rename file '/u06/app/oradata/OCM/redo_g03a.log' to '/u03/app/oradata/OCM/redo_g03a.log';
SQL> alter database rename file '/u06/app/oradata/OCM/redo_g03b.log' to '/u04/app/oradata/OCM/redo_g03b.log';
SQL> alter database rename file '/u06/app/oradata/OCM/redo_g03c.log' to '/u05/app/oradata/OCM/redo_g03c.log';
Do not disconnect after this step. Stay logged in and proceed to open the database!
SQL> alter database open;
SQL> exit
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: