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