使用RMAN restore archive log

一、  在主庫上使用RMAN備份archivelog .

   vi  /backup/rman_dest/scripts/backup_db_arch.sh

 

   ## 文件內容

source /u/oracle/.bash_profile

##script. start ####
#!/bin/bash
#set env
DATE=`date +%w`
DATE_2=`date +%Y%m%d`
BACKUP_PATH=/backup/rman_dest
LEVEL=$@
#TARGET_SID=pcmdb
#RMAN_SID=pcmdb.pcmdb
BIN=$ORACLE_HOME/bin
# Delete the data backuped last time
rm -rf $BACKUP_PATH/data/$DATE/*

$BIN/rman target / catalog rman/xxxx@rman_catalogdb log $BACKUP_PATH/log/rman_db_arch.$DATE.log <show all;
report schema;
run {
     crosscheck backup;
     crosscheck archivelog all;
     delete noprompt obsolete;
     delete noprompt expired backup;
     configure device type disk parallelism 6;
     backup  ( archivelog all  delete all input
                     filesperset=8
                     format '$BACKUP_PATH/data/$DATE/arch_s%s_p%p_arch.dmp'
                     tag="backup_db_arch");
    }
exit;
EOF

 

二、 將主庫上的備份檔移到備庫對應的目錄

  scp *.dmp 10.197.xx.xxx:/backup/rman_dest/data/2/

 

三、在備庫的控制文件中注冊此備份。

 

  [oracle@hzsz-db-b1 ~]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Wed May 15 10:42:05 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: HUMAN (DBID=864078703, not open)

RMAN> catalog start with '/backup/rman_dest/data/2/';

 

  使用 crosscheck backup 

 

四、重存archivelog (根據應的需要）

RMAN> restore archivelog all;  --重存所有的日志

RMAN> restore archivelog from logseq 1024 until logseq 1059;  --重存1024到1059日志

RMAN> restore archivelog from logseq 1024 ;  --重存從1024開始的所有日志

RMAN> restore archivelog from time 'sysdate-1';  --重存最近一天的日志

RMAN> restore archivelog sequence between  1991 and 2010 ;  --重存從1991到2010的日志

RMAN> restore archivelog until logseq 1024 ;  --重存到1024為止

RMAN> restore archivelog  low logseq 1024 ;  --重存從1024開始的所有日志

RMAN> restore archivelog  high logseq 1024 ;  --重存到1024為止

 

五、將archivelog 重存到不同的目錄（非log_archive_dest指定或是use_recovery_dest)

RMAN> set archivelog destination to '/arch/';

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27348/viewspace-761117/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27348/viewspace-761117/