- Query the current redo locations.
- Shutdown the database.
- Rename the redo log members on the server.
- Startup the database in mount.
- Rename the redo log members in the database.
- Open the database.
- Verify the redo log member names are correct.
MEMBER-------------------------------------------------------------------------------
/u02/oradata/prod/redo01a.log
/u03/oradata/prod/redo01b.rdo
/u02/oradata/prod/redo02a.log
/u03/oradata/prod/redo02b.log
/u02/oradata/prod/redo03a.log
/u03/oradata/prod/redo03b.rdo
6 rows selected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> !mv /u02/oradata/prod/redo01a.log /u02/oradata/prod/redo01a.rdo
SQL> !mv /u02/oradata/prod/redo02a.log /u02/oradata/prod/redo02a.rdo
SQL> !mv /u03/oradata/prod/redo02b.log /u03/oradata/prod/redo02b.rdo
SQL> !mv /u02/oradata/prod/redo03a.log /u02/oradata/prod/redo03a.rdo
SQL> startup mount
ORACLE instance started.
Database mounted.
SQL> alter database rename file '/u02/oradata/prod/redo01a.log' to '/u02/oradata/prod/redo01a.rdo';
Database altered.
SQL> alter database rename file '/u02/oradata/prod/redo02a.log' to '/u02/oradata/prod/redo02a.rdo';
Database altered.
SQL> alter database rename file '/u03/oradata/prod/redo02b.log' to '/u03/oradata/prod/redo02b.rdo';
Database altered.
SQL> alter database rename file '/u02/oradata/prod/redo03a.log' to '/u02/oradata/prod/redo03a.rdo';
Database altered.
SQL> alter database open;
Database altered.
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u02/oradata/prod/redo01a.rdo
/u03/oradata/prod/redo01b.rdo
/u02/oradata/prod/redo02a.rdo
/u03/oradata/prod/redo02b.rdo
/u02/oradata/prod/redo03a.rdo
/u03/oradata/prod/redo03b.rdo
6 rows selected.
No comments:
Post a Comment