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

@ 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

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.