Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change the redo log file name of the +data' format?

user11216227Aug 5 2015 — edited Aug 5 2015

RAC restore to the different machines, restore and restore the database, you need to change the file name of the redo log, but the name of the format for '+data' and'+flash', how to change? Who can help me?

SQL> select group#,status,type,IS_RECOVERY_DEST_FILE,member from v$logfile;

group#   status      type     is_recovery_dest_file    member

---------- ------------  ----------   ------------------------------   ---------------

    2     INVALID  ONLINE          NO                     +data

    2     INVALID  ONLINE          YES                   +flash

    2     INVALID  ONLINE          NO                     /u01/app/oracle/oradata/redolog/REDO11.LOG

    3     INVALID  ONLINE          NO                     /u01/app/oracle/oradata/redolog/REDO02.LOG

    3     INVALID  ONLINE          NO                     +data

    3     INVALID  ONLINE          YES                   +flash

    4     INVALID  ONLINE          NO                     +data

    4     INVALID  ONLINE          YES                   +flash

    5     ONLINE                         NO                     /u01/app/oracle/oradata/redologREDO05.LOG

    6     ONLINE                         NO                     /u01/app/oracle/oradata/redologREDO06.LOG

    4     INVALID  ONLINE           NO                     /u01/app/oracle/oradata/redolog/REDO03.LOG

    2     INVALID  ONLINE           NO                     /u01/app/oracle/oradata/redolog/REDO10.LOG

12 rows selected.

SQL> select group#,thread#,members,archived,status,first_change#,next_change# from v$log;

group#  thread#  members  arch    STATUS                      first_change#    next_change#

--------    --------     -----------   ---------   --------------------               ---------------       -------------------

    5         1             1        YES    UNUSED                           0                  0

    2         1             4         NO     CLEARING_CURRENT   5171634         2.8147E+14

    6         1             1        YES    UNUSED                            0                 0

    3         2             3        YES    CLEARING                    5171597           5171638

    4         2             3         NO     CLEARING_CURRENT   5171638         2.8147E+14

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 2 2015
Added on Aug 5 2015
10 comments
2,230 views