Updating the online redo log file path

You may have to update the online redo log file path during the recovery of a complete Oracle instance or database.

See Recovering the complete Oracle instance or database to a computer other than the original Oracle server.

To update the online redo log file path

  1. At the Oracle server, open a command prompt.

  2. Type the following commands in the order listed:

    • SQLPLUS /nolog

    • connect<sys/password@SID>;

  3. Type the following SQLPlus command:

    SQLPLUS ALTER DATABASE RENAME FILE <old path from backup to any redolog file name> to <path to expected restored redolog file name>;

    For example,

    ALTER DATABASE RENAME FILE ‘D:\ORACLE\ORADATA\JACOB\REDO01.LOG’ to ‘C:\ORACLE\ORADATA\JACOB\REDO01.LOG’;

  4. In the command prompt, type RMAN.

  5. Type the following command at the RMAN prompt:

    Alter database open resetlogs;

  6. Close the command prompt.

Updating the online redo log file path