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
Friends,

DB: 11.2.0.3 - 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;

MEMBER
--------------------------------------------------
/u01/app/oracle/product/11.2.0/db_1/dbs/broken2
/u01/app/oracle/product/11.2.0/db_1/dbs/broken1
/u01/app/oracle/product/11.2.0/db_1/dbs/broken0
/u01/app/oracle/product/11.2.0/db_1/dbs/broken3
/u01/app/oracle/product/11.2.0/db_1/dbs/broken4
/u01/app/oracle/product/11.2.0/db_1/dbs/broken5

6 rows selected.
how to solve this issue?

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

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

    Example here :

    http://www.visi.com/~mseberg/rman/diff_database_duplicating.html

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

    Example
    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 :

    http://www.visi.com/~mseberg/duprman2.html

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

    Best Regards

    mseberg

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

Legend

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