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@xxxxxxxxxxx <Joel.Patterson@xxxxxxxxxxx> 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@xxxxxxxxxxx > x72546 > 904 727-2546 > -----Original Message----- > From: dtseiler@xxxxxxxxx [mailto:dtseiler@xxxxxxxxx] On Behalf Of Don > Seiler > Sent: Tuesday, February 26, 2008 10:30 AM > To: Patterson, Joel > Cc: finn.oracledba@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx > 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@xxxxxxxxxxx> 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@xxxxxxxxxxx > > x72546 > > 904 727-2546 > > > > ________________________________ > > > > > > From: Finn Jorgensen [mailto:finn.oracledba@xxxxxxxxx] > > Sent: Tuesday, February 26, 2008 10:05 AM > > To: Patterson, Joel > > Cc: oracle-l@xxxxxxxxxxxxx > > 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@xxxxxxxxxxx <Joel.Patterson@xxxxxxxxxxx> > 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@xxxxxxxxxxx > > > > x72546 > > > > 904 727-2546 > > > > > > > > -- > Don Seiler > http://seilerwerks.wordpress.com > ultimate: http://www.mufc.us >