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

This article mainly introduces how to write the DG archive log deletion script, the article is very detailed, has a certain reference value, interested friends must read it!

Due to the shortage of disk resources, a strategy for archiving log processing is needed.

I found several scripts on the Internet and found it so troublesome to write.

Mao, so I simply wrote one, and the actual path can be modified by myself.

The main library and backup database can be used. You can do crontab by yourself. It is recommended to stagger the time.

It should be noted that DEST_ID is queried in advance. The following is the script for deleting the main library (you only need to change the dest_id for the slave database). In my main library v$archived_log, the archive dest_id=1 of the main library, and the slave database is dest_id=2.

1. #! / bin/bash

two。

3. # easy script by lcrash @ 2011-1-2

4. # for delete DG archive log #

5. # you should modify USER_HOME & & make sure del_dir exists#

6. # and you can change your keep date by modify SQL below #

7. #

8.

9. USER_HOME=/opt/Oracle

10.DEL_DIR=$USER_HOME/del_arch

11.

12.source $USER_HOME/.bash_profile

13.$ORACLE_HOME/bin/sqlplus-S "/ as sysdba"

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.