1.將數(shù)據(jù)庫(kù)停機(jī)改為歸檔模式

SQL> archive log list

SQL> shutdown immediate

SQL> startup mount

SQL> alter database archivelog;

SQL> alter database open;

2.將數(shù)據(jù)庫(kù)歸檔指向ASM

SQL>alter system set db_recovery_file_dest_size = 200G;

SQL>alter system set db_recovery_file_dest = '+DATA';

3.將數(shù)據(jù)庫(kù)備份冗余設(shè)置為2，將備份文件設(shè)置為/home下的某個(gè)目錄

RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;?? #設(shè)置自動(dòng)備份控制文件

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT?? '/home/oracle/backup/%U',?? '+DATA';

設(shè)置備份在本地、存儲(chǔ)上各有一份：

RMAN>CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

RMAN>CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

4.制定每周全備份一次，每天備份歸檔或不做任何操作，只在全備份時(shí)刪除冗余外的歸檔和備份。

使用crontab來(lái)調(diào)度腳本實(shí)現(xiàn)定時(shí)備份數(shù)據(jù)庫(kù)，刪除歸檔。

# crontab -l

0 0 * * 6 su - oracle backup.sh? //每周6凌晨0點(diǎn)全備數(shù)據(jù)庫(kù)

#

# su - oracle

$ cat /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/backup.sh

rman target / cmdfile=/home/oracle/backup.rman log=/home/oracle/backup _`date +%Y%m%d%H%M%S`.log

$ cat /home/oracle/backup.rman

backup device type disk database? plus? archivelog delete all input;

allocate channel for maintenance type disk;

delete noprompt obsolete device type disk;

# crontab -l

0 0 * * * su - oracle backuparch.sh? //每天凌晨0點(diǎn)備份歸檔

0 0 * * * su - oracle dellog.sh? //每天凌晨0點(diǎn)處理日志,只保存7天日志

#

# su - oracle

$ cat /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/backuparch.sh

rman target / cmdfile=/home/oracle/backuparch.rman log=/home/oracle/backuparch _`date +%Y%m%d%H%M%S`.log

$ cat /home/oracle/backuparch.rman

backup archivelog all delete input;

$ cat /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/dellog.sh

find /home/oracle/backup*.log –mtime +7 –exec rm {} \;

作者 “個(gè)人記錄”

http://www.dengb.com/oracle/485242.htmlwww.dengb.comtruehttp://www.dengb.com/oracle/485242.htmlTechArticle1.將數(shù)據(jù)庫(kù)停機(jī)改為歸檔模式 SQL archive log list SQL shutdown immediate SQL startup mount SQL alter database archivelog; SQL alter database open; 2.將數(shù)據(jù)庫(kù)歸檔指向...

總結(jié)

以上是生活随笔為你收集整理的oracle backup arch,一个数据库备份的例子的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。