Re: Rman restore from backup on disk

Joel, that sounds like just a regular RMAN recover command then.

I would think RMAN can handle restoring just parts of a database and creating a new controlfile containing just the restored tablespaces, but I'm not sure of the syntax. Never did that.

Finn

On 2/26/08, Joel.Patterson_at_crowley.com <Joel.Patterson_at_crowley.com> wrote:
>
>
> Hmmm. The Problem came about because of a clone. They want to keep
> the clone, but they need some data out of the database that disappeared.
>
> I want to restore the database that disappeared without bothering the
> existing clone.
>
> (I can use another server, and recover, but I'm looking for the answer.
> ie put on same server alongside existing cloned database, but with
> different name).
>
> 2nd topic but related:
> With a cold backup, (or user created online backups), I can just restore
> the needed tablespaces/datafiles I want by editing the trace file first.
> How about with RMAN?
>
>
> Joel Patterson
> Database Administrator
> joel.patterson_at_crowley.com
> x72546
> 904 727-2546
> -----Original Message-----
> From: dtseiler_at_gmail.com [mailto:dtseiler_at_gmail.com] On Behalf Of Don
> Seiler
> Sent: Tuesday, February 26, 2008 10:30 AM
> To: Patterson, Joel
> Cc: finn.oracledba_at_gmail.com; oracle-l_at_freelists.org
> Subject: Re: Rman restore from backup on disk
>
> You're always restoring from a backup in either case. If you aren't
> doing the DUPLICATE DATABASE command then it sounds to me like a
> disaster recovery type of restore.
>
> Maybe give this a read:
> http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmr
> ecov004.htm#sthref734
>
> Don.
>
> On Tue, Feb 26, 2008 at 9:07 AM, <Joel.Patterson_at_crowley.com> wrote:
> >
> >
> >
> >
> > I might be missing something here. When I duplicate if connect to a
> live
> > running database.
> >
> >
> >
> > Rman target sys/<p>@source auxiliary / trace tracefile.lis
> >
> >
> >
> > I don't connect to the source if I am restoring (duplicating), from a
> > backup....
> >
> >
> >
> >
> >
> > Joel Patterson
> > Database Administrator
> > joel.patterson_at_crowley.com
> > x72546
> > 904 727-2546
> >
> > ________________________________
> >
> >
> > From: Finn Jorgensen [mailto:finn.oracledba_at_gmail.com]
> > Sent: Tuesday, February 26, 2008 10:05 AM
> > To: Patterson, Joel
> > Cc: oracle-l_at_freelists.org
> > Subject: Re: Rman restore from backup on disk
> >
> >
> >
> >
> >
> >
> > Joel,
> >
> >
> >
> >
> >
> > By setting the "set until time" and using "duplicate database" you are
> > effectively restoring the RMAN backup to another database name.
> >
> >
> >
> >
> >
> > Yes, both the backup itself and the archive log backups necessary need
> to be
> > available on the server you're restoring to.
> >
> >
> >
> > Finn
> >
> >
> >
> >
> >
> >
> > On 2/26/08, Joel.Patterson_at_crowley.com <Joel.Patterson_at_crowley.com>
> wrote:
> >
> >
> > Can I restore a database from and RMAN backup on disk to new
> (different)
> > database name?
> >
> > If so how, is it analogous to duplicate? Restore database to
> newname?
> >
> > Do archive have to be in the previous locations also?
> >
> >
> >
> > Joel Patterson
> >
> > Database Administrator
> >
> > joel.patterson_at_crowley.com
> >
> > x72546
> >
> > 904 727-2546
> >
> >
>
>
>
> --
> Don Seiler
> http://seilerwerks.wordpress.com
> ultimate: http://www.mufc.us
>

--
http://www.freelists.org/webpage/oracle-l