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

1. Common commands

SQL > show parameter log_archive_dest;SQL > archive log list;SQL > select * from variegated flashbacks recoveryAREAGE USAGEX ARCHIVELOG 96.620 141SQL > select sum (percent_space_used) * 3 100 from v$flash_recovery_area_usage

2.9904

SQL > show parameter recover;db_recovery_file_dest string / u01/oracle/flash_recovery_areadb_recovery_file_dest_size big integer 2G

2. Delete the log

Cd $ORACLE_BASE/flash_recovery_area/orcl/archivelog

Transfer or clear the corresponding archive log, delete some files in the unused date directory, and keep the last few files. After deleting the archive log, you must use RMAN to maintain the control file, otherwise the space display will not be released.

3. Delete RMAN expired backup

Rman target sys/passwordRMAN > crosscheck archivelog all;RMAN > delete expired archivelog all

Or

RMAN > delete archivelog until time "sysdate-1"

4. Check again

SQL > select * from V$FLASH_RECOVERY_AREA_USAGE

5. Modify the size

SQL > alter system set db_recovery_file_dest_size=4G scope=both

Summary

The above is introduced to you by the editor to solve the problem that Oracle database archive logs occupy full disk space. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

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.