Re: Recovering ORACLE db after system crash
From: Wayne Amisano <wayne_at_gbrmpa.gov.au>
Date: Thu, 8 Oct 1992 22:54:59 GMT
Message-ID: <1992Oct8.225459.18039_at_gbrmpa.gov.au>
Date: Thu, 8 Oct 1992 22:54:59 GMT
Message-ID: <1992Oct8.225459.18039_at_gbrmpa.gov.au>
hans_at_iris.mincom.oz.au (Hans Plambeck) writes:
>: I couldn't drop the table because ORACLE told me to put it offline, I
>: couldn't alter it offline either, neither could I recover tablespace
>: "rollback_segment".
[...]
>: What should I have done?
>:
>If you are sure (how would you?) that there are no transactions, you might
> want to try ALTER DATABASE DATAFILE file-spec OFFLINE, and then forget
> about it.
>I believe in V7 you can 'mirror' these tablespaces and redo log files,
> adding more security. Anyone to comment on this?
In a recent DBA course, they gave an talk on what is in v7. Adding redundant database files, similar to allowing more than 1 control file, was mentioned.
cul Wayne!
-- Wayne Amisano (VK4KT) _-_|\\ E-Mail - wayne_at_gbrmpa.gov.au Great Barrier Reef / \\ Phone - +61 77 81 8861 (GMT+1000) Marine Park Authority. \_.-._/ Fax - +61 77 72 6093 Our's to use Wisely! v Mail - GPO Box 1379, Townsville QLD 4810Received on Thu Oct 08 1992 - 23:54:59 CET