rman backup database full script

admin

1. #!/bin/bash
   
2. echo
   
3. echo "==================================================="
   
4. echo "BACKUP FULL DATABASE SCRIPTS"
   
5. echo "==================================================="
   
6. echo
   
7. sleep 1
   
8. 
   
9. # ###########################
   
10. # CPU count check:
    
11. # ###########################
    
12. 
    
13. # Count of CPUs:
    
14. CPU_NUM=`cat /proc/cpuinfo|grep CPU|wc -l`
    
15. export CPU_NUM
    
16. 
    
17. # #######################################
    
18. # Excluded INSTANCES:
    
19. # #######################################
    
20. # Here you can mention the instances the script will IGNORE and will NOT run against:
    
21. # Use pipe "|" as a separator between each instance name.
    
22. # e.g. Excluding: -MGMTDB, ASM instances:
    
23. 
    
24. EXL_DB="\-MGMTDB|ASM|APX"                           #Excluded INSTANCES [Will not get reported offline].
    
25. 
    
26. # ###########################
    
27. # Listing Available Databases:
    
28. # ###########################
    
29. 
    
30. # Count Instance Numbers:
    
31. INS_COUNT=$( ps -ef|grep pmon|grep -v grep|egrep -v ${EXL_DB}|wc -l )
    
32. 
    
33. # Exit if No DBs are running:
    
34. if [ $INS_COUNT -eq 0 ]
    
35. then
    
36.    echo No Database Running !
    
37.    exit
    
38. fi
    
39. 
    
40. # If there is ONLY one DB set it as default without prompt for selection:
    
41. if [ $INS_COUNT -eq 1 ]
    
42. then
    
43.    export ORACLE_SID=$( ps -ef|grep pmon|grep -v grep|egrep -v ${EXL_DB}|awk '{print $NF}'|sed -e 's/ora_pmon_//g'|grep -v sed|grep -v "s///g" )
    
44. 
    
45. # If there is more than one DB ASK the user to select:
    
46. elif [ $INS_COUNT -gt 1 ]
    
47. then
    
48.     echo
    
49.     echo "Select the ORACLE_SID:[Enter the number]"
    
50.     echo ---------------------
    
51.     select DB_ID in $( ps -ef|grep pmon|grep -v grep|egrep -v ${EXL_DB}|awk '{print $NF}'|sed -e 's/ora_pmon_//g'|grep -v sed|grep -v "s///g" )
    
52.      do
    
53.                 integ='^[1-9]+$'
    
54.                 if ! [[ ${REPLY} =~ ${integ} ]] || [ ${REPLY} -gt ${INS_COUNT} ]
    
55.                         then
    
56.                         echo
    
57.                         echo "Error: Not a valid number!"
    
58.                         echo
    
59.                         echo "Enter a valid NUMBER from the displayed list !: i.e. Enter a number from [1 to ${INS_COUNT}]"
    
60.                         echo "-----------------------------------------------"
    
61.                 else
    
62.                         export ORACLE_SID=$DB_ID
    
63.                         echo
    
64.                         printf "`echo "Selected Instance: ["` `echo -e "\033[33;5m${DB_ID}\033[0m"` `echo "]"`\n"
    
65.                         echo
    
66.                         break
    
67.                 fi
    
68.      done
    
69. 
    
70. fi
    
71. # Exit if the user selected a Non Listed Number:
    
72.         if [ -z "${ORACLE_SID}" ]
    
73.          then
    
74.           echo "You've Entered An INVALID ORACLE_SID"
    
75.           exit
    
76.         fi
    
77. 
    
78. # #########################
    
79. # Getting ORACLE_HOME
    
80. # #########################
    
81.   ORA_USER=`ps -ef|grep ${ORACLE_SID}|grep pmon|grep -v grep|egrep -v ${EXL_DB}|grep -v "\-MGMTDB"|awk '{print $1}'|tail -1`
    
82.   USR_ORA_HOME=`grep ${ORA_USER} /etc/passwd| cut -f6 -d ':'|tail -1`
    
83. 
    
84. # SETTING ORATAB:
    
85. if [ -f /etc/oratab ]
    
86.   then
    
87.   ORATAB=/etc/oratab
    
88.   export ORATAB
    
89. ## If OS is Solaris:
    
90. elif [ -f /var/opt/oracle/oratab ]
    
91.   then
    
92.   ORATAB=/var/opt/oracle/oratab
    
93.   export ORATAB
    
94. fi
    
95. 
    
96. # ATTEMPT1: Get ORACLE_HOME using pwdx command:
    
97. export PGREP=`which pgrep`
    
98. export PWDX=`which pwdx`
    
99. if [[ -x ${PGREP} ]] && [[ -x ${PWDX} ]]
    
100. then
     
101. PMON_PID=`pgrep  -lf _pmon_${ORACLE_SID}|awk '{print $1}'`
     
102. export PMON_PID
     
103. ORACLE_HOME=`pwdx ${PMON_PID}|awk '{print $NF}'|sed -e 's/\/dbs//g'`
     
104. export ORACLE_HOME
     
105. fi
     
106. 
     
107. # ATTEMPT2: If ORACLE_HOME not found get it from oratab file:
     
108. if [ ! -f ${ORACLE_HOME}/bin/sqlplus ]
     
109. then
     
110. ## If OS is Linux:
     
111. if [ -f /etc/oratab ]
     
112.   then
     
113.   ORATAB=/etc/oratab
     
114.   ORACLE_HOME=`grep -v '^\#' $ORATAB | grep -v '^$'| grep -i "^${ORACLE_SID}:" | perl -lpe'$_ = reverse' | cut -f3 | perl -lpe'$_ = reverse' |cut -f2 -d':'`
     
115.   export ORACLE_HOME
     
116. 
     
117. ## If OS is Solaris:
     
118. elif [ -f /var/opt/oracle/oratab ]
     
119.   then
     
120.   ORATAB=/var/opt/oracle/oratab
     
121.   ORACLE_HOME=`grep -v '^\#' $ORATAB | grep -v '^$'| grep -i "^${ORACLE_SID}:" | perl -lpe'$_ = reverse' | cut -f3 | perl -lpe'$_ = reverse' |cut -f2 -d':'`
     
122.   export ORACLE_HOME
     
123. fi
     
124. #echo "ORACLE_HOME from oratab is ${ORACLE_HOME}"
     
125. fi
     
126. 
     
127. # ATTEMPT3: If ORACLE_HOME is still not found, search for the environment variable: [Less accurate]
     
128. if [ ! -f ${ORACLE_HOME}/bin/sqlplus ]
     
129. then
     
130.   ORACLE_HOME=`env|grep -i ORACLE_HOME|sed -e 's/ORACLE_HOME=//g'`
     
131.   export ORACLE_HOME
     
132. #echo "ORACLE_HOME from environment  is ${ORACLE_HOME}"
     
133. fi
     
134. 
     
135. # ATTEMPT4: If ORACLE_HOME is not found in the environment search user's profile: [Less accurate]
     
136. if [ ! -f ${ORACLE_HOME}/bin/sqlplus ]
     
137. then
     
138.   ORACLE_HOME=`grep -h 'ORACLE_HOME=\/' $USR_ORA_HOME/.bash_profile $USR_ORA_HOME/.*profile | perl -lpe'$_ = reverse' |cut -f1 -d'=' | perl -lpe'$_ = reverse'|tail -1`
     
139.   export ORACLE_HOME
     
140. #echo "ORACLE_HOME from User Profile is ${ORACLE_HOME}"
     
141. fi
     
142. 
     
143. # ATTEMPT5: If ORACLE_HOME is still not found, search for orapipe: [Least accurate]
     
144. if [ ! -f ${ORACLE_HOME}/bin/sqlplus ]
     
145. then
     
146.   ORACLE_HOME=`locate -i orapipe|head -1|sed -e 's/\/bin\/orapipe//g'`
     
147.   export ORACLE_HOME
     
148. #echo "ORACLE_HOME from orapipe search is ${ORACLE_HOME}"
     
149. fi
     
150. 
     
151. # TERMINATE: If all above attempts failed to get ORACLE_HOME location, EXIT the script:
     
152. if [ ! -f ${ORACLE_HOME}/bin/sqlplus ]
     
153. then
     
154.   echo "Please export ORACLE_HOME variable in your .bash_profile file under oracle user home directory in order to get this script to run properly"
     
155.   echo "e.g."
     
156.   echo "export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1"
     
157. exit
     
158. fi
     
159. 
     
160. # ########################################
     
161. # Exit if the user is not the Oracle Owner:
     
162. # ########################################
     
163. CURR_USER=`whoami`
     
164.         if [ ${ORA_USER} != ${CURR_USER} ]; then
     
165.           echo ""
     
166.           echo "You're Running This Sctipt with User: "${CURR_USER}" !!!"
     
167.           echo "Please Run This Script With The Right OS User: "${ORA_USER}""
     
168.           echo "Script Terminated!"
     
169.           exit
     
170.         fi
     
171. 
     
172. # ###############################
     
173. # RMAN: Script Creation:
     
174. # ###############################
     
175. # Last RMAN Backup Info:
     
176. # #####################
     
177. 
     
178. # Variables:
     
179. export NLS_DATE_FORMAT="DD-MON-YY HH24:MI:SS"
     
180. 
     
181. # Building the RMAN BACKUP Script:
     
182. echo
     
183. echo Please enter the Backup Location: [e.g. /backup/DB]
     
184. echo "================================"
     
185. while read BKPLOC1
     
186.         do
     
187. 
     
188.                 if [ ! -w "${BKPLOC1}" ]; then
     
189.                  echo "Provided Backup Location is NOT Exist/Writable !"
     
190.                  echo
     
191.                  echo "Please Provide a VALID Backup Location:"
     
192.                  echo "--------------------------------------"
     
193.                 else
     
194.                 BKPLOC=${BKPLOC1}/RMANBKP_${ORACLE_SID}/`date +%y%m%d`
     
195.                 /bin/mkdir -p ${BKPLOC}
     
196.                  break
     
197.                 fi
     
198.         done
     
199. 
     
200. # Exit if the user has pressed Ctrl+D:
     
201. if [ ! -w "${BKPLOC}" ]; then
     
202. exit
     
203. fi
     
204. 
     
205. echo
     
206. echo "Backup Location is: ${BKPLOC}"
     
207. echo
     
208. echo "How many CHANNELS do you want to allocate for this backup? [${CPU_NUM} CPUs Available On This Machine]"
     
209. echo "========================================================="
     
210. while read CHANNEL_NUM
     
211.         do
     
212.                 integ='^[0-9]+$'
     
213.                 if ! [[ ${CHANNEL_NUM} =~ $integ ]] ; then
     
214.                            echo "Error: Not a valid number !"
     
215.                         echo
     
216.                         echo "Please Enter a VALID NUMBER:"
     
217.                         echo "---------------------------"
     
218.                 else
     
219.                         break
     
220.                 fi
     
221.         done
     
222. echo
     
223. echo "Number Of Channels is: ${CHANNEL_NUM}"
     
224. echo
     
225. echo "Do you want a COMPRESSED BACKUP? [Y|N]: [Y]"
     
226. echo "================================"
     
227. while read COMPRESSED
     
228.         do
     
229.                 case $COMPRESSED in  
     
230.                   ""|y|Y|yes|YES|Yes) COMPRESSED="AS COMPRESSED BACKUPSET"; echo "COMPRESSED BACKUP ENABLED.";break ;;
     
231.                   n|N|no|NO|No) COMPRESSED="";break ;;
     
232.                   *) echo "Please enter a VALID answer [Y|N]" ;;
     
233.                 esac
     
234.         done       
     
235. echo
     
236. echo "Do you want a INCREMENTAL BACKUP? [0|1|N]: [N]"
     
237. echo "================================"
     
238. while read INCREMENTAL
     
239.         do
     
240.                 case $INCREMENTAL in  
     
241.                   0) INCREMENTAL="INCREMENTAL LEVEL 0"; echo "INCREMENTAL LEVEL 0 BACKUP ENABLED.";break ;;
     
242.                   1) INCREMENTAL="INCREMENTAL LEVEL 1"; echo "INCREMENTAL LEVEL 1 BACKUP ENABLED.";break ;;
     
243.                   n|N|no|NO|No) INCREMENTAL="";echo "INCREMENTAL BACKUP NOT ENABLED.";break ;;
     
244.                   *) echo "Please enter a VALID answer [Y|N]" ;;
     
245.                 esac
     
246.         done
     
247. echo
     
248. echo "Do you want to ENCRYPT the BACKUP by Password? [Available in Enterprise Edition only] [Y|N]: [N]"
     
249. echo "=============================================="
     
250. while read ENCR_BY_PASS_ANS
     
251.         do
     
252.                 case ${ENCR_BY_PASS_ANS} in
     
253.                   y|Y|yes|YES|Yes)
     
254.                   echo
     
255.                   echo "Please Enter the password that will be used to Encrypt the backup:"
     
256.                   echo "-----------------------------------------------------------------"
     
257.                   read ENCR_PASS
     
258.                   ENCR_BY_PASS="SET ENCRYPTION ON IDENTIFIED BY '${ENCR_PASS}' ONLY;"
     
259.                   export ENCR_BY_PASS
     
260.                   echo
     
261.                   echo "BACKUP ENCRYPTION ENABLED."
     
262.                   echo
     
263.                   echo "Later, To RESTORE this backup please use the following command to DECRYPT it, placing it just before the RESTORE Command:"
     
264.                   echo "  e.g."
     
265.                   echo "  SET DECRYPTION IDENTIFIED BY '${ENCR_PASS}';"
     
266.                   echo "  restore database ...."
     
267.                   echo
     
268.                   break ;;
     
269.                   ""|n|N|no|NO|No) ENCR_BY_PASS="";break ;;
     
270.                   *) echo "Please enter a VALID answer [Y|N]" ;;
     
271.                 esac
     
272.         done
     
273. RMANSCRIPT=${BKPLOC}/RMAN_FULL_${ORACLE_SID}.rman
     
274. RMANSCRIPTRUNNER=${BKPLOC}/RMAN_FULL_nohup.sh
     
275. RMANLOG=${BKPLOC}/rmanlog.`date +%y%m%d_%H%M%S`.log
     
276. 
     
277. echo "${ENCR_BY_PASS}"      > ${RMANSCRIPT}
     
278. echo "run {"                    >> ${RMANSCRIPT}
     
279. CN=1
     
280. while [[ ${CN} -le ${CHANNEL_NUM} ]]
     
281. do
     
282. echo "allocate channel C${CN} type disk;" >> ${RMANSCRIPT}
     
283.     ((CN = CN + 1))
     
284. done
     
285. echo "CROSSCHECK ARCHIVELOG ALL;" >> ${RMANSCRIPT}
     
286. echo "BACKUP ${COMPRESSED} ${INCREMENTAL} FORMAT '${BKPLOC}/%d_%I_%t_%s_%p' TAG='FULLBKP' DATABASE;" >> ${RMANSCRIPT}
     
287. echo "SQL "ALTER SYSTEM ARCHIVE LOG CURRENT";" >> ${RMANSCRIPT}
     
288. echo "SQL "ALTER SYSTEM ARCHIVE LOG CURRENT";" >> ${RMANSCRIPT}
     
289. echo "SQL "ALTER SYSTEM ARCHIVE LOG CURRENT";" >> ${RMANSCRIPT}
     
290. echo "SQL "ALTER SYSTEM ARCHIVE LOG CURRENT";" >> ${RMANSCRIPT}
     
291. echo "BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL NOT BACKED UP FORMAT '${BKPLOC}/arch_%d_%T_%s_%p.ARC';" >> ${RMANSCRIPT}
     
292. echo "BACKUP FORMAT '${BKPLOC}/%d_%t_%s_%p.ctl' TAG='CONTROL_BKP' CURRENT CONTROLFILE;" >> ${RMANSCRIPT}
     
293. echo "CROSSCHECK ARCHIVELOG ALL;" >> ${RMANSCRIPT}
     
294. echo "REPORT OBSOLETE;" >> ${RMANSCRIPT}
     
295. echo "DELETE NOPROMPT EXPIRED BACKUP;" >> ${RMANSCRIPT}
     
296. echo "DELETE NOPROMPT OBSOLETE;" >> ${RMANSCRIPT}
     
297. echo "DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-2';" >> ${RMANSCRIPT}
     
298. echo "DELETE NOPROMPT BACKUP OF ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-2';" >> ${RMANSCRIPT}
     
299. CN=1
     
300. while [[ ${CN} -le ${CHANNEL_NUM} ]]
     
301. do
     
302. echo "RELEASE CHANNEL C${CN};" >> ${RMANSCRIPT}
     
303.     ((CN = CN + 1))
     
304. done
     
305. echo "}" >> ${RMANSCRIPT}
     
306. 
     
307. echo "RMAN BACKUP SCRIPT CREATED."
     
308. echo
     
309. sleep 1
     
310. echo "Backup Location is: ${BKPLOC}"
     
311. echo
     
312. sleep 1
     
313. echo "Starting Up RMAN Backup Job ..."
     
314. echo
     
315. sleep 1
     
316. echo "#!/bin/bash" > ${RMANSCRIPTRUNNER}
     
317. echo "nohup ${ORACLE_HOME}/bin/rman target / cmdfile=${RMANSCRIPT} | tee ${RMANLOG}  2>&1 &" >> ${RMANSCRIPTRUNNER}
     
318. chmod 740 ${RMANSCRIPTRUNNER}
     
319. source ${RMANSCRIPTRUNNER}
     
320. echo
     
321. echo " The RMAN backup job is currently running in the background. Disconnecting the current session will NOT interrupt the backup job :-)"
     
322. echo " Now, viewing the backup job log:"
     
323. echo
     
324. echo "Backup Location is: ${BKPLOC}"
     
325. echo "Check the LOGFILE: ${RMANLOG}"
     
326. echo
     

复制代码