| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Redo logs lost, old backups
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). Received on Mon Dec 17 2001 - 22:28:35 CST
 |
 |