Re: RMAN problem

DMina_at_laiki.com wrote:
> 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
>

Identify the tablespace that Oracle thinks the extra file (the one with the DASH in the name) belongs to and find out what's going on with that tablespace/datafile before deleting anything.

-- 
To reply by email remove "_nospam"