RE: RMAN Question

  • From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
  • To: <fred_fred_1@xxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Wed, 1 Mar 2006 08:58:35 -0700

1.  Restore control file
2.  strings control.ctl > ctl.txt (see man strings for what this command
does)
3.  Carry on

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Fred Smith
Sent: Wednesday, March 01, 2006 8:49 AM
To: Oracle-L@xxxxxxxxxxxxx
Subject: RMAN Question


I've searched Metalink/Google/and the Oracle 9i RMAN Backup & Recovery
book 
and can't find an answer.
Wondering if anyone on here might know...

I am trying to find a way to restore an ascii version of the controlfile
for 
a database I backup through RMAN. Essentially, I backup my database 
including the controlfile. So I know that I can restore a controlfile,
but 
it is a binary version. The problem is, if my server explodes, etc., and
I 
want to restore the entire database to a new server, I need a copy of my

controlfile (similar to a backup controlfile to trace version of the
file)  
that I can edit and create my directory structures and build any 'set 
newname for datafile' commands that I might need.
How can I restore a version of the controlfile that would allow me to
edit 
it to do this??

Thanks.
-Fred

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's
FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

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



This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

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


Other related posts: