oracle腳本怎么備份 oracle備份命令
Oracle數(shù)據(jù)庫(kù)RMAN的自動(dòng)備份腳本簡(jiǎn)介
Oracle數(shù)據(jù)庫(kù)RMAN的自動(dòng)備份腳本簡(jiǎn)介
成都創(chuàng)新互聯(lián)主打移動(dòng)網(wǎng)站、網(wǎng)站設(shè)計(jì)制作、成都做網(wǎng)站、網(wǎng)站改版、網(wǎng)絡(luò)推廣、網(wǎng)站維護(hù)、國(guó)際域名空間、等互聯(lián)網(wǎng)信息服務(wù)，為各行業(yè)提供服務(wù)。在技術(shù)實(shí)力的保障下，我們?yōu)榭蛻舫兄Z穩(wěn)定，放心的服務(wù)，根據(jù)網(wǎng)站的內(nèi)容與功能再?zèng)Q定采用什么樣的設(shè)計(jì)。最后，要實(shí)現(xiàn)符合網(wǎng)站需求的內(nèi)容、功能與設(shè)計(jì)，我們還會(huì)規(guī)劃穩(wěn)定安全的技術(shù)方案做保障。
各位同學(xué)知道Oracle數(shù)據(jù)庫(kù)RMAN如何自動(dòng)備份腳本嘛?下面我為大家整理了關(guān)于Oracle數(shù)據(jù)庫(kù)RMAN的自動(dòng)備份腳本文章，希望能為你提供幫助：
1、數(shù)據(jù)庫(kù)設(shè)置為歸檔方式
2、數(shù)據(jù)庫(kù)的備份腳本
db_full_backup.sh ：數(shù)據(jù)庫(kù)全備腳本
db_l0_backup.sh ：數(shù)據(jù)庫(kù)0級(jí)備份腳本
db_l1_backup.sh ：數(shù)據(jù)庫(kù)1級(jí)備份腳本
：數(shù)據(jù)FTP上傳腳本
ftp_del.sh ：數(shù)據(jù)FTP清理腳本
rman_bak.sh ：數(shù)據(jù)備份主程序
3、備份原理
每周1、3、6進(jìn)行0級(jí)備份
每周日、2、4、5進(jìn)行1級(jí)備份
備份文件上傳到FTP服務(wù)器
FTP服務(wù)器每周清理一次，但是清理后將周六和周日的備份進(jìn)行保留(6.bak和0.bak)
所有工作防暑crontab中自動(dòng)執(zhí)行備份
4、備份目錄含義
arc ：數(shù)據(jù)庫(kù)歸檔目錄
rmanbak ：數(shù)據(jù)庫(kù)備份文件的保存目錄
rmanscripts ：數(shù)據(jù)庫(kù)腳本存放路徑
5、FTP目錄
ftp上必須手動(dòng)建立目錄
L0：
---1
---3
---6
---6.bak
L1：
---2
---4
---5
---0
---0.bak
rman_bak.sh腳本主程序
#!/bin/bash
#--------------------------------------------
# Oracle auto backup using rman
#
# author:songrh
# week:1,3,6 Level 0 backup
# 2,4,5,0 Level 1 backup
# Copyright by ChenLong Tec
#--------------------------------------------
#
#
export ORACLE_BASE=/u02/oracle
export ORACLE_HOME=/u02/oracle/product/9.2.4
export ORACLE_SID=PROD
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export NLS_LANG=american_america.ZHS16GBK
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NL33=$ORACLE_HOME/ocommon/nls/admin/data
export PATH=/bin:/usr/bin:/usr/sbin:$ORACLE_HOME/bin:$PATH
export PATH=$PATH:/opt/local/bin
#
SH_PATH=/u02/rmanscripts
ARC_PATH=/u02/arch
RMAN_BAK_PATH=/u02/rmanbak
#
#FULL_PATH=$RMAN_BAK_PATH/full
L0_PATH=$RMAN_BAK_PATH/L0
L1_PATH=$RMAN_BAK_PATH/L1
#
#DAY_TAG=`date "%Y-%m-%d"`
LOG_TAG=`date "%Y-%m-%d"`
#FIRST_DAY=`date %e`
WEEK=`date %w`
#WEEK=1
#
# FTP configure
IP="122.120.150.155"
FTPUSER="ftpbak"
FTPPASS="******"
FTPROOT0="L0"
FTPROOT1="L1"
#
DISK_USE=`df -k |sed -n '/u02/'p | awk '{print $5}' |sed 's/%//'`
####check path function
############
if [[ $DISK_USE -ge 90 ]]; then
rm -rf $L0_PATH/*
rm -rf $L1_PATH/*
fi
if [ "$WEEK" = "6" -o "$WEEK" = "3" -o "$WEEK" = "1" ]; then
if [ ! -d $L0_PATH ]; then
mkdir $L0_PATH
fi
if [ "$WEEK" = "1" ]; then
rm -rf $L0_PATH/*
rm -rf $L1_PATH/*
mkdir $L0_PATH/$WEEK
$SH_PATH/db_l0_backup.sh $L0_PATH/$WEEK
cd $L0_PATH/$WEEK
$SH_PATH/ftp_del.sh $IP $FTPUSER $FTPPASS $FTPROOT0 $WEEK $WEEK_$LOG_TAG.log
else
if [ ! -d $L0_PATH/$WEEK ]; then
mkdir $L0_PATH/$WEEK
$SH_PATH/db_l0_backup.sh $L0_PATH/$WEEK
cd $L0_PATH/$WEEK
$SH_PATH/ $IP $FTPUSER $FTPPASS $FTPROOT0 $WEEK $WEEK_$LOG_TAG.log
else
;
oracle怎么用rman腳本進(jìn)行備份
Oracle數(shù)據(jù)庫(kù)中rman備份腳本非常實(shí)用
查詢字符集
SQL select * from nls_database_parameters;
NLS_CHARACTERSET
AL32UTF8
備份時(shí)字符集很重要，不然會(huì)出亂碼
一、0級(jí)備份（全備）紅色是要修改的，根據(jù)個(gè)人的存放位置。
[oracle@oracle122 script]$ cat db_bak0.rman
run
{
configure retention policy to recovery window of 8 days;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/home/oracle/rmanbak/%F';
allocate channel ch1 device type disk format '/home/oracle/rmanbak/inc0_%d_%s_%p_%u_%T';
backup incremental level 0 tag='level 0' database skip inaccessible filesperset 10 plus archivelog filesperset 20;
release channel ch1;
}
allocate channel for maintenance device type disk;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
delete noprompt archivelog until time 'sysdate-30';
0級(jí)運(yùn)行腳本
[oracle@oracle122 script]$ cat exec_0_level.sh
ORACLE_HOSTNAME=oracle122; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app; export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
export DATE=$(date +%Y_%m_%d)
export NLS_LANG="Simplified Chinese_china".AL32UTF8
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target sys/sys_admin cmdfile /home/oracle/rmanbak/script/db_bak0.rman log /home/oracle/rmanbak/script/log/rman_$DATE.log append
二、1級(jí)備份（增量）
[oracle@oracle122 script]$ cat db_bak1.rman
run
{
configure retention policy to recovery window of 8 days;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/home/oracle/rmanbak/%F';
allocate channel ch1 device type disk format '/home/oracle/rmanbak/inc1_%d_%s_%p_%u_%T';
backup incremental level 1 tag='level 1' database skip inaccessible filesperset 10 plus archivelog filesperset 20;
release channel ch1;
}
allocate channel for maintenance device type disk;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
delete noprompt archivelog until time 'sysdate-30';
1級(jí)運(yùn)行腳本
[oracle@oracle122 script]$ cat exec_1_level.sh
ORACLE_HOSTNAME=oracle122; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app; export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
export DATE=$(date +%Y_%m_%d)
export NLS_LANG="Simplified Chinese_china".AL32UTF8
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target sys/sys_admin cmdfile /home/oracle/rmanbak/script/db_bak1.rman log /home/oracle/rmanbak/script/log/rman_$DATE.log append
三、2級(jí)備份（從0級(jí)追加到現(xiàn)在的備份）
[oracle@oracle122 script]$ cat db_bak2.rman
run
{
configure retention policy to recovery window of 8 days;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/home/oracle/rmanbak/%F';
allocate channel ch1 device type disk format '/home/oracle/rmanbak/inc2_%d_%s_%p_%u_%T';
backup incremental level 2 tag='level 2' database skip inaccessible filesperset 10 plus archivelog filesperset 20 delete all input;
release channel ch1;
}
allocate channel for maintenance device type disk;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
2級(jí)運(yùn)行腳本
[oracle@oracle122 script]$ cat exec_2_level.sh
ORACLE_HOSTNAME=oracle122; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app; export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
export DATE=$(date +%Y_%m_%d)
export NLS_LANG="Simplified Chinese_china".AL32UTF8
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target sys/sys_admin cmdfile /home/oracle/rmanbak/script/db_bak2.rman log /home/oracle/rmanbak/script/log/rman_$DATE.log append
定時(shí)備份星期天為0級(jí)全備，星期三為2級(jí)備份，星期一，星期二，星期四，星期五，星期六為1級(jí)增量備份晚上11點(diǎn)開始備份
[oracle@oracle122 script]$ crontab -l
* 23 * * 0 /home/oracle/rmanbak/script/exec_0_level.sh
* 23 * * 1 /home/oracle/rmanbak/script/exec_1_level.sh
* 23 * * 2 /home/oracle/rmanbak/script/exec_1_level.sh
* 23 * * 3 /home/oracle/rmanbak/script/exec_2_level.sh
* 23 * * 4 /home/oracle/rmanbak/script/exec_1_level.sh
* 23 * * 5 /home/oracle/rmanbak/script/exec_1_level.sh
* 23 * * 6 /home/oracle/rmanbak/script/exec_1_level.sh
oracle 備份與恢復(fù)、完全備份腳本
exp system/oracle@orcl buffer=1024 file=/home/oracle/backup/orcl.dmp full=y
exp test/test@orcl file=/home/oracle/backup/test.dmp owner=test
exp test/test@orcl file=/home/oracle/backup/student.dmp tables=(student,teacher)
exp 用戶名/密碼@遠(yuǎn)程的IP:端口/實(shí)例 file=存放的位置:\文件名稱.dmp full=y
log=xx
imp demo/demo@orcl file=d:\back.dmp full=y ignore=y log=D:\implog.txt
imp test/test@orcl file=/home/oracle/backup/test.dmp
imp demo/demo@orcl file=d:\backup2.dmp tables=(teachers,students)
imp 用戶名/密碼@遠(yuǎn)程的IP:端口/實(shí)例 file=存放的位置\文件名稱.dmp full=y
vi /home/oracle/fullbackup.sh
sysname='centos7'
syspath=/home/oracle/backup
v_date=$(date '+%Y%m%d%H%M%S')
logfile= {v_date}.log
echo backup_time {logfile}
echo "backup jcd" {logfile}
date '+%Y-%m-%d %H:%M:%S' syspath/orcl${v_date}.dmp
exp system/oracle@orcl file= {logfile}
echo "end_time" {logfile}
gzip ${filename}
0 2 * * * sh /home/oracle/fullbackup.sh
本文題目：oracle腳本怎么備份 oracle備份命令
分享地址：http://chinadenli.net/article8/hjijop.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供全網(wǎng)營(yíng)銷推廣、品牌網(wǎng)站建設(shè)、微信公眾號(hào)、品牌網(wǎng)站制作、電子商務(wù)、定制網(wǎng)站
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)
移動(dòng)網(wǎng)站建設(shè)知識(shí)
- 做移動(dòng)網(wǎng)站建設(shè)應(yīng)注意哪幾點(diǎn)？ 2021-10-03
- 移動(dòng)網(wǎng)站建設(shè)應(yīng)特別注意哪些事項(xiàng) 2022-11-16
- 移動(dòng)網(wǎng)站建設(shè)排版應(yīng)注意哪些問題？ 2016-11-07
- 成都移動(dòng)網(wǎng)站建設(shè)注意事項(xiàng)有哪些? 2020-08-18
- 移動(dòng)網(wǎng)站建設(shè)要考慮哪些要素 2016-10-25
- 智能手機(jī)與移動(dòng)網(wǎng)站建設(shè)的關(guān)系 2023-02-20
- 網(wǎng)站建設(shè)移動(dòng)網(wǎng)站建設(shè)大盤點(diǎn) 2022-06-14
- 移動(dòng)網(wǎng)站建設(shè)需要注意什么？ 2022-10-20
- 移動(dòng)網(wǎng)站建設(shè)做好這幾點(diǎn)訪客會(huì)更喜歡！ 2021-08-15
- 移動(dòng)網(wǎng)站建設(shè)時(shí)需要注意什么？ 2016-08-07
- 移動(dòng)網(wǎng)站建設(shè)：從瀏覽者的角度提出幾點(diǎn)優(yōu)化建議 2021-07-26
- 移動(dòng)網(wǎng)站建設(shè)預(yù)算已成為有效方式 2016-08-21