Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve the RMAN-08137 error of deleting archive log report in the database, which has certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let the editor take you to know it.

At the customer site, use the data pump to import and export data, and the previous data export has been done. When importing data in the test environment, I checked the archive log and found that it was almost full. Manually delete the expired log and the log from a week ago, but when you execute some delete statements

Delete NOPROMPT expired archivelog all

The error is as follows:

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

The analysis is made as follows:

1. It may be related to the disconnection of DG, because some log transfers are not successfully transferred to the standby database, and the primary database is not allowed to delete.

2. It may be bug of Oracle. For more information, please see

RMAN-08137 When deleting archivelogs even when Streams CAPTURE does not require them [ID 1079953.1] Bug 12412131-Archivelog backups are not being deleted by 'DELETE OBSOLETE' (document ID 12412131.8) RMAN Is Not Reporting Old Archive Log Files As Obsolete (document ID 1936141.1)

Make the following diagnostics as described in the document:

Rman target catalog debug trace='rman_debug.trc'rman target / debug trace='/u01/dba_log/rman_debug.trc'delete noprompt obsolete device type disk

Resolve:

1. Manually force deletion

Delete force noprompt archivelog until time 'sysdate-2'

2. The methods seen on the Internet

2.1 leave the log_archive_dest_2 of the main library empty, and use the following command:

Alter system set log_archive_dest_2='' scope=both sid='*'

2.2 enable log_archive_dest_stat_2 with the following command:

Alter system set log_archive_dest_state_2=enable scope=both sid='*'

Log in to rman again and delete the expired files. The result: deleted successfully. The command is as follows:

Rman target / run {delete noprompt obsolete device type disk;} Thank you for reading this article carefully. I hope the article "how to solve the RMAN-08137 error of deleting Archive Log newspaper in the database" shared by the editor will be helpful to you. At the same time, I hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.