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

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

RE: i ReMoved the RBS datafile !!

From: Gilles PARC <gparc_at_online.fr>
Date: Fri, 12 May 2000 18:52:31 +0200
Message-Id: <10495.105575@fatcity.com>


Hi,

At 02:57 12/05/2000 -0800, you wrote:
>My understanding of Oracle's I/O processing is that the DBWR process is
>responsible of reading/writing data from/to the datafiles, so it will keep a
>file descriptor open on them until shutdown & export still will be possible.
>But I may be wrong, so could a guru from this list confirm that ???

It's the server process (either shared or dedicated) which is responsible for reading and NOT dbwr.

So, except in a MTS configuration, i don't think it's possible to make a full export of the database after deleting the DB files.

Regards

>> Hi Bruce,
>>
>> At 06:06 08/05/2000 -0800, you wrote:
>> <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.
>>
>> Can you be more specific about that case (OS, Oracle version,files
>> destroyed...) ?
>>
>> Because as i agree that processes already connected can still "see" the
>> removed
>> DB files, in dedicated server configuration, export uses a NEW oracle
>> process
>> (two-task or single-task mode) and as such it cannot open previously
>> destroyed datafiles.
>>
>My understanding of Oracle's I/O processing is that the DBWR process is
>responsible of reading/writing data from/to the datafiles, so it will keep a
>file descriptor open on them until shutdown & export still will be possible.
>But I may be wrong, so could a guru from this list confirm that ???
>
>> Was it a Muti-threaded server configuration ??
>>
>>
>> Thanks in advance for clarifications
>>
>> Regards
>>

Gilles Parc Received on Fri May 12 2000 - 11:52:31 CDT

Original text of this message

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