Home » Server Options » Data Guard » how to apply archives in standby (10.2.0.2)
how to apply archives in standby [message #473860] Wed, 01 September 2010 04:13 Go to next message
krishnavejandla
Messages: 1
Registered: September 2010
Location: Banagalore
Junior Member

hi
i have attended an interview there i got a question like
--->There are 100 archives generated in standby in that a series of five archives are missing and those are not available in the primary then how will you do.....
Re: how to apply archives in standby [message #473966 is a reply to message #473860] Wed, 01 September 2010 11:48 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>then how will you do....
& your answer is/was what?
Re: how to apply archives in standby [message #474829 is a reply to message #473860] Thu, 09 September 2010 04:04 Go to previous message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Take the current scn from standby

SQL>select current_scn from v$database.
This is the current SCN at standby.

Take incremental backup of primary database begining from that SCN.
ie

RMAN>backup incremental from scn <current_scn_at _standby>;

Apply the incremental backup at standby.
Previous Topic: logical stand by on windows server 2008
Next Topic: Need help with dataguard installation
Goto Forum:
  


Current Time: Thu Apr 18 16:32:25 CDT 2024