Prem I don't understand your request. To convert the trace version of the controlfile to a usable script is a simple matter of removing lines, easily accomplished with an editor like vi in Unix or Wordpad in Winders. If you need an automated method, that will depend on your platform and tools available. Also note that in 9i you can specify the name of the created trace file. Dennis Williams DBA Lifetouch, Inc. dwilliams@xxxxxxxxxxxxx I said it "looked" clear - Riddick -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Prem Khanna J Sent: Thursday, July 01, 2004 12:12 AM To: oracle-l@xxxxxxxxxxxxx Subject: Script tp parse control file backup ?? Hi All, SQL > alter system backup controlfile to trace; Does anybody have a script to parse this control file backup ? that is, i need to create a neat script that contains just STARTUP NOMOUNT CREATE CONTROLFILE... ... ... CHARACTER SET JA16SJIS; Can someone share it with me ?? Thanks and Regards, Prem. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------