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