Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: System tablespace datafile lost - NO archivelog - Recovery options...???
It's kind of like voting for president in North Korea. Only one choice -- under any circumstances -- when in NOARCHIVELOG mode: full database restore from cold backup. There are no options for partial recovery or any recovery at all. NOARCHIVELOG mode = full database restore, no recovery, period. This scenario is no exception.
Got a nice one. What are my options?Situation.Old Oracle 7.3 database on Novell Netware 4.11 server, which is NOT in archivemode AND lost the system tablespace datafile...I know off / and performed, in my days, nice tricky anc challenging recoveries with hidden "corruption allowed" etc parameters, but uptill now I always had a system tablespace datafile to work with...Has someone ideas?ThanksMarco
-- Tim Gorman consultant - Evergreen Database Technologies, Inc. website = http://www.evdbt.com email = tim@evdbt.com mobile = +1-303-885-4526 fax = +1-303-484-3608-- http://www.freelists.org/webpage/oracle-l Received on Mon Oct 09 2006 - 11:13:37 CDT