Hi Team,
in my standby database archive log is not receiving from primary , But if I copy archive log manually from primary to standby then those logs are used for recover standby database automatically. My query is why archive log is not shipping from primary to standby.
FYI: when I look into standby DB, I got the following errors.
Errors in file /u01/app/oracle/admin/HPSBKN2S/diag/rdbms/hpsbkn2s/HPSBKN2S/trace/HPSBKN2S_mrp0_19761.trc:
ORA-00313: open failed for members of log group 5 of thread 2
ORA-00312: online log 5 thread 2: '/u02/mirrlog/HPSBKN2P/HPSBKN2Predo_t2_g5_m2.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 5 thread 2: '/u02/origlog/HPSBKN2P/HPSBKN2Predo_t2_g5_m1.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
if I list above mentioned trace file, I too getting the same online redo log is unable to obtain file status as folllows.
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u02/origlog/HPSBKN2P/HPSBKN2Predo_t1_g1_m1.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
DDE: Problem Key 'ORA 313' was flood controlled (0x1) (no incident)
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u02/mirrlog/HPSBKN2P/HPSBKN2Predo_t1_g1_m2.dbf'
But above path and online redo logs are primary location and primary online redo log files, why in my standby alert log refering primary online redo log file location and primary db redo log files as well, Hope we may need to change some setting here in standby so that standby should refer stand by redo log with respective locations.
Please advice /support for to fix above issue.
Siva..