Oracle Database Automatic Export backup script (in Windows)

2. Transferred fromOracle Database Automatic Export backup script (in Windows)
   Because WinRAR charges fees, I modified the script to use 7zip for compression.
4. @ EchoOff
6. @ Echo ===================================================== ============================================
8. @ Echo the Oracle database's Automatic Export backup script (in Windows ).
10. @ ECHO: Schedule orAtCommand settings are automatically executed.
12. @ Echo ===================================================== ============================================
16. @ Echo ===================================================== ==========================================
18. @ Echo the Oracle database's Automatic Export backup script (in Windows ).
20. @ ECHO: the following variables must be configured when the backup is started.
22. @ Echo 1. backup_dir specifies the intermediate directory to be backed up. After compression is completed, it will be moved to the backup_warehouse directory.
24. @ Echo 2. backup_warehouse specifies the storage location of historical backup data (compressed data) and logs
26. @ Echo 3. oracle_username specifies the Oracle user name used for backup
28. @ Echo 4. oracle_password specifies the Oracle password used for backup.
30. @ Echo 5: oracle_db specifies the Oracle service name used for backup
32. @ Echo 6. back_option backup option. It can be empty orFull= Y, can be owner = a user, B user or tables = () and so on ....
34. @ Echo 7. rar_cmd specifies the directory where the RAR command line compression tool is located.
36. @ Echo 8 and zip_cmd specify the directory where the 7zip command line compression tool is located (open-source free)
38. @ Echo ===================================================== ==========================================
42. @ Echo ===================================================== ======================
44. @ Echo back up Database Service Data
46. @ Echo ===================================================== ======================
50. The following REM variables need to be configured according to the actual situation
52. SetBackup_dir = D:/proj/dbbackup
54. SetBackup_warehouse = D:/proj/dbbackup/File
56. SetOracle_username =User
58. SetOracle_password = pwd
60. SetOracle_db = tnsname
62. SetBack_option ="Owner = user"
64. SetRar_cmd ="C:/program files (x86)/WinRAR/winrar.exe"
66. SetZip_cmd ="C:/program files (x86)/7-zip/7z.exe"
70. For/F"Tokens = 1, 2"%In('Date/t') DoSetToday = %
72. Rem if the file name takes hours and minutes, use the first line of the following statement.
74. RemSetBack_name = % oracle_db % _ % today % (%Time:~ 0, 2% hour %Time:~ 3, 2% )_
76. SetBack_name = % oracle_db % _ % oracle_username % _ % today %
78. SetBack_full_name = % backup_dir %/% back_name %
84. Rem logs the operation to the batch processing log % back_full_name % _ bat. log.
88. Echo =========================== backup database service data ========================== >>% back_full_name % _ bat. log
90. Echo backup starts...> % back_full_name % _ bat. Log
92. Echo current time: %Date%Time%> % Back_full_name % _ bat. Log
98. Exp % oracle_username %/% oracle_password % @ % oracle_db % grants = Y % back_option % file ="% Back_full_name %. dmp"Log ="% Back_full_name % _ exp. log"
104. IfNotExist % backup_warehouse %/% back_name % _ logic (MD % backup_warehouse %/% back_name % _ logic)
108. Echo compresses and deletes the original DMP file...> % back_full_name % _ bat. Log
110. Echo current time: %Date%Time%> % Back_full_name % _ bat. Log
114. Rem uses 7zip to compress and comment out the WinRAR command.
116. REM % rar_cmd % A-DF"%Back_name1__logic.rar" "% Back_full_name %. dmp"
118. % Zip_cmd % A-tzip"%Back_name1__logic.zip" "% Back_full_name %. dmp"
120. Rem Delete source file
122. Del"% Back_full_name %. dmp"
126. Echo"% Back_full_name % exp. log"
128. Echo compresses and deletes the original DMP file! >>% Back_full_name % _ bat. Log
130. Echo current time: %Date%Time%> % Back_full_name % _ bat. Log
134. Echo starts to move the file...> % back_full_name % _ bat. Log
136. Echo current time: %Date%Time%> % Back_full_name % _ bat. Log
140. Rem uses 7zip to compress and comment out the WinRAR command.
142. RemMove% Backup_dir %/*. rar % backup_warehouse %/% back_name % _ logic/
144. Move% Backup_dir %/*. Zip % backup_warehouse %/% back_name % _ logic/
148. ECHO file moved! >>% Back_full_name % _ bat. Log
150. Echo current time: %Date%Time%> % Back_full_name % _ bat. Log
154. Rem net send % userdomain %"The logical backup of the database has been completed at: % date % time %! "
158. Echo.
160. Echo backup complete !!! >>% Back_full_name % _ bat. Log
162. Echo current time: %Date%Time%> % Back_full_name % _ bat. Log
164. Echo =================== the backup of Database Service data is complete !!! ==================>> % Back_full_name % _ bat. Log
166. Move% Backup_dir %/*. Log % backup_warehouse %/% back_name % _ logic/
168. Echo.