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!

How to find out which archived logs needed to recover a hot backup?

884659Jan 17 2013 — edited Jan 24 2013

I'm using Oracle 11gR2 (11.2.0.1.0).

I have backed up a database when it is online using the following backup script through RMAN

connect target /
run {
allocate channel d1 type disk;
backup
incremental level=0 cumulative
filesperset 4
format '/san/u01/app/backup/DB_%d_%T_%u_%c.rman'
(
database
);
}

The backup set contains the backup of datafiles and control file. I have copied all the backup pieces to another server where I will restore/recover the database but I don't know which archived logs are needed in order to restore/recover the database to a consistent state.
I have not deleted any archived log.

How can I find out which archived logs are needed to recover the hot backup to a consistent state? Can this be done by querying V$BACKUP_DATAFILE and V$ARCHIVED_LOG? If yes, which columns should I query?

Thanks for any help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 21 2013

Added on Jan 17 2013

#11gr2, #backup, #performance-availability, #recovery-manager-rman, #rman

9 comments

4,709 views