Automatic backup scripts for windows and linux environments
@ echo off
Echo =
Automatic backup script of 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%
:: modify the character set
Set NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8
:: set the user name, password, and database to back up.
Set USER=system
Set PASSWORD=oracle
Set DATABASE=ORCL
:: create backup directory.
If not exist "D:\ ORA_BAKUP\ data" mkdir D:\ ORA_BAKUP\ data
If not exist "D:\ ORA_BAKUP\ log" mkdir D:\ ORA_BAKUP\ log
Set DATADIR=D:\ ORA_BAKUP\ data
Set LOGDIR=D:\ ORA_BAKUP\ log
Exp% USER%/%PASSWORD%@ORCL full=y direct=y recordlength=65535 file=%DATADIR%\ exp_%DATABASE%_%BACKUPDATE%.dmp log=%LOGDIR%\ exp_%DATABASE%_%BACKUPDATE%.log
:: restore statement
:: imp username/passwd@TNS FROMUSER=** TOUSER=** FILE=** LOG=** BUFFER=20480000
:: delete the backup from 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
-Windows date representation-
Echo Date:~0,10%.rar
2016/08/08.rar (note: 0per10 refers to 10)
(so 20160808 means:)
Echo Date:~0,4%%Date:~5,2%%Date:~8,2%.rar
20160808.rar
-
#
# Linux backup script
#
-script 1 datapump-
Group business backup script
#
# Backup & Restore Script Using DataPump #
#
Export ORACLE_SID=xmtkfpr1
Export ORACLE_BASE=/oracle/app/oracle
Export ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/dbhome_1
Export PATH=$ORACLE_HOME/bin:$PATH
Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
Current_time= `date'+% Y% m% d``
# #
# 1.Backup Script
# #
Expdp username jtchart wsqpool wsqpool 2016 subscription! Directory=dmp_bak_dir filesize=10G dumpfile=expdp_db_jt_wsq_%U.dmp logfile=expdp_db_jt_wsq_$current_time.log cluster=n parallel=2
# #
# 2.Recover Script
# #
# cd / expdata/dmp_bak
# tar-xzvf expdp_db_jt_wsq_$current_time.tar.gz
# impdp username jtbrush wsqUniverse wsqposet 2016subscription! Directory=dmp_bak_dir dumpfile=expdp_db_jt_wsq_%U.dmp logfile=impdp_db_jt_wsq.log parallel=2
# #
# 3.Comress the Backup
# #
Cd / expdata/dmp_bak/
Tar-zcvf expdp_db_jt_wsq_$current_time.tar.gz expdp_db_jt_wsq_*.dmp-- remove-files
Find. /-mtime + 20-name "expdp_db_jt_wsq*"-exec rm-rf {}\
-script 2 exp/imp--
# Backup for oradb (16.7, 16.12) and SOHUDB (208)
#
Echo =
Echo Begin Backup Time: `date`
Echo =
Echo
Source / .bash_profile
Export DATE= `date +'% Y% m% d``
Export NLS_LANG='SIMPLIFIED CHINESE_CHINA.AL32UTF8'
# _ 1.Backup for oradb
Cd / home/oracle/backup/oradb
Exp bj_dx_immcc/bj_dx_immcc_123@ORADB recordlength=65535 direct=y file=exp_bj_dx_immcc_$DATE.dmp log=exp_bj_dx_immcc_$DATE.log
Exp bj_dx_immcc_report/bj_dx_immcc_report_123@ORADB recordlength=65535 direct=y file=exp_bj_dx_immcc_report_$DATE.dmp log=exp_bj_dx_immcc_report_$DATE.log
Exp bj_dx_yyjr/bj_dx_yyjr_123@ORADB recordlength=65535 direct=y file=exp_bj_dx_yyjr_$DATE.dmp log=exp_bj_dx_yyjr_$DATE.log
# _ 2.Backup for SOHODB
Cd / home/oracle/backup/SOHODB
Exp bj_soho_data/bj_soho_data_123@SOHUDB recordlength=65535 direct=y file=exp_bj_soho_data_$DATE.dmp log=exp_bj_soho_data_$DATE.log
# _ 3.Remove Backup 3 Days ago
Find / home/oracle/backup/oradb/-mtime + 3-exec rm-rf {}\
Find / home/oracle/backup/SOHODB/-mtime + 3-exec rm-rf {}\
# _ 4.Recover Script
# imp username/passwd@TNS FROMUSER=** TOUSER=** FILE=** LOG=** BUFFER=20480000
Echo
Echo =
Echo End Backup Time: `date`
Echo =
=
Rem home directory
Set backup_home=D:\ database\ dump
Set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
Set current_date0=%date:~0,4%%date:~5,2%%date:~8,2%
Mkdir% backup_home%\% current_date0%
Rem cleans up backups and logs from two days ago
Forfiles / p "% backup_home%" / s / m 20* / d-2 / c "cmd / c rd / s / Q @ path"
Forfiles / p "% backup_home%\ log" / s / m * .log / d-7 / c "cmd / c del @ path"
/ *
Set YE=%date:~0,4%
Set MO=%date:~5,2%
Set DA=%date:~8,2%
Set DG=2
Set/a vY1=%YE% 400
Set/a vY2=%YE% 4
Set/a vY3=%YE% 100
If vY1%==0 (set var=true) else (if% vY2%==0 (if% vY3%==0 (set var=false) else (set var=true)) else (set var=false))
Set LY=%YE%
Set LM=%MO%
If MO:~0,1%==0 (set MO=%MO:~1,1%)
If DA:~0,1%==0 (set DA=%DA:~1,1%)
If DA% GTR DG% (set/a LD=%DA%-%DG%) else (
If% MO%==1 (set/a LY=%YE%-1) & (set/a LM=12) & (set/a LD=31+%DA%-%DG%) else (
Set/a LM=%MO%-1
If MO%==3 (if var%==false (set/a LD=28+%DA%-%DG%) else (set/a LD=29+%DA%-%DG%))
For% an in (2 4 6 8 9 11) do (if "% MO%" = = "% a" (set/a LD=31+%DA%-%DG%))
For% b in (5 7 10 12) do (if "% MO%" = = "% b" (set/a LD=30+%DA%-%DG%)
If LM% LSS 10 set LM=0%LM:~-1%
If LD% LSS 10 set LD=0%LD:~-3%
Set current_date1=%LY%%LM%%LD%
Rd / s / Q% backup_home%\% current_date1%
, /
Rem backs up the current database
Call exp userid='system/Oracle114#@hbbst' log=%backup_home%\ log\ backup_db_hbbst_%current_date0%.log parfile=%backup_home%\ backup_db_hbbst.par
Mv / y% backup_home%\ * .dmp% backup_home%\% current_date0%\
=
Owner=bdp
Recordlength=32768
Buffer=20000000
Statistics=none
Compress=n
Filesize=10g
File= (
D:\ database\ dump\ backup_db_hbbst_001.dmp
D:\ database\ dump\ backup_db_hbbst_002.dmp
D:\ database\ dump\ backup_db_hbbst_003.dmp
D:\ database\ dump\ backup_db_hbbst_004.dmp
D:\ database\ dump\ backup_db_hbbst_005.dmp
D:\ database\ dump\ backup_db_hbbst_006.dmp
D:\ database\ dump\ backup_db_hbbst_007.dmp
D:\ database\ dump\ backup_db_hbbst_008.dmp
D:\ database\ dump\ backup_db_hbbst_009.dmp
D:\ database\ dump\ backup_db_hbbst_010.dmp
D:\ database\ dump\ backup_db_hbbst_011.dmp
D:\ database\ dump\ backup_db_hbbst_012.dmp
D:\ database\ dump\ backup_db_hbbst_013.dmp
D:\ database\ dump\ backup_db_hbbst_014.dmp
D:\ database\ dump\ backup_db_hbbst_015.dmp
D:\ database\ dump\ backup_db_hbbst_016.dmp
D:\ database\ dump\ backup_db_hbbst_017.dmp
D:\ database\ dump\ backup_db_hbbst_018.dmp
D:\ database\ dump\ backup_db_hbbst_019.dmp
D:\ database\ dump\ backup_db_hbbst_020.dmp
D:\ database\ dump\ backup_db_hbbst_021.dmp
D:\ database\ dump\ backup_db_hbbst_022.dmp
D:\ database\ dump\ backup_db_hbbst_023.dmp
D:\ database\ dump\ backup_db_hbbst_024.dmp
D:\ database\ dump\ backup_db_hbbst_025.dmp
D:\ database\ dump\ backup_db_hbbst_026.dmp
D:\ database\ dump\ backup_db_hbbst_027.dmp
D:\ database\ dump\ backup_db_hbbst_028.dmp
D:\ database\ dump\ backup_db_hbbst_029.dmp
D:\ database\ dump\ backup_db_hbbst_030.dmp
D:\ database\ dump\ backup_db_hbbst_031.dmp
D:\ database\ dump\ backup_db_hbbst_032.dmp
D:\ database\ dump\ backup_db_hbbst_033.dmp
D:\ database\ dump\ backup_db_hbbst_034.dmp
D:\ database\ dump\ backup_db_hbbst_035.dmp
D:\ database\ dump\ backup_db_hbbst_036.dmp
D:\ database\ dump\ backup_db_hbbst_037.dmp
D:\ database\ dump\ backup_db_hbbst_038.dmp
D:\ database\ dump\ backup_db_hbbst_039.dmp
D:\ database\ dump\ backup_db_hbbst_040.dmp
D:\ database\ dump\ backup_db_hbbst_041.dmp
D:\ database\ dump\ backup_db_hbbst_042.dmp
D:\ database\ dump\ backup_db_hbbst_043.dmp
D:\ database\ dump\ backup_db_hbbst_044.dmp
D:\ database\ dump\ backup_db_hbbst_045.dmp
D:\ database\ dump\ backup_db_hbbst_046.dmp
D:\ database\ dump\ backup_db_hbbst_047.dmp
D:\ database\ dump\ backup_db_hbbst_048.dmp
D:\ database\ dump\ backup_db_hbbst_049.dmp
D:\ database\ dump\ backup_db_hbbst_050.dmp
D:\ database\ dump\ backup_db_hbbst_051.dmp
D:\ database\ dump\ backup_db_hbbst_052.dmp
D:\ database\ dump\ backup_db_hbbst_053.dmp
D:\ database\ dump\ backup_db_hbbst_054.dmp
D:\ database\ dump\ backup_db_hbbst_055.dmp
D:\ database\ dump\ backup_db_hbbst_056.dmp
D:\ database\ dump\ backup_db_hbbst_057.dmp
D:\ database\ dump\ backup_db_hbbst_058.dmp
D:\ database\ dump\ backup_db_hbbst_059.dmp
D:\ database\ dump\ backup_db_hbbst_060.dmp
D:\ database\ dump\ backup_db_hbbst_061.dmp
D:\ database\ dump\ backup_db_hbbst_062.dmp
D:\ database\ dump\ backup_db_hbbst_063.dmp
D:\ database\ dump\ backup_db_hbbst_064.dmp
D:\ database\ dump\ backup_db_hbbst_065.dmp
D:\ database\ dump\ backup_db_hbbst_066.dmp
D:\ database\ dump\ backup_db_hbbst_067.dmp
D:\ database\ dump\ backup_db_hbbst_068.dmp
D:\ database\ dump\ backup_db_hbbst_069.dmp
D:\ database\ dump\ backup_db_hbbst_070.dmp
D:\ database\ dump\ backup_db_hbbst_071.dmp
D:\ database\ dump\ backup_db_hbbst_072.dmp
D:\ database\ dump\ backup_db_hbbst_073.dmp
D:\ database\ dump\ backup_db_hbbst_074.dmp
D:\ database\ dump\ backup_db_hbbst_075.dmp
D:\ database\ dump\ backup_db_hbbst_076.dmp
D:\ database\ dump\ backup_db_hbbst_077.dmp
D:\ database\ dump\ backup_db_hbbst_078.dmp
D:\ database\ dump\ backup_db_hbbst_079.dmp
D:\ database\ dump\ backup_db_hbbst_080.dmp
D:\ database\ dump\ backup_db_hbbst_081.dmp
D:\ database\ dump\ backup_db_hbbst_082.dmp
D:\ database\ dump\ backup_db_hbbst_083.dmp
D:\ database\ dump\ backup_db_hbbst_084.dmp
D:\ database\ dump\ backup_db_hbbst_085.dmp
D:\ database\ dump\ backup_db_hbbst_086.dmp
D:\ database\ dump\ backup_db_hbbst_087.dmp
D:\ database\ dump\ backup_db_hbbst_088.dmp
D:\ database\ dump\ backup_db_hbbst_089.dmp
D:\ database\ dump\ backup_db_hbbst_090.dmp
D:\ database\ dump\ backup_db_hbbst_091.dmp
D:\ database\ dump\ backup_db_hbbst_092.dmp
D:\ database\ dump\ backup_db_hbbst_093.dmp
D:\ database\ dump\ backup_db_hbbst_094.dmp
D:\ database\ dump\ backup_db_hbbst_095.dmp
D:\ database\ dump\ backup_db_hbbst_096.dmp
D:\ database\ dump\ backup_db_hbbst_097.dmp
D:\ database\ dump\ backup_db_hbbst_098.dmp
D:\ database\ dump\ backup_db_hbbst_099.dmp
D:\ database\ dump\ backup_db_hbbst_100.dmp
)
= =
Backup_db_zxin.sh
ORACLE_BASE=/oracle/app/oracle;export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db;export ORACLE_HOME
ORACLE_SID=zxin;export ORACLE_SID
Export NLS_LANG=American_America.ZHS16GBK
Export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
Export AIXTHREAD_SCOPE=S
Export LANG=C
TEMP=/tmp; export TEMP
TMPDIR=/tmp; export TMPDIR
Umask 022
PATH=$PATH:$ORACLE_HOME/bin:/usr/bin:/etc:/usr/lbin:/usr/bin/X11:/usr/local/bin
Export PATH
LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH; export LIBRARY_PATH
Current_time= `date'+% Y% m% d``
Dumpfile='expdp_db_zxin_'$current_time'_%U.dmp'
Logfile='expdp_db_zxin_'$current_time'.log'
Find / oradata1/data_backup/zxin-name "expdp_db_zxin*.dmp"-type f-mtime + 1-exec rm-f {}\
Find / oradata1/data_backup/zxin-name "expdp_db_zxin*.log"-type f-mtime + 1-exec rm-f {}\
Expdp userid=system/*** full=y directory=zxin_expdp_dir filesize=10G dumpfile=$dumpfile logfile=$logfile content=all
Ftp_to_p550.sh
#! / bin/bash
Current_time= `date'+% Y% m% d``
Ftp-ivn
