OraFAQ Forum: Data Guard » Roll Forward & Missing Archive logs

Home » Server Options » Data Guard » Roll Forward & Missing Archive logs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Roll Forward & Missing Archive logs [message #185548]

Wed, 02 August 2006 05:18

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

Report message to a moderator

Re: Roll Forward & Missing Archive logs [message #187476 is a reply to message #185548]

Mon, 14 August 2006 03:04

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 ??

Report message to a moderator

Re: Roll Forward & Missing Archive logs [message #187494 is a reply to message #187476]

Mon, 14 August 2006 04:19

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

Report message to a moderator

Re: Roll Forward & Missing Archive logs [message #191489 is a reply to message #185548]

Wed, 06 September 2006 10:29

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

Report message to a moderator

Re: Roll Forward & Missing Archive logs [message #206597 is a reply to message #185548]

Thu, 30 November 2006 13:14

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

Report message to a moderator

Re: Roll Forward & Missing Archive logs [message #206795 is a reply to message #185548]

Fri, 01 December 2006 09:08

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

Report message to a moderator

Previous Topic:	dataguard broker settings to perform perfect failover and switchover operation
Next Topic:	DGMGRL setting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 15 20:48:18 CDT 2024