RE: Delayed block cleanout and changing automatic undo tablespace

From: Tim Onions <tim.onions_at_speechmachines.com>
Date: Tue, 20 Jul 2004 15:32:28 +0100
Message-ID: <A90A3AC3D202D311909A0090271E4C8103210950@SMCORPS0002>

Daniel,

No offense taken at all, only too glad for such constructive help. As per my previous reply to Jonathan, the DB was failed over in failsafe so it may not have been clean, having looked at the alert log I see no shutdown command recorded at all so failsafe may just have ripped the service away (I'd not be happy if it had).

You tests are similar to my real life situation but differ in that the datafiles were not moved/removed but the old tablespace offlined. The error we got was "datafile is not available at this time" or words to that effect.

I'm thinking it may well be the issue with not having a clean shutdown that I'm seeing not a delayed block cleanout as I concluded before.

Thanks

T¬

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Jul 20 2004 - 09:29:41 CDT