RMAN backup script in Linux

SKIP Option
Excludes datafiles or archived redo logs from the backup set according to the criteria specified by the following keywords.
Note: You can also specify this option in the backupSpec clause.

OFFLINE
Specifies that offline datafiles shocould be excluded from the backup set.

READONLY
Specifies that read-only datafiles shocould be excluded from the backup set.

INACCESSIBLE
Specifies that datafiles or archived redo logs that cannot be read due to I/O errors shocould be excluded from the backup set.

A datafile is only considered inaccessible if it cannot be read. Some offline datafiles can be still be read because they still exist on disk. Others have been deleted or moved and

So cannot be read, making them inaccessible.

FILESPERSET = integer
Specifies the maximum number of input files in each backup set. If you set FILESPERSET = n, then RMAN never than DES more than n files in a backup set. The default

FILESPERSET is the lesser of these two values: 64, number of input files divided by the number of channels. For example, if you back up 100 datafiles by using two channels, RMAN

Sets FILESPERSET to 50.

RMAN always attempts to create enough backup sets so that all allocated channels have work to do. an exception to the rule occurs when there are more channels than files to back up. for example, if RMAN backs up two datafiles when three channels are allocated and FILESPERSET = 1, then one channel is necessarily idle.

Example:
The average number of files refers to the number of files/channels.
Allocate channel provides backup concurrency. If the average number of files <filesperset, backup is performed based on the average number of files/backup sets. If the number of files exceeds the limit, backup sets are generated based on the number of filesperset. For example:
1. run {
Allocate channel category type disk;
Allocate channel ch2 type disk;
Backup datafile 3, 4, 5, 6 filesperset 3;
Release channel identifier;
Release channel ch2;
}
The average value is 4 (number of files)/2 (number of channels) = 2. If the value is smaller than filesperset 3, two backup sets are generated. Each backup set contains two data files.

2. run {
Allocate channel category type disk;
Allocate channel ch2 type disk;
Backup datafile 3, 4, 5, 6 filesperset 1;
Release channel identifier;
Release channel ch2;
}
Generates four backup sets, each containing one data file

Rman nocatalog target sys/Oracle msglog rmanLog. out append -- append the command execution log to the rmanLog. out file. If no append exists, the existing rmanLog. out file is overwritten.

Backup script:

1. ######################################## #################################
2. # T_database_backup.sh ##
3. # Created by Tianlesoftware ##
4. #2010-7-16 ##
5. ######################################## #################################
6. #! /Bin/bash
7. #---------------------------------------------------------------------------
8. # Determine the user which is executing this script.
9. #---------------------------------------------------------------------------
10. CUSER = 'id | cut-d "("-f2 | cut-d ")"-f1'
12. #---------------------------------------------------------------------------
13. # Put output in <this file name>. out. Change as desired.
14. # Note: output directory requires write permission.
15. #---------------------------------------------------------------------------
16. RMAN_LOG_FILE =$ {0}. out
17. #---------------------------------------------------------------------------
18. # You may want to delete the output file so that backup information does
19. # Not accumulate. If not, delete the following lines.
20. #---------------------------------------------------------------------------
21. If [-f "$ RMAN_LOG_FILE"]
22. Then
23. Rm-f "$ RMAN_LOG_FILE"
24. Fi
25. #-----------------------------------------------------------------
26. # Initialize the log file.
27. #-----------------------------------------------------------------
28. Echo> $ RMAN_LOG_FILE
29. Chmod 666 $ RMAN_LOG_FILE
30. #---------------------------------------------------------------------------
31. # Log the start of this script.
32. #---------------------------------------------------------------------------
33. Echo Script {1 }>>$ RMAN_LOG_FILE
34. Echo === started on 'date' ==>> $ RMAN_LOG_FILE
35. Echo> $ RMAN_LOG_FILE
36. #---------------------------------------------------------------------------
37. # Oracle home path.
38. #---------------------------------------------------------------------------
39. ORACLE_HOME =/home/oracle/product/10.2.0/db_1
40. Export ORACLE_HOME
41. #---------------------------------------------------------------------------
42. # The Oracle SID of the target database.
43. #---------------------------------------------------------------------------
44. ORACLE_SID = oralife
45. Export ORACLE_SID
46. #---------------------------------------------------------------------------
47. # The Oracle DBA user id (account ).
48. #---------------------------------------------------------------------------
49. ORACLE_USER = oracle
50. Export ORACLE_USER
51. #---------------------------------------------------------------------------
52. # Set the Oracle Recovery Manager name.
53. #---------------------------------------------------------------------------
54. RMAN = $ ORACLE_HOME/bin/rman
55. #---------------------------------------------------------------------------
56. # Print out the value of the variables set by this script.
57. #---------------------------------------------------------------------------
58. Echo> $ RMAN_LOG_FILE
59. Echo "RMAN: $ RMAN" >>$ RMAN_LOG_FILE
60. Echo "ORACLE_SID: $ ORACLE_SID" >>$ RMAN_LOG_FILE
61. Echo "ORACLE_USER: $ ORACLE_USER" >>$ RMAN_LOG_FILE
62. Echo "ORACLE_HOME: $ ORACLE_HOME" >>$ RMAN_LOG_FILE
63. #---------------------------------------------------------------------------
64. # Print out the value of the variables set by bphdb.
65. #---------------------------------------------------------------------------
66. # Echo> $ RMAN_LOG_FILE
67. # Echo "NB_ORA_FULL: $ NB_ORA_FULL"> $ RMAN_LOG_FILE
68. # Echo "NB_ORA_INCR: $ NB_ORA_INCR"> $ RMAN_LOG_FILE
69. # Echo "NB_ORA_CINC: $ NB_ORA_CINC"> $ RMAN_LOG_FILE
70. # Echo "NB_ORA_SERV: $ NB_ORA_SERV"> $ RMAN_LOG_FILE
71. # Echo "NB_ORA_POLICY: $ NB_ORA_POLICY"> $ RMAN_LOG_FILE
72. #---------------------------------------------------------------------------
73. # NOTE: This script assumes that the database is properly opened. If desired,
74. # This wocould be the place to verify that.
75. #---------------------------------------------------------------------------
76. Echo> $ RMAN_LOG_FILE
77. #---------------------------------------------------------------------------
78. #---------------------------------------------------------------------------
79. # Call Recovery Manager to initiate the backup.
80. #---------------------------------------------------------------------------
82. Pai_str ="
83. ORACLE_HOME = $ ORACLE_HOME
84. Export ORACLE_HOME
85. ORACLE_SID = $ ORACLE_SID
86. Export ORACLE_SID
87. $ RMAN nocatalog target sys/admin msglog $ RMAN_LOG_FILE append <EOF
88. RUN {
89. Allocate channel c1 type disk;
90. Allocate channel c2 type disk;
92. Backup format '/home/oracle/backup/oralife _ % U _ % t' skip inaccessible filesperset 5 database tag oralife_hot_db_bk;
94. SQL 'alter system archive log current ';
96. BACKUP format'/home/oracle/backup/arch _ % U _ % t' skip inaccessible filesperset 5 archivelog all delete input;
98. Backup current controlfile tag = 'bak _ ctlfile 'format ='/home/oracle/backup/ctl_file _ % U _ % T ';
99. Backup spfile tag = 'spfile' format = '/home/oracle/backup/oralife_spfile _ % U _ % T ';
101. Release channel c2;
102. Release channel c1;
103. }
104. Report obsolete;
105. Delete noprompt obsolete;
106. Crosscheck backup;
107. Delete noprompt expired backup;
108. List backup summary;
109. # EOF
110. "
111. # Initiate the command string
113. If ["$ CUSER" = "root"]
114. Then
115. Echo "Root Command String: $ CMD_STR" >>$ RMAN_LOG_FILE
116. Su-$ ORACLE_USER-c "$ pai_str"> $ RMAN_LOG_FILE
117. RSTAT = $?
118. Else
119. Echo "User Command String: $ pai_str" >>$ RMAN_LOG_FILE
120. /Bin/sh-c "$ CMD_STR"> $ RMAN_LOG_FILE
121. RSTAT = $?
122. Fi
124. #---------------------------------------------------------------------------
125. # Log the completion of this script.
126. #---------------------------------------------------------------------------
127. If ["$ RSTAT" = "0"]
128. Then
129. LOGMSG = "ended successfully"
130. Else
131. LOGMSG = "ended in error"
132. Fi
134. Echo> $ RMAN_LOG_FILE
135. Echo Script {1 }>>$ RMAN_LOG_FILE
136. Echo ===$ LOGMSG on 'date' ====>> $ RMAN_LOG_FILE
137. Echo> $ RMAN_LOG_FILE
139. #/Bin/mailx-s "RMAN Backup SID" daimm@sf-express.com <$ RMAN_LOG_FILE
141. Exit $ RSTAT

Email configuration...

Refer: