RMAN: Recover From an Older Backup Set - 09-20-2010 , 04:49 PM
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
will automatically find the most recent backup set and restore from
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
My script for restoring RMAN is (Filenmess are those of the 1PM
configure CHANNEL DEVICE TYPE DISK FORMAT ' \\<network>\<share>\admin
configure channel device type disk format '\\<network>\<share> \admin
restore archivelog from sequence 327;
RMAN will recognize that there is a more recent backupset, and restore
that; In the restore log file (Filename is from the 5PM dataset), I
channel ORA_DISK_1: reading from backup piece \\<share>\<drive>ADMIN
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?
Re: RMAN: Recover From an Older Backup Set - 09-20-2010 , 08:53 PM
On Sep 20, 5:49*pm, "if_inves... (AT) yahoo (DOT) com"
<basis_consult... (AT) hotmail (DOT) com> wrote:
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"
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
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.