Skip to Main Content

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!

roll forward archivelog oracle 11g

User_NROJDFeb 1 2017 — edited Feb 2 2017

Hello,

here's my situation i have a a server in archivelolg mode i perform a backup incremental level 1 avery day and an archivelog every 5 hours , i restore the backup in the new server i would like to apply the archivelog by  restoreing manualy.

is these command correct

sql> alter database recover until cancel using backup controlfile;

SQL> alter database recover continue default;

...

..

so how can i know that applied correctly the archivelog without open the database( select statmement to chack for example ), and until when i can stop performing "alter database recover continue default;"

Thank you so much for the help .

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2017
Added on Feb 1 2017
10 comments
1,475 views