Linux under Rman backup shell script

Rman backup is easy to use and inexpensive for Oracle database backup and recovery. For non-catalog mode, it is undoubtedly the first choice to embed Rman scripts into shell scripts and then use crontab to make small database database backups. This article provides an easy-to-use Rman backup script based on the Linux shell for reference. You can make the appropriate adjustments according to your own needs.

Rman backup related Aspects of knowledge, you can refer to:
Overview of RMAN and its architecture
RMAN configuration, monitoring and management
An explanation of RMAN backup
RMAN Restore and recovery
Creation and use of RMAN catalog
Create an Rman storage script based on catalog
Catalog-based Rman backup and recovery
RMAN Backup Path confused

The second is to call the Sql,rman statement in the shell script for reference
Linux/unix calling Sql,rman script in shell script
Linux/unix passing variables between shell SQL

The following is the specifics of the script:

[Python]View PlainCopy print?

2. ##===========================================================
4. # # Db_bak_rman.sh
6. # # Created by Robinson
8. # 2011/11/07
10. # # Usage:db_bak_rman.sh < $ORACLE _sid> < $BACKUP _level>
12. # # Backup_level:
14. # # F:full Backup
16. # # 0:level 0
18. # # 1:level 1
20. ##============================================================
22. #!/bin/bash
24. # User specific environment and startup programs
28. If [-f ~/.bash_profile];
30. Then
32. . ~/.bash_profile
34. Fi
38. oracle_sid=${1}; Export Oracle_sid
40. rman_level=${2}; Export Rman_level
42. timestamp= ' Date +%y%m%d%h%m '; Export TIMESTAMP
44. Date= ' Date +%y%m%d '; Export DATE
46. Rman_dir=/u02/database/${oracle_sid}/backup/rman; Export Rman_dir
48. Rman_data=${rman_dir}/${date}; Export Rman_data
50. #RMAN_LOG = $RMAN _data/log; Export Rman_log
52. Rman_log=/u02/database/${oracle_sid}/backup/rman/log Export Rman_log
56. # Check Rman Level
58. #======================================================================
60. If [ "$RMAN _level" = = "F"];
62. Then unset INCR_LVL
64. Backup_type=full
66. Else
68. Incr_lvl="INCREMENTAL level ${rman_level}"
70. Backup_type=lev${rman_level}
72. Fi
76. Rman_file=${rman_data}/${oracle_sid}_${backup_type}_${timestamp}; Export Rman_file
78. Ssh_log=${rman_log}/${oracle_sid}_${backup_type}_${timestamp}.log; Export Ssh_log
80. Maxpiecesize=4G; Export Maxpiecesize
84. #Check RMAN Backup Path
86. #=========================================================================
90. if! Test-d ${rman_data}
92. Then
94. Mkdir-p ${rman_data}
96. Fi
100. echo "---------------------------------" >>${ssh_log}
102. echo "" >>${ssh_log}
104. echo "Rman Begin to Working ..." >>${ssh_log}
106. echo "Begin time at:" ' Date '--' date +%y%m%d%h%m ' >>${ssh_log}
110. #Startup Rman to Backup
112. #=============================================================================
114. $ORACLE _home/bin/rman Log=${rman_file}.log <<eof
116. Connect Target/
118. Run {
120. CONFIGURE RETENTION POLICY to RECOVERY windows of 3 days;
122. CONFIGURE BACKUP optimization on;
124. CONFIGURE Controlfile autobackup on;
126. CONFIGURE controlfile autobackup FORMAT for DEVICE TYPE DISK to ' ${rman_file}_%f ';
128. ALLOCATE CHANNEL ' ch1 ' TYPE DISK maxpiecesize=${maxpiecesize};
130. ALLOCATE CHANNEL ' CH2 ' TYPE DISK maxpiecesize=${maxpiecesize};
132. Set limit channel ch1 readrate=10240;
134. Set limit channel ch1 kbytes=4096000;
136. Set limit channel CH2 readrate=10240;
138. Set limit channel CH2 kbytes=4096000;
140. Crosscheck ARCHIVELOG All;
142. DELETE noprompt EXPIRED ARCHIVELOG all;
144. BACKUP
146. #AS Compressed BACKUPSET
148. ${INCR_LVL}
150. DATABASE FORMAT ' ${rman_file}_%u ' TAG ' ${oracle_sid}_${backup_type}_${timestamp} ';
152. SQL ' ALTER SYSTEM ARCHIVE LOG current ';
154. BACKUP ARCHIVELOG all FORMAT ' ${rman_file}_arc_%u ' TAG ' ${oracle_sid}_arc_${timestamp} '
156. DELETE INPUT;
158. DELETE noprompt OBSOLETE;
160. RELEASE CHANNEL ch1;
162. RELEASE CHANNEL CH2;
164. }
166. SQL "ALTER DATABASE backup Controlfile to ' ${rman_data}/cntl_${backup_type}.bak";
168. Exit
170. Eof
172. Rc=$?
176. Cat ${rman_file}.log >>${ssh_log}
178. echo "Rman Stop working @ time:" ' Date ' date +%y%m%d%h%m ' >>${ssh_log}
182. Echo >>${ssh_log}
184. echo "------------------------" >>${ssh_log}
186. echo "------Disk Space------" >>${ssh_log}
188. Df-h >>${ssh_log}
192. Echo >>${ssh_log}
196. If [$RC-ne "0"]; Then
198. echo "------error------" >>${ssh_log}
200. Else
202. echo "------no error found during RMAN backup peroid------" >>${ssh_log}
204. RM-RF ${rman_file}.log
206. Fi
210. #Remove old backup than 3 days
212. #============================================================================
214. rmdir=${rman_dir}/'/bin/date +%y%m%d-d "3 days Ago"; Export RMDIR
216. Echo >>${ssh_log}
218. ECHO-E "------Remove old backup than 3 days------\ n" >>${ssh_log}
222. If Test-d ${rmdir}
224. Then
226. RM-RF ${rmdir}
228. Rc=$?
230. Fi
234. Echo >>${ssh_log}
238. If [$RC-ne "0"]; Then
240. ECHO-E "------Remove old Backup exception------\ n" >>${ssh_log}
242. Else
244. ECHO-E "------No error found during remove old backup set peroid------\ n" >>${ssh_log}
246. Fi
250. Exit
254. [Email protected]:~/robinson/scripts/dba_scripts/custom/sql>./db_bak_rman.sh GOBO1 0
256. Rman> rman> 2> 3>  4> 5> 6>  7> 8> 9>  10> 11> 12>  13> 14> 15>    
258. 16> 17> 18> 19> 20> 21> 22> 23> 24> rman> rman>
260. [Email protected]:~/robinson/scripts/dba_scripts/custom/sql>
264. [Email protected]:/u02/database/gobo1/backup/rman> ls
266. 20120928 Log
268. [Email protected]:/u02/database/gobo1/backup/rman/20120928> ls
270. Cntl_lev0.bak gobo1_lev0_201209281421_arc_4onmb9ro_1_1
272. Gobo1_lev0_201209281421_4knmb9jn_1_1 gobo1_lev0_201209281421_c-733951103-20120928-
274. Gobo1_lev0_201209281421_4lnmb9jn_1_1 gobo1_lev0_201209281421_c-733951103-20120928-
276. Gobo1_lev0_201209281421_arc_4nnmb9rn_1_1
278. Ext.: http://blog.csdn.net/leshami/article/details/8029245

Linux under Rman backup shell script