Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN Question

RE: RMAN Question

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Wed, 1 Mar 2006 08:58:35 -0700
Message-ID: <7209E76DACFED9469D4F5169F9880C7A9C75@mail01bldr.arraybp.com>

  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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fred Smith Sent: Wednesday, March 01, 2006 8:49 AM
To: Oracle-L_at_freelists.org
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/

--

http://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.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 01 2006 - 09:58:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US