Re: RMAN: Recover From an Older Backup Set
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Mon, 20 Sep 2010 18:53:02 -0700 (PDT)
Message-ID: <d6ee5122-e83d-4a92-99af-43d885e51883_at_c21g2000vba.googlegroups.com>
On Sep 20, 5:49 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
> 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
Date: Mon, 20 Sep 2010 18:53:02 -0700 (PDT)
Message-ID: <d6ee5122-e83d-4a92-99af-43d885e51883_at_c21g2000vba.googlegroups.com>
On Sep 20, 5:49 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
> 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
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. Received on Mon Sep 20 2010 - 20:53:02 CDT