Home » Server Options » Data Guard » Gaps have occured in the archive logs on my Standby DB (using Dataguard)
Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #246566] Thu, 21 June 2007 05:51 Go to next message
aidi-h
Messages: 45
Registered: November 2005
Member

I currently have a standby DB created using Dataguard which has been running for some time however it appears that at one point, the archive logs were not being applied to the standby server.

Upon investigations, it appears that gaps have occured in the archive logs on the standby server.

I run the following SQL to show whats logs have been applied.,
select sequence#,applied from v$archived_log;, and the important bit of the output says,

.......
SEQUENCE# APP ---------- ---
68447 YES
68448 YES
68449 YES
84718 NO
84719 NO
84720 NO
84721 NO
84722 NO

The alert log on the standby server has the following in it,
"Wed Jun 20 20:40:39 2007
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 68450-68549
DBID 1236265471 branch 597634623
FAL[client]: All defined FAL servers have been attempted."



I've checked in the archive dir on both servers and found that the first sequencial file (file: r_49afe9ff_1_68450_597634623.arc') exists on the primary but not the standby server.

I've copied the file from the primary server into the archive dir on the standby server. I need to manually register the files in the standby database. Do you know how this can be done?
The idea that I have is that once this is done, and hopefully, the file is set to applied = 'YES', I can go about transferring the other archive logs.

Or, is there some way to get the DG broker to look for these file and transfer them automatically?

Any thoughts on this would be appreciated.
Re: Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #246604 is a reply to message #246566] Thu, 21 June 2007 07:56 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
This procedure Manually Determining and Resolving Archive Gaps should help.
Re: Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #246615 is a reply to message #246566] Thu, 21 June 2007 08:32 Go to previous messageGo to next message
aidi-h
Messages: 45
Registered: November 2005
Member
Is there some easy method to get Dataguard to automactically pick up the files where gaps exists and then process/register them on the Standby server.

Someone on a different forum suggested killing off the archive process however I would like other peoples thoughts on this.
Re: Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #246669 is a reply to message #246566] Thu, 21 June 2007 10:58 Go to previous messageGo to next message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

I have removed archive log files from the Standby site (copy them to another directory) and restarted the STandby database before. When using ARCH, the FAL process appeared to detect the missing files and retrieve them. I do NOT know if they were applied, just retrieved. Intuitively, I would say they were NOT (re)applied, because the setting in v$archive_log should still show that they had been applied before.

Note that this only worked when the files were missing from the END of the series (files removed from the middle of a set, say 459-465 in a set of archive logs that end in 650 would NOT be retrieved automatically.

Mike
Re: Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #246700 is a reply to message #246669] Thu, 21 June 2007 11:42 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Is there some easy method to get Dataguard to automactically pick up the files where gaps exists and then process/register them on the Standby server.

Someone on a different forum suggested killing off the archive process however I would like other peoples thoughts on this.


How this gap occur ??archiving problem?

Theres no such a option for filling GAP automatically.
Re: Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #257042 is a reply to message #246700] Tue, 07 August 2007 07:58 Go to previous messageGo to next message
pramodgaree
Messages: 22
Registered: August 2007
Junior Member
how about restarting ur standby DB.....ur FAL won't work until current load on RFS is relieved..so if u restart ur standby DB,u can force FAL n those will be applied automatically.....
Re: Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #257052 is a reply to message #257042] Tue, 07 August 2007 08:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think that if he did not give a feedback for a month and a half he solved his problem.
Don't awake the topic.

Regards
Michel
Re: Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #257087 is a reply to message #257042] Tue, 07 August 2007 10:10 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
pramodgaree wrote on Tue, 07 August 2007 06:58
how about restarting ur standby DB.....ur FAL won't work until current load on RFS is relieved..so if u restart ur standby DB,u can force FAL n those will be applied automatically.....

Is it a good idea every time you will restart and shutdown your standby??
Re: Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #257181 is a reply to message #257087] Tue, 07 August 2007 13:04 Go to previous messageGo to next message
pramodgaree
Messages: 22
Registered: August 2007
Junior Member
ofcourse it's not a good idea..still,if rfs is fetching the frequent logs and not the logs required for MRP,wat's the use of FAL ..i think there is no other option...
Re: Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #310808 is a reply to message #257181] Wed, 02 April 2008 08:22 Go to previous messageGo to next message
abhinavkotnala
Messages: 1
Registered: April 2008
Junior Member
HI

Please check out following link

http://download.oracle.com/docs/cd/B10501_01/server.920/a96653/role_management.htm#1023440

this will help you out to register the archive logs with your DR.

Abhinav Kotnala
Re: Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #310918 is a reply to message #310808] Wed, 02 April 2008 18:57 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
How does a link to Role Management help beyond what has already been offered to a 8-month old thread?
Re: Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #311049 is a reply to message #246566] Thu, 03 April 2008 05:20 Go to previous message
aidi-h
Messages: 45
Registered: November 2005
Member
Many thanks for all the replies guys.
I eventually had to reapply the whole dataguard installation to get things up and running again.
Thanks again
Previous Topic: Remove the standby Database
Next Topic: Unable to apply the recovery in DR
Goto Forum:
  


Current Time: Thu Mar 28 13:14:12 CDT 2024