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

Home -> Community -> Usenet -> c.d.o.server -> Deletion of datafile == loss of online backup ability ???

Deletion of datafile == loss of online backup ability ???

From: Simon Gottesman <sgotte_at_prodigy-nospamplease.net>
Date: Mon, 13 Aug 2001 01:35:06 GMT
Message-ID: <e9Gd7.8819$5l4.2168162471@newssvr15.news.prodigy.com>

Using 8.1.7 on Win2k Pro.
I used "alter database datafile <path> offline drop" to drop a datafile, and when the db was shut down, deleted the file, as specified in <path>, from the OS. I have thus lost the ability to do online backups of the database. (The db is in archive mode and automatic archival is enabled). When I try to put the tablespace that contained that datafile in backup mode with "alter tablespace mydbspace begin backup", I get this: ORA-01128: cannot start online backup - file 3 is offline ORA-01110: data file 3: 'C:\MYDB\MYDB_DTFILE2.ORA' Why is this? Even a little help is much appreciated. Received on Sun Aug 12 2001 - 20:35:06 CDT

Original text of this message

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