Oracle RMAN備份還原方案

1、修改rman配置，能夠恢複到7天内的任一時間點

su - oracle

rman target /

configure retention policy to recovery window of 7 days;

show all;

2、建立備份資料庫和歸檔日志rman腳本online_database_archivelog.rman

#建立備份目錄

mkdir -pv /backup/oraclebk/database

mkdir -pv /backup/oraclebk/archivelog

chown -R oracle.oinstall

mkdir scripts

cd scripts

vim online_database_archivelog.rman

#rman腳本内容

run {

allocate channel t1 type disk;

allocate channel t2 type disk;

backup as compressed backupset database format '/backup/oraclebk/database/database.%T.%U.rman';

backup as compressed backupset archivelog all delete all input format '/backup/oraclebk/archivelog/archivelog.%T.%U.rman';

}

delete noprompt obsolete;

#delete noprompt obsolete; 删除無效或過期的備份集

3、建立備份shell腳本

vim rman_backup.sh

#shell腳本内容

#!/bin/bash

source ~/.bash_profile

rman target / @/home/oracle/scripts/online_database_archivelog.rman > /home/oracle/scripts/backup.log

4、添加定時任務每天04:00備份

crontab -e

00 04 * sh /home/oracle/scripts/rman_backup.sh >/dev/null 2>&1

5、執行基于時間點不完全恢複（要求歸檔日志和重做日志完整，RAC環境需要将另一執行個體關閉）

shutdown immediate;

startup mount;

set until time = "to_date('02-02-18 16:20:00','dd-mm-yy hh24:mi:ss')";

restore database;

recover database;

alter database open resetlogs;

     本文轉自1321385590 51CTO部落格，原文連結：http://blog.51cto.com/linux10000/2068231，如需轉載請自行聯系原作者