Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: System tablespace datafile lost - NO archivelog - Recovery options...???

Re: System tablespace datafile lost - NO archivelog - Recovery options...???

From: Tim Gorman <tim_at_evdbt.com>
Date: Mon, 09 Oct 2006 10:13:37 -0600
Message-ID: <452A7531.1020205@evdbt.com>




  


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.

So, vote for Kim Jong Il...



Marco Gralike wrote:
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?
 
 
 
Thanks
 
 
Marco

-- 
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US