#!/bin/sh

. /home/oracle/.bash_profile

export ORACLE_SID=hrdg

$ORACLE_HOME/bin/sqlplus -silent "/ as sysdba" < /home/oracle/scripts/deletehrdgarch.sh
set heading off;
set pagesize 0;
set term off;
set feedback off;
set linesize 32767;
select 'rm -rf '||name from v$archived_log where DELETED='NO' and APPLIED='YES';
exit;
EOF

sh /home/oracle/scripts/deletehrdgarch.sh

rman target /<crosscheck archivelog all;
delete noprompt expired archivelog all;
exit;
END

[@more@]Dat

ITPub博客

DataGuard已应用归档日志删除脚本

最新文章