how to apply archives in standby [message #473860] |
Wed, 01 September 2010 04:13 |
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 #474829 is a reply to message #473860] |
Thu, 09 September 2010 04:04 |
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.
|
|
|