1windows expdp导出脚本：
@echo off   
echo ================================================   
echo  Windows环境下Oracle数据库的自动备份脚本  
echo  1. 使用当前日期命名备份文件。  
echo  2. 自动删除7天前的备份。  
echo ================================================
::以“YYYYMMDD”格式取出当前时间。  
set BACKUPDATE=%date:~0,4%%date:~5,2%%date:~8,2%
::设置导出的路径
set DATADIR=F:\EASDB_oracle_bakup
set NLS_LANG=american_america.AL32UTF8
set

expdp \" / as sysdba \"  directory=KINGDEE_BAKUP dumpfile=kingdee%BACKUPDATE%.dmp logfile=kingdee%BACKUPDATE%_NEW.log schemas=kingdee   parallel=15 EXCLUDE="TABLE:LIKE'VT%%'"，statistics
@echo::删除7天前的备份。  
@echoforfiles /p %DATADIR% /s /m HBGYDX*.DUMP /d -7 /c "cmd /c del @path"
exit

2.windows下rman脚本：
set oracle_sid=test
set yy=%date:~0,4%
set mm=%date:~5,2%
set day=%date:~8,2%
set exp_file=%yy%-%mm%-%day%
D:\oracle\product\11.2.0\db_1\BIN\rman.exe target Test12/Test$2012 msglog D:\test_backup\logs\L0_test_rman_%exp_file%.log cmdfile=D:\test_backup\Scripts\rmanscripts\L0_backup.rman


RUN
{
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'E:\backup\rman\control%F';
allocate channel c1 type disk;
allocate channel c2 type disk;
backup as compressed backupset format 'E:\backup\rman\%T_%d_%s_%p.dat' tag 'full_dat' database plus archivelog;
backup as compressed backupset format 'E:\backup\rman\%T_%d_%s_%p.ora' tag 'full_ora' spfile;
backup as compressed backupset format 'E:\backup\rman\%T_%d_%s_%p.ctl' tag 'full_ctl' current controlfile;
backup as compressed backupset format 'E:\backup\rman\AL_%d_%T_S%s_P%p' tag 'all_arc' archivelog all delete input;
release channel c1;
release channel c2;
report obsolete;
crosscheck backup;
crosscheck copy;
delete noprompt expired backup;
delete noprompt expired copy;
delete noprompt obsolete;
delete noprompt expired archivelog all;
delete noprompt archivelog until time 'sysdate-2';
}
exit;

上面脚本中文件夹需要根据环境进行改动。