標籤:oracle rman冷備shell指令碼
oracle rman冷備shell指令碼(我這裡是全備份,建立了2個通道c1、c2)可以在這基礎上更改
650) this.width=650;" src="http://s4.51cto.com/wyfs02/M00/86/18/wKioL1e0fHyRO_TTAABgkcV8Mm0539.png-wh_500x0-wm_3-wmp_4-s_2228178479.png" title="捕獲.PNG" alt="wKioL1e0fHyRO_TTAABgkcV8Mm0539.png-wh_50" />
文本:
#!/bin/bash
#Author:wangergui Email:[email protected] Date:2016-08-17
#Function:oracle_rman_cold_backup ( Full backup )
[ "${USER}" == "oracle" ] || exit 2
[ ! -d ${ORACLE_BASE}/myrman ] && mkdir ${ORACLE_BASE}/myrman
rman target / <<END
shutdown immediate;
startup mount;
run{
shutdown immediate;
startup mount;
allocate channel c1 type disk;
allocate channel c2 type disk; #通道只能在run塊兒中定義,不能單獨定義,所以要使用run塊兒!
backup database format ‘${ORACLE_BASE}/myrman/%d_%s.bak‘;
alter database open;
release channel c1;
release channel c2;
}
END
本文出自 “linux相關技術” 部落格,謝絕轉載!
oracle rman冷備shell指令碼