RE: Rman restore from backup on disk

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