Skip to Main Content

Oracle Database Discussions

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!

RMAN Backup/Recovery

Beauty_and_dBestNov 11 2018 — edited Nov 17 2018

11gR1

OL5

Hi ALL,

We are restoring our RMAN backup to our DR server.

First we copied our Full and incremental backup + plus succeeding achive logs to the DR server.

Then we issue the ff. commands:

rman> restore database;

rman> recover database;

Below is the output recovery log screenshot

pastedImage_0.png

I am planning to recover more archivelogs to capture latest data from the source PROD database.

So I copied more archivelogs fron source PROD to target DR.

The DR database is not yet opened and it continuous recovery for succeeding archive logs.

I login to the mounted database and check the latest log sequence:

pastedImage_1.png

I can see that the last applied log is 35299 and it is asking for next log 35300.

I can also see below file list that the logs are present and available in the cataloged backup folder.

pastedImage_2.png

But when I run recover database again, it shows below process:

pastedImage_3.png

Why is it asking for log sequence 1? when it should be asking log sequence 35300?

I also tried recovery using sqplus / as sysdba, but still it is not asking for log sequence 35300.

pastedImage_6.png

Please help what have I missed....

Kind regards,

jc

This post has been answered by racman on Nov 13 2018
Jump to Answer
Comments
Post Details
Added on Nov 11 2018
21 comments
866 views