This discussion is archived
1 Reply Latest reply: Oct 12, 2012 4:11 AM by mseberg RSS

member's of v$logfile shows broken in standby database

OraDB Newbie
Currently Being Moderated

DB: - 64 bit
OS: OEL 6.3 64 bit

just now i set up the physical standby database using rman duplicate.....
while duplicating i received this error...but i ignored...that error...
RMAN-05535: WARNING: All redo log files were not defined properly.
after finishing the duplication...i checked the v$logfile in standby database..
SQL> select member from v$logfile;


6 rows selected.
how to solve this issue?

  • 1. Re: member's of v$logfile shows broken in standby database
    mseberg Guru
    Currently Being Moderated

    Most likely you don't have DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT in the standby INIT file.

    Example here :

    ( see Step 4: Create an Initialization Parameter File for the Auxiliary Instance )

    LOG_FILE_NAME_CONVERT=('/u01/app/oracle/flash_recovery_area/RECOVER2', '/u01/app/oracle/flash_recovery_area/RECLONE')
    You can have more than one location as long as you add them in groups of two. (Before, After)

    My duplicate notes are :

    duplicate for standby fails with RMAN-05535 when path the same as primary [ID 783113.1]

    Best Regards


    Edited by: mseberg on Oct 12, 2012 6:03 AM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points