Moving Online Redo Log Files


SQL> sqlplus "/ as sysdba";
SQL>shut immediate
SQL> exit
bash-3.2$ mv /u01/app/oracle/oradata/PREAZKKDB/redo03.log /data/PREAZKKDB/redolog/redo03.log
bash-3.2$ mv /u01/app/oracle/oradata/PREAZKKDB/redo02.log /data/PREAZKKDB/redolog/redo02.log
bash-3.2$ mv /u01/app/oracle/oradata/PREAZKKDB/redo01.log /data/PREAZKKDB/redolog/redo01.log
bash-3.2$ sqlplus "/ as sysdba";
SQL> startup mount
SQL> alter database rename file '/u01/app/oracle/oradata/PREAZKKDB/redo03.log' to '/data/PREAZKKDB/redolog/redo03.log'; 
SQL> alter database rename file '/u01/app/oracle/oradata/PREAZKKDB/redo02.log' to '/data/PREAZKKDB/redolog/redo02.log'; 
SQL> alter database rename file '/u01/app/oracle/oradata/PREAZKKDB/redo01.log' to '/data/PREAZKKDB/redolog/redo01.log';
SQL> alter database open

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: