Re: RMAN question
From: The Magnet <art_at_unsu.com>
Date: Wed, 3 Mar 2010 08:27:30 -0800 (PST)
Message-ID: <f82c9106-2db3-4c31-9805-b884f1ab81a1_at_i25g2000yqm.googlegroups.com>
On Mar 3, 9:43 am, Mladen Gogala <n..._at_email.here.invalid> wrote:
> On Wed, 03 Mar 2010 07:12:27 -0800, The Magnet wrote:
> > Hi,
>
> > We're running Oracle 10g R2. I'm restoring a copy of the database onto
> > a different server. Our retention period is 21 days, with an
> > Incremental Level 0 each Sunday.
>
> > For this restore, I really only need to start with the last Incremental
> > Level 0, as that is a backup of the entire database. But when we
> > performed the restore, it seemed to start with the beginning of
> > retention period, hence 21 days ago. This is not needed, we really need
> > just from the last Incremental Level 0.
>
> > How can I tell RMAN which Level 0 to access. We are using a control
> > file rather than a catalog. One thing I though of is to mark the other
> > backups as Unavailable?
>
> > Searching Oracle docs, but have not found the answer yet.
>
> > Many thanks
>
> You can restore specific tag or file. Check the syntax for the restore
> command.
>
> --http://mgogala.byethost5.com
Date: Wed, 3 Mar 2010 08:27:30 -0800 (PST)
Message-ID: <f82c9106-2db3-4c31-9805-b884f1ab81a1_at_i25g2000yqm.googlegroups.com>
On Mar 3, 9:43 am, Mladen Gogala <n..._at_email.here.invalid> wrote:
> On Wed, 03 Mar 2010 07:12:27 -0800, The Magnet wrote:
> > Hi,
>
> > We're running Oracle 10g R2. I'm restoring a copy of the database onto
> > a different server. Our retention period is 21 days, with an
> > Incremental Level 0 each Sunday.
>
> > For this restore, I really only need to start with the last Incremental
> > Level 0, as that is a backup of the entire database. But when we
> > performed the restore, it seemed to start with the beginning of
> > retention period, hence 21 days ago. This is not needed, we really need
> > just from the last Incremental Level 0.
>
> > How can I tell RMAN which Level 0 to access. We are using a control
> > file rather than a catalog. One thing I though of is to mark the other
> > backups as Unavailable?
>
> > Searching Oracle docs, but have not found the answer yet.
>
> > Many thanks
>
> You can restore specific tag or file. Check the syntax for the restore
> command.
>
> --http://mgogala.byethost5.com
Hmmm, I assume that means the tag has to be unique. Meaning that if you had a tag of "WEEKLY_BACKUP", it still would not know which one to go after.
Filename, if the backup was in 2 pieces, then I assume you would provide both files?
This is good info, I'll check the docs. Did not see this before.
Thanks Received on Wed Mar 03 2010 - 10:27:30 CST