Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

ORA-15028 error occurred when deleting archive

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

Shulou(Shulou.com)06/02 Report--

Use RMAN to delete the archive error ORA-15028 in the 10.2.0.4 RAC environment.

The error message is as follows:

RMAN > delete archivelog all completed before 'sysdate-3'

Do you really want to delete the above objects (enter YES or NO)? YES

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03009: failure of delete command on ORA_DISK_1 channel at 07/10/2012 07:24:27

ORA-15028: ASM file'+ DATA/archive/orcl1/1_78034_751396292.dbf' not dropped; currently being accessed

The specific description on the MOS of Oracle is: Unable to Delete an ASM File From RMAN and at OS Level (ORA-15028) [ID 1472178.1]. According to the description of the document, the reason for this problem is that the replication process is deployed and the replication process is suspended, so that the file cannot be deleted. The solution is to stop and restart the replication software to release the lock on the file.

The DSG replication tool was indeed deployed in the customer's environment, but the customer restarted the entire database in order to solve the problem, and the problem was also solved. However, this does not mean that the problem must be on the database instance, because once the database is restarted, the corresponding process of DSG replication is also released. If the problem is caused by the death of the replication tool HANG, then the database restart achieves the purpose of restarting the replication software process in disguise, so the problem is solved as well.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report