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

In view of how to delete the archivelog file in Oracle, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

Oracle correctly deletes the archivelog file

The correct method:

1. Connect the target DB with RMAN: (you need to make sure that DB is on)

RMAN target sys/*@orcl Direct rman target /

two。 In the RMAN command window, enter the following command:

Crosscheck archivelog all

Delete expired archivelog all

Or delete the archivelog before the specified time:

DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7'; (specifies to delete the archive log 7 days ago)

Delete noprompt force archivelog all

Remarks delete noprompt backup of archivelog all completed before 'sysdate-1'

Many of the logs below cd / data/u01/app/oracle/archivelog/thwinddb can be deleted.

This is the answer to the question about how to delete the archivelog file in Oracle. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

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.