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;
configure retention policy to redundancy 5;
backup as compressed backupset database
format '\\132.147.163.33\yuangan_backup\full_%d_%T_%U.bak'
plus archivelog
format '\\132.147.163.33\yuangan_backup\arch_%d_%T_%U.bak';
backup current controlfile
format '\\132.147.163.33\yuangan_backup\ctl_%d_%T_%U.bak';
report obsolete;
crosscheck backup;
delete noprompt obsolete;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
2. 批处理执行脚本：oracle_backup.bat
内容如下
@echo off
setlocal
:: ====================== 配置信息 ======================
set "REMOTE=\\132.147.163.33\yuangan_backup"
set "ORACLE_HOME=D:\runtime\oracle\product\11.2.0\dbhome_1"
set "ORACLE_SID=orcl"
:: =====================================================
set "PATH=%ORACLE_HOME%\bin;%PATH%"
set "BAK_DATE=%date:~0,4%%date:~5,2%%date:~8,2%"
:: 1. 用 SYSTEM 身份认证共享
D:\scripts\PsExec64.exe -accepteula -s cmd /c net use %REMOTE% Admin@9000! /user:132.147.163.33\administrator /persistent:no
|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛
( 渝ICP备12004239号-4 )
发表于 
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
支持
反对