This content has been marked as final. Show 4 replies
The standby database.. which is out of sync with the primary and it has neary 1300 archive logs missing ..Here as per your above archive GAP, there is around 1200+ archives,
here is the log sequence gap.
20:19:36 SYS@CALE_P> SELECT max(sequence#) AS "STANDBY", applied FROM v$archived_log GROUP BY applied;
2 rows selected.
we have a setup where the archive logs are recovered to the standby and then backed up to the TSM storage then deleted from the archive destination . some how some of the logs are not applied to the standby DB and they are deleted.
we need to get the logs from the TSM and then applied to the standby to make it in sync with the primary.
My question is how do we find which logs are missing or not applied .
and how do we need to get it back from the TSM storage and how do we need to restore and recover the standby DB.
You have to restore on standby directly thats fine, if not it has to transport over network.
Can you confirm those all the archives physically exist or not?
If really there is a huge GAP, i suggest you to go with Incremental Rollforward
Here is my article to recover standby http://www.oracle-ckpt.com/rman-incremental-backups-to-roll-forward-a-physical-standby-database-2/
Helios- Gunes EROL wrote:Thank you very much helios.. :)
Here is my article to recover standby http://www.oracle-ckpt.com/rman-incremental-backups-to-roll-forward-a-physical-standby-database-2/Nice entery ;)