Updating the online redo log file path

Article:HOWTO73905  |  Created: 2012-03-02  |  Updated: 2014-01-02  |  Article URL http://www.symantec.com/docs/HOWTO73905
Article Type
How To


Subject


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.

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.



Legacy ID



v53940529_v71805793


Article URL http://www.symantec.com/docs/HOWTO73905


Terms of use for this information are found in Legal Notices