Skip to Main Content

Database Software

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!

Errors in Standby Alert Log

RiazFeb 18 2013 — edited Feb 23 2013
Dear All,

We have 10gR2 RAC with Physical Data Guard environment using ASM and both have same disk group names. Lets say the primary database name is prim and stand by database name is stdby. We are getting the following errors in alert log file of standby:
Clearing online redo logfile 9 +DG_DATAFILES_AND_FB/prim/onlinelog/group9_2a.rdo
Clearing online log 9 of thread 2 sequence number 0

Errors in file c:\oracle\product\10.2.0\admin\stdby\bdump\stdby1_mrp0_4288.trc:
ORA-00313: Message 313 not found; No message file for product=RDBMS, facility=ORA; arguments: [9] [2]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [9] [2] [+DG_DATAFILES_AND_FB/prim/onlinelog/group9_2a.rdo]
ORA-17503: Message 17503 not found; No message file for product=RDBMS, facility=ORA; arguments: [2] [+DG_DATAFILES_AND_FB/prim/onlinelog/group9_2a.rdo]
ORA-15173: entry 'prim does not exist in directory '/'


Errors in file c:\oracle\product\10.2.0\admin\stdby\bdump\stdby1_mrp0_4288.trc:
ORA-00344: Message 344 not found; No message file for product=RDBMS, facility=ORA; arguments: [+DG_DATAFILES_AND_FB/prim/onlinelog/group9_2a.rdo]
ORA-17502: Message 17502 not found; No message file for product=RDBMS, facility=ORA; arguments: [4] [+DG_DATAFILES_AND_FB/prim/onlinelog/group9_2a.rdo]
ORA-15173: entry 'prim' does not exist in directory '/'
The errors show that the standby is trying to find files in directory +DG_DATAFILES_AND_FB/prim/onlinelog which apparently doesn’t exist on standby. Below is the result of query for redo logs on standby:
SQL> SELECT group#, status, member FROM v$logfile where member like '%prim/%'
/

    GROUP#   STATUS         MEMEBER
    ----------     -------            ---------------------------------------------------------------------------------
         9                            +DG_DATAFILES_AND_FB/prim/onlinelog/group9_2a.rdo
         1                            +DG_DATAFILES_AND_FB/prim/standbylogs/sredo1.rdo
        10                           +DG_DATAFILES_AND_FB/prim/onlinelog/group10_1a.rdo
         2                            +DG_DATAFILES_AND_FB/prim/standbylogs/sredo2.rdo
         3                            +DG_DATAFILES_AND_FB/prim/standbylogs/sredo3.rdo
         4                            +DG_DATAFILES_AND_FB/prim/standbylogs/sredo4.rdo
        11                           +DG_DATAFILES_AND_FB/prim/onlinelog/group11_1a.rdo
        12                           +DG_DATAFILES_AND_FB/prim/onlinelog/group12_2a.rdo

8 rows selected.  
How we can get rid of this error?

Best regards,
This post has been answered by CKPT on Feb 21 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2013
Added on Feb 18 2013
24 comments
10,797 views