RMAN恢復簡單操作

                 RMAN恢復例項-20120215

概念描述

restore 只是用備份來還原,recover是用archivelog或者online log 舉例說明：假設我時間點A,做了個備份,時間點B資料庫掛了restore database ;// 這個操作利用時間點A做的備份來還原,返回到時間點A recover database ;//這個操作利用archivelog and online log做recover,從時間點A,推進到時間點B restore 是轉儲也是還原被損壞檔案(RMAN經常用)recover 是恢復通過redo log & archive log恢復 restore 還原recover 恢復

1.目標資料庫，用DBCA建立和源庫一樣的DATABASE(注意DB_BLOCK,字符集)

2.先全備源資料庫

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2048 M FORMAT   '/u01/dump_dir/%U'; 

 

configure controlfile autobackup on;

 

change archivelog all crosscheck ;

 

BACKUP DATABASE  INCLUDE CURRENT CONTROLFILE FOR STANDBY PLUS ARCHIVELOG;

3.密碼檔案同步下

4.源庫建立pfile檔案，copy目標庫

Create pfile=’/data/backup/pfile.ora’ from spfile;

5.將備份集copy到目標庫相應位置

List看下需要copy的備份集

   RMAN> list backup;

 

using target database control file instead of recovery catalog

 

List of Backup Sets

===================

 

 

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

1       1.09G      DISK        00:00:17     15-FEB-12     

        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20120215T112951

        Piece Name: /data/backup/01n3ch9f_1_1

 

  List of Archived Logs in backup set 1

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

6.先啟動目標資料庫到nomount下

   SQL> startup nomount;

   將控制檔案恢復到相應的位置

   Restore controlfile from autobackup;

7．再啟動到mount狀態下，恢復資料庫

   SQL> alter database mount;

   RMAN>restore database;

8．恢復整個資料庫，並recover

RMAN>recover database;

   會報錯如下：

RMAN> recover database;

 

Starting recover at 15-FEB-12

using channel ORA_DISK_1

 

starting media recovery

 

channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=587

channel ORA_DISK_1: reading from backup piece /data/backup/0an3cvli_1_12

channel ORA_DISK_1: piece handle=/data/backup/0an3cvli_1_12 tag=TAG20120215T153513

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

archived log file name=/data/sssdb/arch/1_587_759406989.arc thread=1 sequence=587

unable to find archived log

archived log thread=1 sequence=588

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 02/15/2012 16:40:23

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 588 and starting SCN of 24517576

 

可先不用管它。

 

9.最後嘗試開啟目標資料庫
SQL> alter database open resetlogs;

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/25850100/viewspace-716337/，如需轉載，請註明出處，否則將追究法律責任。