重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: [oracle]Windows版全备脚本 [打印本页]

作者: Inkcup 时间: 2025-9-13 10:48
标题: [oracle]Windows版全备脚本
注意：脚本分为两个文件
①
rmanbackup.bat
rman target / cmdfile=D:\bak0903\scripts\bak.rcv log=D:\bak0903\scripts\rmanbak_log\rmanbk_%T.log append
②
bak.rcv
run{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
report obsolete;
crosscheck backup;
delete noprompt expired backup;
backup as compressed backupset database format 'D:\bak0903\rmanbak\nwppdb_full_%U.dbf' plus archivelog format 'D:\bak0903\rmanbak\arch_%U.bak';
backup current controlfile format 'D:\bak0903\rmanbak\controlfile_%T_%U_%t.crl';
backup spfile format 'D:\bak0903\rmanbak\spfile_%T_%U_%t.ora';
delete noprompt obsolete;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
#注意：开启的通道和释放的通道要一一对应

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)