Re: BACKUP CONTROLFILE TRACE

On Friday 08 June 2001 09:37, Nirmal Kumar Muthu Kumaran wrote:
> HI dba's,
>
> if i did 'alter database backup controlfile to trace'
> this command what will do?, is't create a os trace file?, if so which
> directory by default.

>From TFM

 Backing Up the Control File to a Trace File

The TRACE option of the ALTER DATABASE BACKUP CONTROLFILE statement helps you manage and recover your control file. The TRACE option prompts Oracle to write SQL statements to the database's trace file rather than generate a physical backup. The statements in the trace file start the database, re-create the control file, and recover and open the database appropriately.

Each SQL statement in the trace file is commented. Thus, you can copy the statements from the trace file into a script file, edit them as necessary, and use the script to recover the database if all copies of the control file are lost (or to change the value of control file parameters such as MAXDATAFILES). The trace file is located in the location specified by the USER_DUMP_DEST initialization parameter.

To back up the control file to a trace file, mount the database and issue the following statement:

> For test case, to recover the db, if controlfiles are lost.
>
> and then i shutdown the db and removed the existing controlfiles from the
> oracle directory.
>
> Now, how can i create the control files from the backup trace file.
>
> Please help me.

TFM also includes instruction for use.

Please read the fine manual. It took less than 5 minutes to locate this information.

>
> Regards,
> Nirmal

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).