Dataguard is not working properly [message #552165] |
Tue, 24 April 2012 01:28 |
|
nilesh_pawaskar
Messages: 16 Registered: April 2012 Location: Mumbai
|
Junior Member |
|
|
Dear All
We are facing a one problem in dataguard,Due to some reason, maximum no of archived log are not applied ,All my dataguard configuration seems to be valid as tnsping is happening between 2 systems successfully but in alert and trace file we have found this error log,pls help
From dataguard alter.lof
Completed: ALTER DATABASE RECOVER managed standby database cancel
Tue Apr 24 11:44:43 2012
alter database recover managed standby database disconnect from session
MRP0 started with pid=18, OS id=3040
Managed Standby Recovery not using Real Time Apply
parallel recovery started with 2 processes
Tue Apr 24 11:44:49 2012
Waiting for all non-current ORLs to be archived...
Tue Apr 24 11:44:50 2012
Errors in file d:\oracle\product\10.2.0\admin\goa\bdump\goastby_mrp0_3040.trc:
ORA-00367: checksum error in log file header
ORA-00305: log 1 of thread 1 inconsistent; belongs to another database
ORA-00312: online log 1 thread 1: 'E:\ORACLE\ORADATA\DATA\REDO01.LOG'
Clearing online redo logfile 1 E:\ORACLE\ORADATA\DATA\REDO01.LOG
Clearing online log 1 of thread 1 sequence number 39689
Tue Apr 24 11:44:50 2012
Errors in file d:\oracle\product\10.2.0\admin\goa\bdump\goastby_mrp0_3040.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: 'E:\ORACLE\ORADATA\DATA\REDO01.LOG'
From goastby_mrp0_3040.trc:
ORA-00367: checksum error in log file header
ORA-00305: log 1 of thread 1 inconsistent; belongs to another database
ORA-00312: online log 1 thread 1: 'E:\ORACLE\ORADATA\DATA\REDO01.LOG'
*** 2012-04-23 12:32:34.874 62692 kcrr.c
Clearing online redo logfile 1 E:\ORACLE\ORADATA\DATA\REDO01.LOG
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: 'E:\ORACLE\ORADATA\DATA\REDO01.LOG'
Error 19527 creating/clearing online redo logfile 1
*** 2012-04-23 12:32:35.721 62692 kcrr.c
Clearing online redo logfile 1 complete
*** 2012-04-23 12:32:36.646 62692 kcrr.c
Media Recovery Waiting for thread 1 sequence 39690
|
|
|
|
|
Re: Dataguard is not working properly [message #552176 is a reply to message #552173] |
Tue, 24 April 2012 02:20 |
John Watson
Messages: 8932 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Well, I would think that the best approach would be to flashback the standby to before the problem occurred, make sure that all necessary archivelogs are available in the correct places on the primary, and startup redo transport and apply. The gap resolution mechanism should allow the standby to recover.
Of course, if someone did something silly (copying files manually, perhaps?) then you might have to re-create the standby. Good luck.
|
|
|
|
|
|
Re: Dataguard is not working properly [message #552187 is a reply to message #552186] |
Tue, 24 April 2012 03:56 |
John Watson
Messages: 8932 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Er.... you are paid to do this, I'm not.
You say that you created the standby successfully before, so create it again. I always do it with RMAN, as described in the docs. You do not need any downtime on the primary.
|
|
|