1 Reply Latest reply: Oct 12, 2012 6:11 AM by mseberg RSS

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

    OraDB
      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
          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