Moving Online Redo Log Files


SQL> sqlplus "/ as sysdba";

SQL>shut immediate

SQL> exit

bash-3.2$ mv /u01/app/oracle/oradata/ANARDB/redo03.log /data/ANARDB/redolog/redo03.log

bash-3.2$ mv /u01/app/oracle/oradata/ANARDB/redo02.log /data/ANARDB/redolog/redo02.log

bash-3.2$ mv /u01/app/oracle/oradata/ANARDB/redo01.log /data/ANARDB/redolog/redo01.log

bash-3.2$ sqlplus "/ as sysdba";

SQL> startup mount

SQL> alter database rename file '/u01/app/oracle/oradata/ANARDB/redo03.log' to '/data/ANARDB/redolog/redo03.log'; 

SQL> alter database rename file '/u01/app/oracle/oradata/ANARDB/redo02.log' to '/data/ANARDB/redolog/redo02.log';
SQL> alter database rename file '/u01/app/oracle/oradata/ANARDB/redo01.log' to '/data/ANARDB/redolog/redo01.log';
SQL> alter database open
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: