Home » Server Options » Data Guard » Roll Forward & Missing Archive logs
Roll Forward & Missing Archive logs [message #185548] Wed, 02 August 2006 05:18 Go to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
Hi ,
On the data guard we have there’s an archive gap which cannot be resolved. Archive logs were deleted with backups sometime ago. I did a roll forward of the standby database using incremental backups as described in the oracle documentation “Oracle Data Guard Concepts and Administration” (Chapter 12, section 12.7).

On the alter log of the standby database I got the messages,

Quote:


The input backup piece /appsrv1/ForStandby_f4hpmqpl_1_1 is in compressed format.Wed Aug 2 19:22:36 2006
The input backup piece /appsrv1/ForStandby_f4hpmqpl_1_1 is in compressed format.Incremental restore complete of datafile 4 /oracle/oradata/liveaus/users.259.584103229
checkpoint is 47617682
Wed Aug 2 19:22:49 2006
Incremental restore complete of datafile 2 /oracle/oradata/liveaus/undotbs1.258.584103229
checkpoint is 47617682
Incremental restore complete of datafile 5 /oracle/oradata/liveaus/undotbs2.264.584103357
checkpoint is 47617682
Wed Aug 2 19:23:03 2006
Incremental restore complete of datafile 1 /oracle/oradata/liveaus/system.256.584103229
checkpoint is 47617682
Incremental restore complete of datafile 3 /oracle/oradata/liveaus/sysaux.257.584103229
checkpoint is 47617682
Incremental restore complete of datafile 6 /oracle/oradata/liveaus/travelbox.268.584353833
checkpoint is 47617682



But the scn of the standby database stays the same after the database recovery is done, and it still request for the missing archive logs when archive log apply is restarted, and no new archive logs get applied (which is obvious since it still asks for missing archive logs).


1. Why is that roll forward is not synchronizing the standby with the primary? Why the scn stays the same?

2. Is there anyway to use this standby database again or is it all over for it?

Thanks for any help you can give

Re: Roll Forward & Missing Archive logs [message #187476 is a reply to message #185548] Mon, 14 August 2006 03:04 Go to previous messageGo to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
how is the roll-forward being done ??

which document are u refering to ??

is this 9i or 10g ??
Re: Roll Forward & Missing Archive logs [message #187494 is a reply to message #187476] Mon, 14 August 2006 04:19 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
i was refering the Oracle Data Guard Concepts and Administration 10g Release 2 (10.2)B14239-01

Re: Roll Forward & Missing Archive logs [message #191489 is a reply to message #185548] Wed, 06 September 2006 10:29 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
In 10.2 you can take incremental rman backup and apply it on standby to bring it to current state if standby is far behind primary.

Sandeep
Re: Roll Forward & Missing Archive logs [message #206597 is a reply to message #185548] Thu, 30 November 2006 13:14 Go to previous messageGo to next message
bogey
Messages: 53
Registered: February 2006
Member
How about if your on 10.1.0.4

We do not have our archive logs on the primary db and need to have the physical failover in sync with the primary
Re: Roll Forward & Missing Archive logs [message #206795 is a reply to message #185548] Fri, 01 December 2006 09:08 Go to previous message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
It came as new feature with 10.2. Please check 10.2 new feature document (section 1.2.3.20)

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14214.pdf


Thanks,
Sandeep
Previous Topic: dataguard broker settings to perform perfect failover and switchover operation
Next Topic: DGMGRL setting
Goto Forum:
  


Current Time: Mon Dec 05 07:05:50 CST 2016

Total time taken to generate the page: 0.24705 seconds