RMAN: Recover From an Older Backup Set

[basis_co...@hotmail.com]

Hi,

On 10g/Win2003, I can get RMAN to restore the most recent backup set,
but not older ones. That is, when I try to restore an older backup
set, RMAN
will automatically find the most recent backup set and restore from
that,
although that is not what I want.

For example, a RMAN script successfully backups the database and
archivelogs at 1PM and 5PM today. I now want to restore the 1PM backup
set.

My script for restoring RMAN is (Filenmess are those of the 1PM
dataset)
{
configure CHANNEL DEVICE TYPE DISK FORMAT ' \\<network>\<share>\admin
\RMANCSA_11RLOCFL8_1_1';
restore DATABASE;
configure channel device type disk format '\\<network>\<share> \admin
\RMANCSA_11TLOCG6J_1_1';
restore archivelog from sequence 327;
}

RMAN will recognize that there is a more recent backupset, and restore
from
that; In the restore log file (Filename is from the 5PM dataset), I
see the
entry..

channel ORA_DISK_1: reading from backup piece \\<share>\<drive>ADMIN
\RMANCSA_11ULOCI8F_1_1

Same thing for the file with the archive logs..

How can I get RMAN to ignore the more recent backups and restore to
the one that I specify?

Thanks,
QZ

[John Hurley]

On Sep 20, 5:49 pm, "if_inves...@yahoo.com"

Again ... dude ... try to figure out how to do this in sqlplus first
please.

Each time I take an rman backup ( and I do disk backups not tape ... I
get a tape backup later from the disk copies ) I also get a separate
disk based backup of the control file. This control file "belongs to"
that backup.

You have to restore that older copy of the control file first ... so
that the restore will use the backup that belongs to that copy of the
control file.

There is no substitute for taking the time to learn everything about
backups and recoveries. Please take the time to become a professional
in this area.