Shulou(Shulou.com)06/01 Report--

Export by exp:

1. Automatically generate Oracle backup files according to the date

@ echo off echo is backing up the Oracle database. Please wait a moment. Exp userid=' username / password @ SID' file=D:\ bak\ res_%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=D:\ bak\ res_%date:~0,4%%date:~5,2%%date:~8,2%.log owner=res echo task completed!

2. Automatically generate Oracle backup files according to the date and time

@ echo off echo is backing up the Oracle database. Please wait a moment. Exp userid=' username / password @ SID' file=D:\ bak\ res_%date:~0,4%%date:~5,2%%date:~8,2%%Time:~0,2%%Time:~3,2%%Time:~6,2%.dmp log=D:\ bak\ res_%date:~0,4%%date:~5,2%%date:~8,2%%Time:~0,2%%Time:~3,2%%Time:~6,2%.logecho task completed!

3. Exit automatically after the backup ends with exit:

@ echo off echo = = automatic backup script for Oracle database in echo Windows environment echo 1. Name the backup file with the current date. Echo 2. Automatically delete backups from 7 days ago. Echo =:: take out the current time in "YYYYMMDD" format. Set BACKUPDATE=%date:~0,4%%date:~5,2%%date:~8,2%%Time:~0,2%%Time:~3,2%%Time:~6,2%:: creates a backup directory. If not exist "D:\ backup\ data" mkdir D:\ backup\ data if not exist "D:\ backup\ log" mkdir D:\ backup\ log set DATADIR=D:\ backup\ dataset LOGDIR=D:\ backup\ logexp userid=' username / password @ SID' file=%DATADIR%\ data_%BACKUPDATE%.dmp log=%LOGDIR%\ log_%BACKUPDATE%.log:: delete the backup 7 days ago. Forfiles / p "% DATADIR%" / s / m *. * / d-7 / c "cmd / c del @ path" forfiles / p "% LOGDIR%" / s / m *. / d-7 / c "cmd / c del @ path" exit

Note: if sometimes we write bat script execution in a flash, can not be wrong, then I can add a pause at the end of the script (such as the above script can change exit to pause), after the end of the execution with pause, will be prompted to press any key to continue or exit, so that I can know what is wrong.

Export by expdp method:

Exit automatically after the backup ends with exit:

@ echo off echo = = automatic backup script for Oracle database in echo Windows environment echo 1. Name the backup file with the current date. Echo 2. Automatically delete backups from 10 days ago. Echo 3. To export using the expdb command, you need to first create a backup file storage directory in the database. The sql is as follows: echo create directory backdir as'd:\ backup\ data'; echo = =:: fetch the current time in "YYYYMMDD" format. Set BACKUPDATE=%date:~0,4%%date:~5,2%%date:~8,2%%Time:~0,2%%Time:~3,2%%Time:~6,2%:: sets the user name, password, and sid. Set bakdbname=appset bakdbpasswd=123set sid=orclset dumpbame=appbakset bakdbhome=D:\ backup\ data:: create a backup directory. If not exist "D:\ backup\ data" mkdir D:\ backup\ data::expdp backup expdp% bakdbname%/%bakdbpasswd%@%sid% directory=backdir dumpfile=%dumpbame%_%BACKUPDATE%.dmp logfile=%dumpbame%_%BACKUPDATE%.log:: switch directory d:cd% bakdbhome%:: call rar to compress: method 1 winrar compresses log and dmp files into zip Do not keep the original log,dmp file (optional) "C:\ Program Files\ WinRAR\ Rar" a-M5-dw% dumpbame%_%BACKUPDATE% ".zip"% dumpbame%_%BACKUPDATE%.DMP:: method use winrar to compress the log and dmp files into zip and keep the original file log Dmp file (either), remove the parameter dw "C:\ Program Files\ WinRAR\ WinRAR.exe" a-m5% dumpbame%_%BACKUPDATE% ".zip"% dumpbame%_%BACKUPDATE%.log% dumpbame%_%BACKUPDATE%.DMP:: to delete the backup 10 days ago. Forfiles / p "% bakdbhome%" / s / m * .zip / d-10 / c "cmd / c del @ path" forfiles / p "% bakdbhome%" / s / m * .log / d-10 / c "cmd / c del @ path" forfiles / p "% bakdbhome%" / s / m * .dmp / d-10 / c "cmd / c del @ path" exit

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.