--backup_oracle.bat文件
rman t
arget / cm
DFile=D:/backup/rman/backup_db.rman&nbs
p; LOG=d:/backup/rman/logfile/rmanlog%date:~0,4%%date:~5,2%%date:~8,2%.log
--backup_db.rman文件
configURE RETENTION
policy TO
redUNDANCY = 2;
CONFIGURE DEVICE TY
PE disk PARALLELISM 2;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
backup filesperset = 5 as com
Pressed backupset database format 'd:/backup/rman/full_%U.rman';
SQL 'alter
System
Archive log
current';
backup filesperset = 50 as com
PRessed backupset archivelog all format 'd:/backup/rman/arch_%U.rman' delete input;
DELETE nop
rompt OBSOLETE;
crosscheck backup;
delete noprompt e
xpired backup;
backup format 'd:/backup/rman/ctl_%U.rman' current controlfile;
backup spfile format 'd:/backup/rman/spfile_%U.rman' ;
ex
IT;
backup_oracle.bat
--delete_dg_archivelog.bat
rem 注意修改 部署目录
cd D:/win_xifenf
ei d:
rem 注意delete_archive.sql 查询
是否有记录
echo delete archivelog staring > delete_archivelog.bak
sqlplus / as sysdba @delete_archive.sql
echo rman target / cmdfile=rman_checkcross.rman>>delete_archivelog.bat
delete_archivelog.bat >>delete_dg_archivelog_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%".log
exit
--delete_archive.sql
set lines 150
col n
ame for a150
set pagesize 0 feedback off verify off heading off echo off
spool delete_archivelog.bat
select 'del '||name
From v$archived_log where APPLIED='YES' AND NAME IS NOT NULL and DEST_ID=1;
spool off
exit;
--rman_checkcross.rman
crosscheck archivelog all;
delete noprompt expired archivelog all;
exit
delete_dg_archivelog.bat