This discussion is archived
1 Reply Latest reply: Aug 2, 2013 5:41 AM by mseberg RSS

Facing issues in standby database

Dharamoni Newbie
Currently Being Moderated

standby database is in sync but when we say archive log list "Current log sequence " and "Oldest online log sequence" are not geting updated
even though archives are getting applied.

Solution :- We can create new standby controlfile in order to get those archive sync .

 

Question :- why we are still receiving alert log errors when the standby database is running in Max performance? We have these standby files from so many days but  recently we are able to see these errors

Any help regarding this is much appreciate.

 

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /ofa/u001/PRMAN/app/oracle/admin/arch
Oldest online log sequence 179147
Next log sequence to archive 0
Current log sequence 179149
--------------------------------------------------------------------------

Standby alert log error message:-
*********************************

Media Recovery Log /ofa/u001/PRMAN/app/oracle/admin/arch/1_189733_608563408.dbf
Clearing online log 6 of thread 0 sequence number 0
Errors in file /ofa/u001/PRMAN/app/oracle/admin/diag/rdbms/prmangfd/PRMAN/trace/PRMAN_ora_18720.trc:
ORA-00367: checksum error in log file header
ORA-00315: log 6 of thread 0, wrong thread # 1 in header
ORA-00312: online log 6 thread 0: '/ofa/u001/PRMAN/oradata/redologs1/stbyredo03.log'
RFS[16]: Opened log for thread 1 sequence 189734 dbid 1005584078 branch 608563408
Media Recovery Waiting for thread 1 sequence 189734 (in transit)
Mon Jul 29 12:06:03 2013
Archived Log entry 13297 adde

Trace file info:-
******************
ORA-00367: checksum error in log file header
ORA-00315: log 6 of thread 0, wrong thread # 1 in header
ORA-00312: online log 6 thread 0: '/ofa/u001/PRMAN/oradata/redologs1/stbyredo03.log'
DDE rules only execution for: ORA 312

 

Standby sync status:-
**********************

DB_NAME HOSTNAME LOG_ARCHIVED LOG_APPLIED APPLIED_TIME LOG_GAP
-------- ------------ ------------ ----------- ------------ -------
PRMAN GFDHP122 176449 189700 29-JUL/10:29 -13251


Primary:-
*********

DB_NAME HOSTNAME LOG_ARCHIVED LOG_APPLIED APPLIED_TIME LOG_GAP
-------- ------------ ------------ ----------- ------------ -------
PRMAN NGMHP121 189702 189700 29-JUL/10:41 2

standby redo logs :-
*******************

select group#, dbid, thread#, blocksize,used, status, sequence# from v$standby_log
/

GROUP# DBID THREAD# BLOCKSIZE USED STATUS SEQUENCE#
----- ------------------------------ ---------- ---------- ---------- ---------- ----------
4 UNASSIGNED 0 1024 0 UNASSIGNED 0
5 UNASSIGNED 0 1024 0 UNASSIGNED 0
6 UNASSIGNED 0 1024 0 UNASSIGNED 0

Members of standby redo log file:-
**********************************
select * from v$logfile where type='STANDBY'
SQL> /

GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
4 STANDBY /ofa/u001/PRMAN/oradata/redologs1/stbyredo01.log NO
5 STANDBY /ofa/u001/PRMAN/oradata/redologs1/stbyredo02.log NO
6 STAND

 

Thanks,

Kumar Dharamoni
 
     

 
 
     

 
     

 
  

 


   

Legend

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