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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
