RE: i ReMoved the RBS datafile !!

From: Bruce Page <bpage_at_kimball.com>
Date: Mon, 8 May 2000 07:59:31 -0500
Message-Id: <10491.105154@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFB8ED.4FC90FC0
Content-Type: text/plain;

charset="iso-8859-1"

This is one of the "features" of Unix. Even if you delete the file, if another process is using the file Unix will not really delete it as long as it is being used.

Keep this in mind, it may come in handy.

I know someone that deleted a production database, then realized what he did. He got all the users out and did a full export of the database before shutting it down. He then recreated the database and imported everything back in.

-----Original Message-----
From: Rahul [mailto:rahul_at_ratelindo.co.id] Sent: Monday, May 08, 2000 12:06 AM
To: 'Oracle List I'
Cc: 'Oracle List II'
Subject: i ReMoved the RBS datafile !!

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

Rahul

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk

------_=_NextPart_001_01BFB8ED.4FC90FC0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: i ReMoved the RBS datafile !!</TITLE>
</HEAD>
<BODY>

This is one of the "features" of =
Unix.  Even if you delete the file, if another process is using = the file Unix will not really delete it as long as it is being = used.

Keep this in mind, it may come in handy.


I know someone that deleted a production database, =
then realized what he did.  He got all the users out and did a = full export of the database before shutting it down.  He then = recreated the database and imported everything back in.
 

-----Original Message-----
 From: Rahul [<A =

HREF=3D"mailto:rahul_at_ratelindo.co.id">mailto:rahul_at_ratelindo.co.id</A>]<= /FONT>
 Sent: Monday, May 08, 2000 12:06 AM
 To: 'Oracle List I'
 Cc: 'Oracle List II'
 Subject: i ReMoved the RBS datafile !!

 

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


Rahul

 
 

--------
 If you're bored, then visit the list's website: <A =
HREF=3D"http://www.lazydba.com" =
TARGET=3D"_blank">http://www.lazydba.com</A> (updated daily)
 to unsubscribe, send a blank email to =
oracledba-unsubscribe_at_quickdoc.co.uk
 to subscribe send a blank email to =
Received on Mon May 08 2000 - 07:59:31 CDT