Nagaraj, Yes, you may indeed have a problem. You say you backed up the datafiles. Did you get the redo logs and controlfile? How did your DB go down? Did it crash, or were you able to shut it down? If you're not in archivelog mode, are the redo logs that were current at the time of the most recent backup available? David A. BarbourOracle DBA, OCPAISD512-414-1002 "Nagaraj Panyam"
Sent by: root@fatcity.com01/01/2002 11:55 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L cc: bcc: Subject: RE: oracle not available ??? Hi listI have a database recovery problem.The scenario is like thisa) My database is not in archive mode.b) I have taken a cold back up on two different times. 6 data files inthe morning and 6 in the evening. In between the database was startedand againWas shutdown before taking back up in the evening.I want to recover the database completely but I don't mind losing thedata of the period between the back ups.Can any one have solution.Thanks in advanceNAGARAJ--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Nagaraj Panyam INET: nagarajp@intelligroup.co.inFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: DBarbour@austin.isd.tenet.edu
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@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 Tue Jan 01 2002 - 21:56:58 CST
