| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Crashed Help Required
Hi,
I think you might be checking at wrong place.
Just check at USER_DUMP_DEST. When a trace is generated
by user commands then the destination directory is
USER_DEMP_DEST.
You can double check it by matching the time stamp
of trace file with time stamp of command execution.
HTH,
Rajesh
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
Yerpude_at_btnl.com
Sent: Monday, October 02, 2000 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Database Crashed Help Required
Hi,
I need urgent Help. Our Database has been crashed and we have lost
all
redologs and most of files of database. The database is in Archivelog
mode
and the good thing is that I have the controlfile with me. Now when I am
trying to take the backup of controlfile via "ALTER DATABASE BACKUP
CONTROLFILE TO TRACE" ; No files are being generated. The command 'ALTER
DATABASE BACKUP CONTROLFILE TO FILE' successfully generates the file,
but I
am unable to use this file to create the new controlfile.
In what conditions this command does not create any trace file
TIA
Lalit Kumar Yerpude
Oracle DBA, Systems H.O.
Bharti TeleNet Limited
1, Malviya Nagar, Bhopal (M.P)
Phone : (O) 91-755-200251/2/3
(R) 91-755-293329
Fax : 91-755-223223
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Yerpude_at_btnl.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). Received on Mon Oct 02 2000 - 03:17:59 CDT
 |
 |