OraFAQ Forum: Server Administration » Unable to delete archive files thro ASMCMD

Home » RDBMS Server » Server Administration » Unable to delete archive files thro ASMCMD (oracle 11.2.0.1.0 linux )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to delete archive files thro ASMCMD [message #503249]

Wed, 13 April 2011 15:04

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

dear sir / madam,

we are getting below error:

ora-00257 archiver error. connect internal only until freed

when we tried to remove the unwanted arc files thro ASMCMD,we are getting below error:

ASMCMD> rm -ef 2011_04_05/
Unknown option: e
usage: rm [-rf] <name1 name2 . . .>
ASMCMD> rm -rf 2011_04_05/
ORA-15032: not all alterations performed
ORA-15028: ASM file '+XCOM_BACKUP_DG/TXCOM/ARCHIVELOG/2011_04_05/thread_2_seq_27215.1143.747641143' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15028: ASM file '+XCOM_BACKUP_DG/TXCOM/ARCHIVELOG/2011_04_05/thread_3_seq_21762.826.747641143' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

further we checked FRA size:

SQL> select * from v$flash_recovery_area_usage;

 FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

------------ ------------------ ------------------------- ---------------

CONTROLFILE                   0                         0               0

ONLINELOG                     0                         0               0

ARCHIVELOG                 3.19                         0              38

BACKUPPIECE                   0                         0               0

IMAGECOPY                     0                         0               0

FLASHBACKLOG                  0                         0               0

and checkd any arc processing holding lock on arc files:

> ps -ef | grep -i ora_arc*

oracle    6989     1  0 15:07 ?        00:00:00 ora_arc0_TXCOM1

oracle    6991     1  0 15:07 ?        00:00:00 ora_arc1_TXCOM1

oracle   12246 12164  0 15:17 pts/4    00:00:00 grep -i ora_arc*

oracle   13452     1  0 Mar23 ?        00:01:07 ora_arc0_TWEBAPPS1

oracle   13454     1  0 Mar23 ?        00:00:30 ora_arc1_TWEBAPPS1

oracle   15402     1  0 Mar23 ?        00:00:50 ora_arc0_SXCOM1

oracle   15404     1  0 Mar23 ?        00:00:08 ora_arc1_SXCOM1

oracle   16122     1  0 Mar23 ?        00:00:40 ora_arc0_SVNDAPPS1

oracle   16124     1  0 Mar23 ?        00:00:06 ora_arc1_SVNDAPPS1

oracle   17301     1  0 Mar23 ?        00:00:32 ora_arc0_SOPTIX1

oracle   17303     1  0 Mar23 ?        00:00:04 ora_arc1_SOPTIX1

oracle   18581     1  0 Mar23 ?        00:00:39 ora_arc0_QVNDAPPS1

oracle   18583     1  0 Mar23 ?        00:01:18 ora_arc1_QVNDAPPS1

oracle   21173     1  0 Mar23 ?        00:00:14 ora_arc0_SWEBAPPS1

oracle   21175     1  0 Mar23 ?        00:00:52 ora_arc1_SWEBAPPS1

but we were not able to remove those .arc files from that folder.
finally we have down all the instances and deleted those files manually.

could you please advise this can be done without bouncing the instances ?

Thank yoiu
kesavan

Report message to a moderator