RE: i ReMoved the RBS datafile !!

> ----------
> From: Gilles PARC[SMTP:gparc_at_online.fr]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Friday, May 12, 2000 00:46
> To: Multiple recipients of list ORACLE-L
> Subject: RE: i ReMoved the RBS datafile !!
>
>
> 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
> Email : gparc_at_mail.dotcom.fr
>
> carpe diem !!
> --
> Author: Gilles PARC
> INET: gparc_at_online.fr
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

                                                          
Visit us at http://www.clearstream.com           
                                                          

IMPORTANT MESSAGE Internet communications are not secure and therefore Clearstream International does not accept legal responsibility for the contents of this message.

The information contained in this e-mail is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any views expressed in this e-mail are those of the individual sender, except where the sender specifically states them to be the views of Clearstream International or of any of its affiliates or subsidiaries. Received on Fri May 12 2000 - 03:17:56 CDT