RE: BACKUP CONTROLFILE TRACE

From: DEMANCHE Luc (Cetelem) <Luc.Demanche_at_cetelem.fr>
Date: Fri, 08 Jun 2001 09:23:02 -0700
Message-ID: <F001.00322704.20010608092030@fatcity.com>

Hi Nirmal,

The command 'alter database backup controlfile to trace' will dump the control file content on a text file with all the SQL command to recreate it.  You gonna find your text file (.trc) in your USER_DUMP_DEST directory.

To test it, you can do this :

1- execute the 'alter database backup controlfile to trace' command
2- remore all lines from the top of the file until STARTUP NOMOUNT
3- shutdown your database
4- delete your control files
5- execute your script

-----Message d'origine-----
De: Nirmal Kumar Muthu Kumaran [mailto:NIRMALK_at_qtel.com.qa] Date: Friday, June 08, 2001 6:37 PM
Ŕ: Multiple recipients of list ORACLE-L
Objet: BACKUP CONTROLFILE TRACE

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.

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.

Regards,
Nirmal
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nirmal Kumar  Muthu Kumaran
  INET: NIRMALK_at_qtel.com.qa

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). Received on Fri Jun 08 2001 - 11:23:02 CDT