On 9/20/05, Branimir Petrovic <BranimirP@(protected)> wrote: > > 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 >
Branimir,
This is not correct when it comes to files mounted on a SAN. It is entirely possible to overwrite files owned by a different database instance if account separation is not used. I know someone that proved this to be true (not saying who that might be) via a "create controlfile" statement during a cloning exercise. Lets just say that it counted as a backup/restore/recover exercise.
Paul
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. > >
<div><font color="#0000ff" face="Courier New" size="2"><span>Try as hard as you may - you can not delete any Oracle data files on </span></font></div> <div><font color="#0000ff" face="Courier New" size="2"><span>Windows (should have said - on Windows ONLY) </span></font><font color="#0000ff" face="Courier New" size="2"><span>while the database is up </span></font></div> <div><font color="#0000ff" face="Courier New" size="2"><span>and running. Windows keeps them locked </span></font><font color="#0000ff" face="Courier New" size="2"><span>'n safe from deletion attempts. </span></font></div> <div><font color="#0000ff" face="Courier New" size="2"><span>However, </span>< /font><font color="#0000ff" face="Courier New" size="2"><span>take the tablespace offline </span></font><font color="#0000ff" face="Courier New" size="2"><span>and watch its individual data </span></font></div> <div><font color="#0000ff" face="Courier New" size="2"><span>files </span>< /font><font color="#0000ff" face="Courier New" size="2"><span>become "fair </span></font><font color="#0000ff" face="Courier New" size="2"><span>game" ; for deletion attempts...</span></font></div> <div><font color="#0000ff" face="Courier New" size="2"><span> </span>< /font></div> <div><font color="#0000ff" face="Courier New" size="2"><span>The story you've been told on how the problem came to be - simply </span></font><font color="#0000ff" face="Courier New" size="2"> <span>ain't </span></font></div> <div><font color="#0000ff" face="Courier New" size="2"><span>true. I</span>< /font><font color="#0000ff" face="Courier New" size="2"><span>t takes more </span></font><font color="#0000ff" face="Courier New" size="2"><span>than a simple mistake (on Windows that is) to get </span></font></div> <div><font color="#0000ff" face="Courier New" size="2"><span>to </span></font> <font color="#0000ff" face="Courier New" size="2"><span>this </span></font><font color="#0000ff" face="Courier New" size="2"><span>point. FYI - i</span></font><font color="#0000ff" face="Courier New" size="2"><span>t takes *deliberate* aim. </span></font></div> <div><font color="#0000ff" face="Courier New" size="2"><span></span></font> </div> <div><font color="#0000ff" face="Courier New" size="2"><span></span></font> <font color="#0000ff" face="Courier New" size="2"><span>Branimir</span></font>< /div></blockquote><div><br> <br> Branimir,<br> <br> This is not correct when it comes to files mounted on a SAN.<br> It is entirely possible to overwrite files owned by a different database instance if account separation is not used.<br> I know someone that proved this to be true (not saying who that might be) via a "create controlfile" statement during a cloning exercise. Lets just say that it counted as a backup/restore/recover exercise.<br> <br> Paul<br> <br> <br> </div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204 , 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><font color=" #0000ff" face="Courier New" size="2"><span>P.S.</span></font></div>
<div><font color="#0000ff" face="Courier New" size="2"><span></span></font> </div> <div><font color="#0000ff" face="Courier New" size="2"><span>If there are no recent cold backups (or schema exports) - expect from</span></font></div> <div><font color="#0000ff" face="Courier New" size="2"><span>partial </span>< /font><font color="#0000ff" face="Courier New" size="2"><span>to total </span></font><font color="#0000ff" face="Courier New" size="2"><span>data < /span></font><font color="#0000ff" face="Courier New" size="2"><span>loss.  ;If data loss is not acceptable - somebody </span></font></div> <div><font color="#0000ff" face="Courier New" size="2"><span></span></font> <font color="#0000ff" face="Courier New" size="2"><span>should get </span></font ><font color="#0000ff" face="Courier New" size="2"><span>"walking papers" over this.</span></font><font color="#0000ff" face="Courier New" size="2"><span></span></font></div><div><span class="e" id="q_10673a5f2e6735b0 _1"> <div><font color="#0000ff" face="Courier New" size="2"><span></span></font> </div> <div><font color="#0000ff" face="Courier New" size="2"><span></span></font> </div> <blockquote style="margin-right: 0px;" dir="ltr"> <div align="left" dir="ltr"><font face="Tahoma" size="2">-- --Original Message-- --<br><b>From:</b> Onkar N Tiwary [mailto:<a href="mailto:onkarnath.tiwary@(protected)" target="_blank" onclick= "return top.js.OpenExtLink(window,event,this)">onkarnath.tiwary@(protected)</a>] <br><b>Sent:</b> Tuesday, September 20, 2005 7:55 AM<br><b>To:</b> <a href="mailto:oracle-l@(protected)" target=" _blank" onclick="return top.js.OpenExtLink(window,event,this)">oracle-l @(protected)</a><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>
