Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem Deleteing ASM file and Alias

sdAug 4 2009 — edited Aug 4 2009
Oracle 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2009
Added on Aug 4 2009
1 comment
4,364 views