Re: RMAN Question

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: Wed, 1 Mar 2006 07:56:41 -0800 (PST)
Message-ID: <20060301155641.40567.qmail@web404.biz.mail.mud.yahoo.com>

On the new server, you can

Restore controlfile thru' RMAN
alter database mount;
alter database backup controlfile to trace;

to get the ascii version of the controlfile

Joseph Amalraj

Fred Smith <fred_fred_1_at_hotmail.com> wrote: 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

--

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