Home » Server Options » Data Guard » how to force FAL
how to force FAL [message #257038] Tue, 07 August 2007 07:47 Go to next message
pramodgaree
Messages: 22
Registered: August 2007
Junior Member
My scenario is that,for my physical standby database some times some logs will be missing as we will defer dest for sometime for various reasons.....when destination is enabled obviously MRP will be waiting for those missed logs....FAL will be generated....but the problem is,as at this point of time log generation is still there...it is giving preference to fetch frequently generaed logs instead of FAL....so my MRP is been waiting until i transfer those missed logs manually...to force FAL i have been shutting down my standby coz after startup it is fetching missed logs by FAL....i want to do this with out shuttingdown db...is there any way to force FAL to fetch logs..i.e,as it is giving prerference to trnsfer frequently generated logs,in tht time can i force FAL to get my missed logs quickly...if so plz tell me how....thx in advance....
Re: how to force FAL [message #257086 is a reply to message #257038] Tue, 07 August 2007 10:08 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Post your oracle Version?
Re: how to force FAL [message #257179 is a reply to message #257038] Tue, 07 August 2007 12:58 Go to previous messageGo to next message
pramodgaree
Messages: 22
Registered: August 2007
Junior Member
oracle 9i...9.2.0.7.0 to be precise....
Re: how to force FAL [message #257195 is a reply to message #257179] Tue, 07 August 2007 13:26 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Use standby redologs for maximum protection.

[Updated on: Tue, 07 August 2007 13:26]

Report message to a moderator

Re: how to force FAL [message #257250 is a reply to message #257038] Tue, 07 August 2007 21:19 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may want to review some of the bugs listed on Metalink that address this issue. The common consensus is to restart the standby database.
Previous Topic: recovery parameters confusion
Next Topic: Starting Dataguard failed
Goto Forum:
  


Current Time: Thu Mar 28 09:27:19 CDT 2024