how to apply archives in standby [message #473860] |
Wed, 01 September 2010 04:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
krishnavejandla
Messages: 1 Registered: September 2010 Location: Banagalore
|
Junior Member |
![krishnavejandla%40gmail.com](/forum/theme/orafaq/images/twitter.png)
|
|
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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.
|
|
|