RE: when does the lost datafile get noticed

From: Zeng, Lei <LZeng_at_vicr.com>
Date: Fri, 4 Mar 2005 08:28:13 -0500
Message-ID: <BEAABDAE2229BD40B818B0A4FB8E090801F519F1@25exch1.vicorpower.vicr.com>

Did you check the V$RECOVER_FILE?

Lei=20
DBA of Vicor Corp.

-----Original Message-----

From: Michael McMullen [mailto:ganstadba_at_hotmail.com]=20 Sent: Friday, March 04, 2005 8:18 AM
To: oracle-l_at_freelists.org
Subject: when does the lost datafile get noticed

Oracle 9.2.0.6
solaris 9

I was testing some rman stuff yesterday. I deleted a datafile from a users tablespace(only one datafile in the tablespace, they only had quota on that tablespace). I then monitored the alter log to see when it would show up. I also ran a bunch of queries on v$datafile, dba_data_files. I was able to keep creating tables as that user, insert/update delete, never any error. I issued numerouse alter system checkpoints, switched the logfiles over 10 times (only have 3 redo logs). But nothing ever showed up as a problem. Only when I issued shutdown immediate did the error get puked out. Did I miss something? Is there another view I should be watching, or does this go back to the inode post a few days back.

Thanks
Mike
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 04 2005 - 08:31:25 CST