Database Software

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!

Cannot delete archivelog on Primary database in primary/Logical config.

Pradeep GuptaOct 27 2010 — edited Feb 28 2011

Hi All,

We have primary/Logical database configuration in production(both are in ASM and RAC). few days back, we had some problem with Logical database and some archive log not shipped to Logical server.

So we manually copied archivelog using RMAN and then registered these archive log in Logical standby database.

Now we cant delete these archivelog from primary database. I tried to delete them using RMAN and ASMCMD(rm) both no success. it says it is currently being accessed(below is the error). Since this is production, I cant bring down to clear this up.

Could you please help me out in this. Thanks so much.

ORA-15028: ASM file '+ARCH01/PIP1/ARCHIVELOG/2010_10_20/thread_3_seq_95718.1165.732918275' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2011

Added on Oct 27 2010

#database-key-features, #replication

1 comment

527 views