If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > Data guard: Re-synchronize standby database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-29-10, 09:35
djuritz djuritz is offline
Registered User
 
Join Date: Sep 2005
Posts: 67
Data guard: Re-synchronize standby database

Hi all,

I had a problem with a standby database, it was off during several days.
Now there is a gap of more than one week between the primary and standby.

I have all the archive logs generated during those days.

The question iso I have to manually copy all archive logs to be applied on standby or the archiver can do that for me ?
I mean to copy remaining archive logs to standby and then apply them.
How do I instruct archiver to copy archives from primary to standby?

Thanks a lot
Reply With Quote
  #2 (permalink)  
Old 07-29-10, 11:59
LKBrwn_DBA LKBrwn_DBA is offline
Registered User
 
Join Date: Jun 2003
Location: West Palm Beach, FL
Posts: 2,455
Cool By hand?

If archiver did not copy them automatically when created, you need to copy manually.
__________________
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
Reply With Quote
  #3 (permalink)  
Old 07-29-10, 12:34
djuritz djuritz is offline
Registered User
 
Join Date: Sep 2005
Posts: 67
Hi,

I checked alert log of standby and found the following:

FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 4240-4294
DBID 767729917 branch 705494287
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.

FAL is not configured, but I cannot stop the primary database.
Is it mandatory to have FAL client and server configured to automastically resolve gaps ?

Thanks
Reply With Quote
  #4 (permalink)  
Old 07-29-10, 14:16
LKBrwn_DBA LKBrwn_DBA is offline
Registered User
 
Join Date: Jun 2003
Location: West Palm Beach, FL
Posts: 2,455
Cool Dynamic parms

FAL_SERVER and FAL_CLIENT are dynamic parameters that can be set with "ALTER SYSTEM" -- no recycle db necessary.
__________________
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On