ora-15177: cannot operate on system aliases (dbd error: ocistmtexecute)

I tried removing the ASM diskgroup file manually in 10.2.0.3. But I always use to get following errors.

ORA-15032: NOT ALL ALTERATIONS PERFORMED
ORA-15173: ENTRY ‘NNNDF0_BACKUP_TESTDB_000_1211060624_0.5448.6214’ DOES NOT EXIST IN DIRECTORY ‘2006_12_11′ (DBD ERROR: OCISTMTEXECUTE)

My ASM diskgroup settings

SQL> SELECT GROUP_NUMBER, NAME FROM V$ASM_DISKGROUP;

GROUP_NUMBER NAME
———— ——————————
1 DATA1
2 DATA2
3 DATA3
4 DATA4
5 FLASH1
6 INDX1
7 INDX2

7 ROWS SELECTED.

SQL> SELECT NAME’.’FILE_NUMBER’.’FILE_INCARNATION FROM V$ASM_ALIAS WHERE GROUP_NUMBER=4;

NAME’.’FILE_NUMBER’.’FILE_INCARNATION
——————————————————————————–
2006_12_11.4294967295.4294967295
NNNDF0_BACKUP_TESTDB_000_1211060624_0.5448.6214.5448.621435131
NCSNF0_BACKUP_TESTDB_000_1211060624_0.5450.6214.5450.621435135
NNNDF0_BACKUP_TESTDB_000_1211060633_0.5457.6214.5457.621435147
NCSNF0_BACKUP_TESTDB_000_1211060633_0.5459.6214.5459.621435153

ASMCMD [+DATA4/TESTDB/BACKUPSET] > rm -rf 2006_12_11

ORA-15032: NOT ALL ALTERATIONS PERFORMED
ORA-15173: ENTRY ‘NNNDF0_BACKUP_TESTDB_000_1211060624_0.5448.6214’ DOES NOT EXIST IN DIRECTORY ‘2006_12_11’ (DBD ERROR: OCISTMTEXECUTE)
ORA-15032: NOT ALL ALTERATIONS PERFORMED
ORA-15173: ENTRY ‘NCSNF0_BACKUP_TESTDB_000_1211060624_0.5450.6214’ DOES NOT EXIST IN DIRECTORY ‘2006_12_11’ (DBD ERROR: OCISTMTEXECUTE)
ORA-15032: NOT ALL ALTERATIONS PERFORMED
ORA-15173: ENTRY ‘NNNDF0_BACKUP_TESTDB_000_1211060633_0.5457.6214’ DOES NOT EXIST IN DIRECTORY ‘2006_12_11’ (DBD ERROR: OCISTMTEXECUTE)
ORA-15032: NOT ALL ALTERATIONS PERFORMED
ORA-15173: ENTRY ‘NCSNF0_BACKUP_TESTDB_000_1211060633_0.5459.6214’ DOES NOT EXIST IN DIRECTORY ‘2006_12_11’ (DBD ERROR: OCISTMTEXECUTE)

ORA-15032: NOT ALL ALTERATIONS PERFORMED
ORA-15177: CANNOT OPERATE ON SYSTEM ALIASES (DBD ERROR: OCISTMTEXECUTE)

SOLUTION:

Removed the files using

SQL > ALTER DISKGROUP DROP FILE ”;

Advertisements
This entry was posted in Oracle Automatic Storage Management and tagged . Bookmark the permalink.

2 Responses to ora-15177: cannot operate on system aliases (dbd error: ocistmtexecute)

  1. Gulspurv says:

    Hi there

    Another possibility is to use asmcmd and rm -r to delete foldertrees.

    -Jon

  2. ybhandarkar says:

    I think I tried that, but it didn’t work.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s