RE: Rman restore from backup on disk
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <kevin.lidh@xxxxxxxxx>
- Date: Tue, 26 Feb 2008 12:00:52 -0500
Yes, thanks. I am interested.
I guess I'll just do it a couple times... but of course in this case,
once I restore to a new server, I can get the data I need and destroy
the database.
I'll look into it further, but there are some things about RMAN like
this one that are starting to look not as easy. (like SETing the
database name, and file locations in the trace file, mounting and
opening, thus restoring on same server with existing DB).
P.S. Exports are presently not being done on these due to space
restrictions -- which I believe will not be permanent.
Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904 727-2546
-----Original Message-----
From: Kevin Lidh [mailto:kevin.lidh@xxxxxxxxx]
Sent: Tuesday, February 26, 2008 11:45 AM
To: Patterson, Joel
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Rman restore from backup on disk
You can restore the database on a different server and the same name and
then recreate the controlfile by using SET instead of REUSE to rename it
(obviously changing the init file parameters and name).
e.g. CREATE CONTROLFILE SET DATABASE "CPNMKEV" RESETLOGS ARCHIVELOG
I wrote a document for my last organization which steps through cloning
via this process including using nid to change the DBID if you're
interested. I've learned some things since then which make it somewhat
simplistic but it has the syntax you would need.
You can restore on the same server with the same name and a different
namespace (I believe that's the term) but I haven't done that in years.
HTH,
Kevin
On Tue, 2008-02-26 at 10:46 -0500, 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
