Gaps have occured in the archive logs on my Standby DB (using Dataguard) [message #246566] |
Thu, 21 June 2007 05:51 |
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 #246700 is a reply to message #246669] |
Thu, 21 June 2007 11:42 |
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.
|
|
|
|
|
|
|
|
|
|