oracle怎么備份腳本,數(shù)據(jù)庫備份腳本oracle
oracle rman備份腳本怎么寫
在ORACLE數(shù)據(jù)庫中，RMAN備份的腳本非常多，下面介紹一例shell腳本如何通過RMAN備份，以及FTP上傳RMAN備份文件以及歸檔日志文件的腳本。
創(chuàng)新互聯(lián)公司專注于鐵力網(wǎng)站建設(shè)服務(wù)及定制，我們擁有豐富的企業(yè)做網(wǎng)站經(jīng)驗。 熱誠為您提供鐵力營銷型網(wǎng)站建設(shè)，鐵力網(wǎng)站制作、鐵力網(wǎng)頁設(shè)計、鐵力網(wǎng)站官網(wǎng)定制、微信小程序開發(fā)服務(wù)，打造鐵力網(wǎng)絡(luò)公司原創(chuàng)品牌,更為您提供鐵力網(wǎng)站排名全網(wǎng)營銷落地服務(wù)。
fullback.sh 里面調(diào)用RMAN命令做數(shù)據(jù)庫備份，它使用的cmdfile為/home/oracle/backup/bin/fullback.rcv，同時在/home/oracle/backup/logs目錄下生成日志文件。
1: [oracle@DB-Server bin]$ more fullback.sh
2:
3: #!/bin/bash
4:
5: export ORACLE_BASE=/u01/app/oracle
6:
7: export ORACLE_SID=gps
8:
9: ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
10:
11: TMP=/tmp; export TMP
12:
13: TMPDIR=$TMP; export TMPDIR
14:
15: PATH=/usr/sbin:$PATH; export PATH
16:
17: PATH=$ORACLE_HOME/bin:$PATH; export PATH
18:
19: LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
20:
21: CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
22:
23: export CLASSPATH
24:
25: TODAY=`date +%Y_%m_%d`
26:
27: rman nocatalog target / cmdfile /home/oracle/backup/bin/fullback.rcv log /home/oracle/backup/logs/fullbackup_$TODAY.log
28:
29: /home/oracle/backup/bin/ftpbackup.sh
30:
fullback.rcv文件非常簡單， 如下所示：
1: [oracle@DB-Server bin]$ more /home/oracle/backup/bin/fullback.rcv
2:
3: run{
4:
5: allocate channel c4 type disk;
6:
7: backup as compressed backupset
8:
9: skip inaccessible
10:
11: tag fullbackupwitharchivelog
12:
13: (database);
14:
15: backup current controlfile;
16:
17: backup spfile;
18:
19: sql "alter system archive log current";
20:
21: delete noprompt obsolete;
22:
23: release channel c4;
24:
25: }
26:
RMAN生成的備份文件，需要通過FTP上傳到FTP服務(wù)器，一則數(shù)據(jù)庫服務(wù)器沒有這么多空間存儲多天的備份，二則是出于容災(zāi)、數(shù)據(jù)安全需要。
下面腳本中FTP服務(wù)器，用戶名密碼均使用xxx替代，在實際環(huán)境中，使用具體的信息替代即可。
1: [oracle@DB-Server bin]$ more ftpbackup.sh
2:
3: #!/bin/sh、
4:
5: rm -f /home/oracle/.netrc
6:
7: date_yesterday=`date -d'yesterday' +%Y_%m_%d`
8:
9: date_today=`date +%Y_%m_%d`
10:
11: echo "default login xxxx password xxxxxx" /home/oracle/.netrc
12:
13: echo "macdef init" /home/oracle/.netrc
14:
15: echo "binary" /home/oracle/.netrc
16:
17: echo "cd archivelog" /home/oracle/.netrc
18:
19: echo "mkdir $date_yesterday" /home/oracle/.netrc
20:
21: echo "cd $date_yesterday" /home/oracle/.netrc
22:
23: echo "lcd /u04/flash_recovery_area/gps/archivelog/$date_yesterday" /home/oracle/.netrc
24:
25: echo "mput *" /home/oracle/.netrc
26:
27: echo "cd .." /home/oracle/.netrc
28:
29: echo "mkdir $date_today" /home/oracle/.netrc
30:
31: echo "cd $date_today" /home/oracle/.netrc
32:
33: echo "lcd /u04/flash_recovery_area/gps/archivelog/$date_today" /home/oracle/.netrc
34:
35: echo "mput * "/home/oracle/.netrc
36:
37: echo "cd .." /home/oracle/.netrc
38:
39: echo "cd ../backupset" /home/oracle/.netrc
40:
41: echo "mkdir $date_today" /home/oracle/.netrc
42:
43: echo "cd $date_today" /home/oracle/.netrc
44:
45: echo "lcd /u04/flash_recovery_area/gps/backupset/$date_today" /home/oracle/.netrc
46:
47: echo "mput *" /home/oracle/.netrc
48:
49: echo "cd .." /home/oracle/.netrc
50:
51: echo "cd ../autobackup" /home/oracle/.netrc
52:
53: echo "mkdir $date_today" /home/oracle/.netrc
54:
55: echo "cd $date_today" /home/oracle/.netrc
56:
57: echo "lcd /u04/flash_recovery_area/gps/autobackup/$date_today" /home/oracle/.netrc
58:
59: echo "mput *" /home/oracle/.netrc
60:
61: echo "quit" /home/oracle/.netrc
62:
63: echo "" /home/oracle/.netrc
64:
65: chmod 600 /home/oracle/.netrc
66:
67: ftp -i -v xxx.xxx.xxx.xxx 8021 /home/oracle/backup/logs/ftp$date_today.log 21
68:
另外，關(guān)于歸檔日志也需要每隔2小時上傳一次到FTP服務(wù)器，2小時上傳一次歸檔日志的shell腳本如下所示：
1: [oracle@DB-Server bin]$ more ftp2hours.sh
2:
3: #!/bin/sh
4:
5: rm -f /home/oracle/.netrc
6:
7: date_yesterday=`date -d'yesterday' +%Y_%m_%d`
8:
9: date_today=`date +%Y_%m_%d`
10:
11: echo "default login xxxx password xxxx" /home/oracle/.netrc
12:
13: echo "macdef init" /home/oracle/.netrc
14:
15: echo "binary" /home/oracle/.netrc
16:
17: echo "cd archivelog" /home/oracle/.netrc
18:
19: echo "mkdir $date_today" /home/oracle/.netrc
20:
21: echo "cd $date_today" /home/oracle/.netrc
22:
23: echo "lcd /u04/flash_recovery_area/gps/archivelog/$date_today" /home/oracle/.netrc
24:
25: echo "mput * "/home/oracle/.netrc
26:
27: echo "quit" /home/oracle/.netrc
28:
29: echo "" /home/oracle/.netrc
30:
31: chmod 600 /home/oracle/.netrc
32:
33: ftp -i -v xxx.xxx.xxx.xxx 8021 /home/oracle/backup/logs/ftp2hours.$date_today.log 21
34:
最后需要將RMAN備份生成的日志文件，以及FTP上傳備份文件以及歸檔日志的記錄通過郵件形式發(fā)送給DBA或系統(tǒng)管理員，
1: [oracle@DB-Server bin]$ more chkbackandmail.sh
2: #!/bin/bash
3: rm -f /home/oracle/backup/bin/sendmail.pl
4: date_today=`date +%Y_%m_%d`
5: subject="Oracle Backup Alert Service on $date_today"
6: content="Dear colleagues,
7:
8: Attached please find the logs of xxx(xxx.xxx.xxx.xxx) oracle database backup and transfer to FTP Server(xxx.xxx.xxx.xxx), please
9: review the file and check whether the backup succeeded or not,and double check all backups have been dumped to tape, many tha
10: nks
11:
12:
13:
14:
15: Best regards
16: Oracle Alert Services
17:
18: "
19: file="/home/oracle/backup/logs/fullbackup_$date_today.log,/home/oracle/backup/logs/ftp$date_today.log"
20: echo "#!/usr/bin/perl" /home/oracle/backup/bin/sendmail.pl
21: echo "use Mail::Sender;" /home/oracle/backup/bin/sendmail.pl
22: echo "\$sender = new Mail::Sender {smtp = 'xxx.xxx.xxx.xxx', from = 'xxxx@xxx.com'}; " /home/oracle/backup/bin/sendmai
23: l.pl
24: echo "\$sender-MailFile({to = 'xxx@esquel.com'," /home/oracle/backup/bin/sendmail.pl
25: echo "cc='xxx@xxx.com,xxx@xxx.com,xxx@xxx.com'," /home/oracle/backup/b
26: in/sendmail.pl
27: echo "subject = '$subject'," /home/oracle/backup/bin/sendmail.pl
28: echo "msg = '$content'," /home/oracle/backup/bin/sendmail.pl
29: echo "file = '$file'});" /home/oracle/backup/bin/sendmail.pl
30: perl /home/oracle/backup/bin/sendmail.pl
最后在Crontab 作業(yè)里面配置調(diào)用這些shell腳本。例如如下所示，在1：01分執(zhí)行fullback.sh ，每隔兩個小時（例如0:50、2:50...)執(zhí)行一次ftp2hours.sh, 在每天早上8:40執(zhí)行chkbackandmail.sh 發(fā)送fullback.sh 以及ftp2hour.sh的執(zhí)行日志記錄。
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:端口/實例 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:端口/實例 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怎么用rman腳本進(jìn)行備份
Oracle數(shù)據(jù)庫中rman備份腳本非常實用
查詢字符集
SQL select * from nls_database_parameters;
NLS_CHARACTERSET
AL32UTF8
備份時字符集很重要，不然會出亂碼
一、0級備份（全備）紅色是要修改的，根據(jù)個人的存放位置。
[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級運行腳本
[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級備份（增量）
[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級運行腳本
[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級備份（從0級追加到現(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級運行腳本
[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
定時備份星期天為0級全備，星期三為2級備份，星期一，星期二，星期四，星期五，星期六為1級增量備份晚上11點開始備份
[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數(shù)據(jù)庫備份腳本怎么寫？
沒必要用root權(quán)限執(zhí)行，oracle用戶同樣可以執(zhí)行crontab計劃任務(wù)
1、su - oracle
crontab -e
0 4 * * 0 /home/oracle/exp.sh 21 /home/oracle/script_exp.log;
0～59 表示分
0～23 表示小時
1～31 表示日
1～12 表示月份
0～6 表示星期（其中0表示星期日）
2、cat /home/oracle/exp.sh
. ~/.bash_profile
bakdir=/opt/dbbak
logdir=/home/oracle/dbbak
rq=$(date +%Y%m%d)
exp system/***** owner=jysh file=${bakdir}/jysh_${rq}.dmp log=${logdir}/jysh_${rq}.log;
find ${bakdir} -type f -mtime +30 -exec rm -rf {} \;
oracle中怎么設(shè)置數(shù)據(jù)庫自動備份？
Oracle自動備份的三種方法：\x0d\x0aOracle自動備份數(shù)據(jù)庫不外乎以下三種方式：\x0d\x0aWINDOWS下的任務(wù)計劃(At命令)\x0d\x0aUNIX下的Crontab \x0d\x0a第三方工具如Viritas\x0d\x0a在以上三種方式中Viritas屬于第三方工具，很多人可能都沒有接觸，主要說一下windows的任務(wù)計劃與unix的cron\x0d\x0a1、生成腳本文件，如backup.rcv 假定文件內(nèi)容如下：\x0d\x0a$cat backup.rcv connect target sys/password rcvcat rman/rman@localname; run{ allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; backup fileaperset 3 format ‘/u01/oradata/backup/arch%u_%s_%p’ archivelog all delete input; release channel c1; release channel c2; release channel c3; }\x0d\x0a\x0d\x0a2、生成執(zhí)行文件在windows上生成backup_archive.bat，內(nèi)容包括rman cmdfile = backup.rcv 在unix下生成 backup_archive.sh，內(nèi)容包括oracle/ramn/rman cmdfile = backup.rcv\x0d\x0a3、加入調(diào)度在windows中用任務(wù)計劃向?qū)Ъ纯桑蚴褂胊t命令。在unix中，在目標(biāo)機器上編寫一個文件，用以啟動Oracle自動備份進(jìn)程。假定文件名為ORACLE，文件將放在/var/spool/cron/crontabs目錄下\x0d\x0a$cat oracle \x0d\x0a0 23 * * 0 backup_archive.sh \x0d\x0a#表示星期天23點對數(shù)據(jù)庫備份 \x0d\x0a0 12,18 * * * backup_archive.sh \x0d\x0a #表示每天12點，18點備份 \x0d\x0aCrontab文件的每一行由六個域(minutes,hours,day of month,month,day of week,command)組成，域之間用空格或Tab分隔開來。
新聞名稱：oracle怎么備份腳本,數(shù)據(jù)庫備份腳本oracle
本文鏈接：http://chinadenli.net/article38/dsgcgsp.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供品牌網(wǎng)站設(shè)計、外貿(mào)網(wǎng)站建設(shè)、企業(yè)網(wǎng)站制作、做網(wǎng)站、ChatGPT、定制開發(fā)
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)
- 微信小程序如何實現(xiàn)下拉刷新上滑加載 2021-02-21
- 從0到1，微信小程序開發(fā)的11步 2022-07-08
- 對話微信小程序負(fù)責(zé)人：保持克制，擔(dān)心市場被吹大 2022-02-22
- 淺談實體店鋪開發(fā)微信小程序的重大意義 2016-10-23
- 微信小程序給中小企業(yè)帶來的幫助到底有多大？ 2016-09-14
- 企業(yè)制作微信小程序有什么用 2021-05-13
- 微信小程序?qū)ι碳业乃拇蠛锰?/a> 2022-11-17
- 怎樣開發(fā)微信小程序，找準(zhǔn)方向很重要 2022-05-21
- 分享幾個方便查找微信小程序的方法 2022-08-20
- 微信小程序設(shè)計經(jīng)驗分享 2023-10-08
- 微信小程序開發(fā)真的是未來發(fā)展趨勢和優(yōu)勢嗎？ 2018-01-03
- 教育培訓(xùn)行業(yè)如何開發(fā)微信小程序-大連微信開發(fā) 2022-07-16