Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find the initial archive sequence needed for a recovery ?

664254Mar 14 2009 — edited Mar 17 2009

Hi All ,

Do we have any view / or someother methods to find out the accurate "start-time" of recovery that a "online" RMAN backup is going to prompt ?

to elaborate above point

i have a full rman online backup taken (say : march 1) i restored that and i want to find out before what is the initial
archive that oracle is going to ask when i am giving recover database (or) recover database until ?

and also do we have any view to find out what is the last archive which will be needed for making a DB consistent/open ?

this is primarily used in situation where we want to find out the exact tape for archives in critical restore / alternate client copy ?

any help /doc / suggestions on this regard is highly appreciated

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2009

Added on Mar 14 2009

#performance-availability, #recovery-manager-rman

3 comments

1,001 views