 | | | Database recovery problem | Database recovery problem 2005-09-20 - By Branimir Petrovic
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@(protected)]
Sent: Tuesday, September 20, 2005 7:55 AM
To: oracle-l@(protected)
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.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2722" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>Try as hard as you may - you can not delete any Oracle
data files on </SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>Windows (should have said - on Windows ONLY)
</SPAN></FONT><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>while the database is up </SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>and running. Windows keeps them locked
</SPAN></FONT><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>'n safe from deletion attempts. </SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>However, </SPAN></FONT><FONT face="Courier New"
color=#0000ff size=2><SPAN class=832324312-20092005>take the tablespace offline
</SPAN></FONT><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>and watch its individual data </SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>files </SPAN></FONT><FONT face="Courier New"
color=#0000ff size=2><SPAN class=832324312-20092005>become "fair
</SPAN></FONT><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>game" for deletion attempts...</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005> </SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>The story you've been told on how the problem
came
to be - simply </SPAN></FONT><FONT face="Courier New" color=#0000ff size=2>
<SPAN
class=832324312-20092005>ain't </SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>true. I</SPAN></FONT><FONT face="Courier New"
color=#0000ff size=2><SPAN class=832324312-20092005>t takes more
</SPAN></FONT><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>than a simple mistake (on Windows that is) to get
</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>to </SPAN></FONT><FONT face="Courier New" color=
#0000ff
size=2><SPAN class=832324312-20092005>this </SPAN></FONT><FONT
face="Courier New" color=#0000ff size=2><SPAN class=832324312-20092005>point.
FYI - i</SPAN></FONT><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>t takes *deliberate* aim. </SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005></SPAN></FONT><FONT face="Courier New" color=#0000ff
size=2><SPAN class=832324312-20092005>Branimir</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>P.S.</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>If there are no recent cold backups (or schema
exports) - expect from</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>partial </SPAN></FONT><FONT face="Courier New"
color=#0000ff size=2><SPAN class=832324312-20092005>to total
</SPAN></FONT><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005>data </SPAN></FONT><FONT face="Courier New"
color=#0000ff size=2><SPAN class=832324312-20092005>loss. If data loss is
not acceptable - somebody </SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005></SPAN></FONT><FONT face="Courier New" color=#0000ff
size=2><SPAN class=832324312-20092005>should get </SPAN></FONT><FONT
face="Courier New" color=#0000ff size=2><SPAN class=832324312-20092005>"walking
papers" over this.</SPAN></FONT><FONT face="Courier New" color=#0000ff
size=2><SPAN class=832324312-20092005></SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=832324312-20092005></SPAN></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-- --Original Message-- --<BR><B>From:</B> Onkar N Tiwary
[mailto:onkarnath.tiwary@(protected)]<BR><B>Sent:</B> Tuesday, September 20,
2005 7:55 AM<BR><B>To:</B> oracle-l@(protected)<BR><B>Subject:</B> Database
recovery problem<BR><BR></FONT></DIV>
<DIV>hi all,</DIV>
<DIV> </DIV>
<DIV>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.</DIV></BLOCKQUOTE></BODY></HTML>
|
|
|