| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN problem
sorry for the delay but i was out of the office for a while, you need
some rest sometimes :p
Here is something strange. My backups still cancels with the same error. I run the following on the database and i get this result :
SQL> select file_name from dba_data_files;
FILE_NAME
D:\ORACLE\ORADATA\ONLDB1\SYSTEM01.DBF D:\ORACLE\ORADATA\ONLDB1\UNDOTBS01.DBF D:\ORACLE\ORADATA\ONLDB1\DRSYS01.DBF D:\ORACLE\ORADATA\ONLDB1\EXAMPLE01.DBF D:\ORACLE\ORADATA\ONLDB1\INDX01.DBF D:\ORACLE\ORADATA\ONLDB1\ODM01.DBF D:\ORACLE\ORADATA\ONLDB1\TOOLS01.DBF D:\ORACLE\ORADATA\ONLDB1\USERS01.DBF D:\ORACLE\ORADATA\ONLDB1\XDB01.DBF D:\ORACLE\ORADATA\ONLDB1\ONLINE00.DBF D:\ORACLE\ORADATA\ONLDB1\ONLINE02_02.DBF
FILE_NAME
D:\ORACLE\ORADATA\ONLDB1\ONLINE02_01.DBF D:\ORACLE\ORADATA\ONLDB1\ONLINE02_03.DBF D:\ORACLE\ORADATA\ONLDB1\ONLINE02_04.DBF
14 rows selected.
When i run this i get something different:
SQL> select name from v$datafile;
NAME
D:\ORACLE\ORADATA\ONLDB1\SYSTEM01.DBF D:\ORACLE\ORADATA\ONLDB1\UNDOTBS01.DBF D:\ORACLE\ORADATA\ONLDB1\DRSYS01.DBF D:\ORACLE\ORADATA\ONLDB1\EXAMPLE01.DBF D:\ORACLE\ORADATA\ONLDB1\INDX01.DBF D:\ORACLE\ORADATA\ONLDB1\ODM01.DBF D:\ORACLE\ORADATA\ONLDB1\TOOLS01.DBF D:\ORACLE\ORADATA\ONLDB1\USERS01.DBF D:\ORACLE\ORADATA\ONLDB1\XDB01.DBF D:\ORACLE\ORADATA\ONLDB1\ONLINE00.DBF D:\ORACLE\ORADATA\ONLDB1\ONLINE02_02.DBF
NAME
D:\ORACLE\ORADATA\ONLDB1\ONLINE02_01.DBF D:\ORACLE\ORADATA\ONLDB1\ONLINE02-02.ORA D:\ORACLE\ORADATA\ONLDB1\ONLINE02_03.DBF D:\ORACLE\ORADATA\ONLDB1\ONLINE02_04.DBF
15 rows selected.
You can see that i have one datafile more using the second command. That datafile is offline. Surely i do not have such a file on the OS level.
How can i delete this file from ORACLE?
thanks Received on Tue Jan 31 2006 - 08:57:27 CST
 |
 |