Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Deletion of datafile == loss of online backup ability ???
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