Problem Deleteing ASM file and Alias
sdAug 4 2009 — edited Aug 4 2009Oracle 10g, Redhat Linux 5.2 x86-64
I am trying to create a tablespace using datafiles in an ASM diskgroup (+CARD). When I try to create the tablespace, I get:
SQL> CREATE TABLESPACE ITEM_DATA_05Q1 DATAFILE
2 '+CARD/item_data_05Q1_01.dbf' SIZE 500M AUTOEXTEND OFF,
3 '+CARD/item_data_05Q1_02.dbf' SIZE 200M AUTOEXTEND OFF,
4 '+CARD/item_data_05Q1_03.dbf' SIZE 200M AUTOEXTEND OFF,
5 '+CARD/item_data_05Q1_04.dbf' SIZE 200M AUTOEXTEND OFF,
6 '+CARD/05Q1_05.dbf' SIZE 200M AUTOEXTEND OFF,
7 '+CARD/item_data_03Q1_08.dbf' SIZE 200M AUTOEXTEND OFF,
8 '+CARD/item_data_05Q1_05.dbf' SIZE 200M AUTOEXTEND OFF,
9 '+CARD/item_data_03Q1_09.dbf' SIZE 200M AUTOEXTEND OFF,
10 '+CARD/item_data_05Q1_01.dbf' SIZE 200M AUTOEXTEND OFF
11 LOGGING
12 ONLINE
13 PERMANENT
14 AUTOALLOCATE;
CREATE TABLESPACE ITEM_DATA_05Q1 DATAFILE
*
ERROR at line 1:
ORA-01119: error in creating database file '+CARD/item_data_05Q1_01.dbf'
ORA-17502: ksfdcre:4 Failed to create file +CARD/item_data_05Q1_01.dbf
ORA-15005: name "item_data_05Q1_01.dbf" is already used by an existing alias
But when I try to delete the file 'item_data_05Q1_01.dbf' , I get:
SQL> ALTER DISKGROUP CARD
DROP FILE '+CARD/item_data_05Q1_01.dbf' ;
2 ALTER DISKGROUP CARD
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15173: entry 'item_data_05Q1_01.dbf' does not exist in directory '/'
So, ASM says the file is there but then it says it's not.
Any advise is appreciated.
Sam