Linux RMAN backup shell script

RMAN backup is easy to use for Oracle database backup and recovery, with low costs. For non-catalog mode, it is undoubtedly the first choice to embed the RMAN script into the shell script and then use crontab to back up small and medium databases. This document provides an easy-to-use RMAN backup script based on linux shell for your reference. You can make appropriate adjustments as needed.

The specific content of the script is as follows:

1. ##=================================================== ==================================
2. # Db_bak_rman.sh
3. # Created by Robinson
4. #2011/11/07
5. # Usage: db_bak_rman.sh <$ ORACLE_SID> <$ BACKUP_LEVEL>
6. # BACKUP_LEVEL:
7. # F: full backup
8. #0: level 0
9. #1: level 1
10. ##=================================================== ======================================
11. #! /Bin/bash
12. # User specific environment and startup programs
14. If[-F ~ /. Bash_profile];
15. Then
16. .~ /. Bash_profile
17. Fi
19. ORACLE_SID =$ {1}; Export ORACLE_SID
20. RMAN_LEVEL =$ {2}; Export RMAN_LEVEL
21. TIMESTAMP = 'date + % Y % m % d % H % m'; export TIMESTAMP
22. DATE = 'date + % Y % m % d'; export date
23. RMAN_DIR =/u02/database/$ {ORACLE_SID}/backup/rman; export RMAN_DIR
24. RMAN_DATA =$ {RMAN_DIR}/$ {DATE}; export RMAN_DATA
25. # RMAN_LOG = $ RMAN_DATA/log; export RMAN_LOG
26. RMAN_LOG =/u02/database/$ {ORACLE_SID}/backup/rman/log export RMAN_LOG
28. # Check rman level
29. #===================================================== ====================================
30. If["$ RMAN_LEVEL"="F"];
31. Then unset INCR_LVL
32. BACKUP_TYPE = full
33. Else
34. INCR_LVL ="Incremental level $ {RMAN_LEVEL }"
35. BACKUP_TYPE = lev$ {RMAN_LEVEL}
36. Fi
38. RMAN_FILE =$ {RMAN_DATA}/$ {ORACLE_SID }_$ {BACKUP_TYPE }_$ {TIMESTAMP}; export RMAN_FILE
39. SSH_LOG =$ {RMAN_LOG}/$ {ORACLE_SID }_$ {BACKUP_TYPE }_$ {TIMESTAMP}. log; export SSH_LOG
40. MAXPIECESIZE =4G; Export MAXPIECESIZE
42. # Check RMAN Backup Path
43. #===================================================== ========================================
45. If! Test-d $ {RMAN_DATA}
46. Then
47. Mkdir-p $ {RMAN_DATA}
48. Fi
50. Echo"---------------------------------">>$ {SSH_LOG}
51. Echo"">>$ {SSH_LOG}
52. Echo"Rman Begin to Working .........">>$ {SSH_LOG}
53. Echo"Begin time :"'Date' -- 'date + % Y % m % d % H % m' >>$ {SSH_LOG}
55. # Startup rman to backup
56. #===================================================== ==============================================
57. $ ORACLE_HOME/bin/rman log =$ {RMAN_FILE}. log <EOF
58. Connect target/
59. Run {
60. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW3DAYS;
61. Configure backup optimization on;
62. Configure controlfile autobackup on;
63. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK'$ {RMAN_FILE} _ % F';
64. ALLOCATE CHANNEL'Authorization'Type disk maxpiecesize =$ {MAXPIECESIZE };
65. ALLOCATE CHANNEL'Ch2'Type disk maxpiecesize =$ {MAXPIECESIZE };
66. Set limit channel ready readrate =10240;
67. Set limit channel limit kbytes =4096000;
68. Set limit channel ch2 readrate =10240;
69. Set limit channel ch2 kbytes =4096000;
70. Crosscheck archivelog all;
71. Delete noprompt expired archivelog all;
72. BACKUP
73. # AS COMPRESSED BACKUPSET
74. $ {INCR_LVL}
75. DATABASE FORMAT'$ {RMAN_FILE} _ % U'TAG'$ {ORACLE_SID }_$ {BACKUP_TYPE }_$ {TIMESTAMP }';
76. SQL'Alter system archive log current';
77. BACKUP ARCHIVELOG ALL FORMAT'$ {RMAN_FILE} _ arc _ % U'TAG'$ {ORACLE_SID} _ arc _ $ {TIMESTAMP }'
78. Delete input;
79. Delete noprompt obsolete;
80. Release channel identifier;
81. Release channel ch2;
82. }
83. SQL"Alter database backup controlfile to'' $ {RMAN_DATA}/cntl _ $ {BACKUP_TYPE}. bak ''";
84. Exit;
85. EOF
86. RC = $?
88. Cat $ {RMAN_FILE}. log >>$ {SSH_LOG}
89. Echo"Rman Stop working @ time :"'Date' date + % Y % m % d % H % m' >>$ {SSH_LOG}
91. Echo >>$ {SSH_LOG}
92. Echo"------------------------">>$ {SSH_LOG}
93. Echo"------ Disk Space ------">>$ {SSH_LOG}
94. Df-h >>$ {SSH_LOG}
96. Echo >>$ {SSH_LOG}
98. If[$ RC-ne"0"]; Then
99. Echo"------ Error ------">>$ {SSH_LOG}
100. Else
101. Echo"------ No error found during RMAN backup peroid ------">>$ {SSH_LOG}
102. Rm-rf $ {RMAN_FILE}. log
103. Fi
105. # Remove old backup than 3 days
106. #===================================================== ============================================
107. RMDIR =$ {RMAN_DIR}/'/bin/date + % Y % m % d-d"3 days ago"'; Export RMDIR
108. Echo >>$ {SSH_LOG}
109. Echo-e"------ Remove old backup than 3 days ------ \ n">>$ {SSH_LOG}
111. IfTest-d $ {RMDIR}
112. Then
113. Rm-rf $ {RMDIR}
114. RC = $?
115. Fi
117. Echo >>$ {SSH_LOG}
119. If[$ RC-ne"0"]; Then
120. Echo-e"------ Remove old backup exception ------ \ n">>$ {SSH_LOG}
121. Else
122. Echo-e"------ No error found during remove old backup set peroid ------ \ n">>$ {SSH_LOG}
123. Fi
125. Exit
127. Oracle @ SZDB :~ /Robinson/scripts/dba_scripts/custom/SQL>./db_bak_rman.sh GOBO10
128. RMAN>2>3>4>5>6>7>8>9>10>11>12>13>14>15>
129. 16>17>18>19>20>21>22>23>24> RMAN>
130. Oracle @ SZDB :~ /Robinson/scripts/dba_scripts/custom/SQL>
132. Oracle @ SZDB:/u02/database/GOBO1/backup/rman> ls
133. 20120928Log
134. Oracle @ SZDB:/u02/database/GOBO1/backup/rman/20120928> Ls
135. Cntl_lev0.bak gobow.lev0_201209281421_arc_4onmb9ro_1_1
136. GOBO1_lev0_201209281421_4knmb9jn_1_1 GOBO1_lev0_201209281421_c-733951103-20120928-00
137. GOBO1_lev0_201209281421_4lnmb9jn_1_1 GOBO1_lev0_201209281421_c-733951103-20120928-01
138. Gobow.lev0_201209281421_arc_4nnmb9rn_1_1