RE: Database recovery problem
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <BranimirP@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Sep 2005 09:16:47 -0400
Branimir,
I'm not sure "walking papers" are in order. We've all made this mistake
once and not been fired for it (at least I haven't).
It is a great example of how *not* to run a production database though
(noarchivelog mode).
And also a great example to begin the discussion of who should have
access to the database server machine!
Tom
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Branimir Petrovic
Sent: Tuesday, September 20, 2005 9:07 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Database recovery problem
Try as hard as you may - you can not delete any Oracle data files on
Windows (should have said - on Windows ONLY) while the database is up
and running. Windows keeps them locked 'n safe from deletion attempts.
However, take the tablespace offline and watch its individual data
files become "fair game" for deletion attempts...
The story you've been told on how the problem came to be - simply ain't
true. It takes more than a simple mistake (on Windows that is) to get
to this point. FYI - it takes *deliberate* aim.
Branimir
P.S.
If there are no recent cold backups (or schema exports) - expect from
partial to total data loss. If data loss is not acceptable - somebody
should get "walking papers" over this.
-----Original Message-----
From: Onkar N Tiwary [mailto:onkarnath.tiwary@xxxxxxxxx]
Sent: Tuesday, September 20, 2005 7:55 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Database recovery problem
hi all,
We have got one oracle 9i rel 2 on windows 2000 running in
no-archive log mode. the problem is one of the dba of the other team has
deleted some of the dbf files while the database was running and
tablespace was online.
Other related posts:
