Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restoring Data Using RMan
If you are running in noarchivelog mode, then you can "force" rman to
use certain backupsets/pieces by marking all pieces as invalid (change
backupset.....) except for the ones you want to restore. The burden
is then on you to make sure all the correct pieces are marked valid.
Kenneth Koenraadt wrote in message news:<40879113.9029033_at_news.inet.tele.dk>...
> On Thu, 22 Apr 2004 09:19:02 +1000, "Howard J. Rogers"
> <hjr_at_dizwell.com> wrote:
>
>
> >
> >> 2. How can I explicitly tell it to use a specific backup set to use
> >> for the restore?
> >
> >AFAIR, you can't. RMAN uses an intelligent algorithm to determine what
> >is used for restores (disk backups are preferred to tapes, fulls to
> >incrementals etc... basically, a bunch of assumptions that are followed
> >to try and minimise the recovery time).
> >
>
> But( if in archivelog mode) he could list the backup sets and notice
> their timestamps and then do an incomplete restore + recovery with
> the RMAN command
>
> set until time = '..............'
>
> to let another backupset than the most recent be restored.
>
> Though still bad business, I guess, the purpose of RMAN is exactly to
> free DBA's from manually handling backup sets and other abstracts.
>
> - Kenneth Koenraadt
>
> >Regards
> >HJR
Received on Thu Apr 22 2004 - 09:36:28 CDT