RE: Redo logs lost, old backups

Yes. There are ways to recover the database (of course , unsupported) . let me know the following details by offline, I will be able to help you.

What is the current state of the database? What is the size of the redo logs?
Was the last shutdown (if the database is down) is immediate or abort? Which version of Oracle and OS?
Do you have the trace of the control file ? Do you know the locations of ALL datafiles? Do you have the alert log in place?

Best Regards,
K Gopalakrishnan
(408) 934 9310

-----Original Message-----
(SEA)

Sent: Monday, December 17, 2001 8:10 PM
To: Multiple recipients of list ORACLE-L

HELP! I got hit with something or someone today and all the redologs for 2 of my production databases disappeared. I have no idea how, and will leave it to the SysAdmin
to figure out what happened and how to prevent it from happening again. I am not in archivelog mode and normally take nightly cold backups. If at all possible, I need to recover these databases. The other problem is that my backup script was broken and (during my absence, I should never have taken a 2 week honeymoon!) no backups were taken. So, I'm working with 2 week old cold backup, and wondered if anyone knows a way (unsupported, of course) to recover the tablespaces that hold data with the old system datafile?
I have tried all methods of recovery I could come up with to get the database to start without the logfiles, (using "recover ... using backup controlfile", rebuilding controlfile) ... but always end up with a message that the system tablespace needs media recovery.

I took a cold backup of the mess before I started tinkering with it, and I'm willing to try anything. Any ideas?

The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on:

+44 (0)1753 534655, or email 'is_at_celltech.co.uk'

Celltech Group plc
216 Bath Road, Slough, SL1 4EN, Berkshire, UK

Registered Office as above. Registered in England No. 2159282

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Maser, Donna  (SEA)
  INET: Donna.Maser_at_sea.celltechgroup.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).


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.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).