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

Home -> Community -> Mailing Lists -> Oracle-L -> i ReMoved the RBS datafile !!

i ReMoved the RBS datafile !!

From: Rahul <rahul_at_ratelindo.co.id>
Date: Mon, 8 May 2000 12:06:01 +0700
Message-Id: <10490.105136@fatcity.com>


List (AIX oracle 7.3.2) ,

trying to create a recovery scenario, i took cold backup of the datafile making my RBS tbs, then put the DB in archivelog mode, and did some inserting/deleting/ commiting/rollbacking etc....
then i ReMoved the datafile from the disk, but still i was abel to use all the rollback segments in that RBS !!!, i also tried invoking SMON an PMON from svrmgrl.. and tried alter system checkpoint, i also dropped all the OTHER rollback segs, but i was STILL able to do inserting/deleting !!!

finally i OFFLINE the rollback segs in the rbs (of the REMOVED dbfile) and only then the DB started returning errors....

why it did not take the DBFILE offline after my earlier attempts ?? Received on Mon May 08 2000 - 00:06:01 CDT

Original text of this message

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