恢復控制檔案後，沒有最後一個歸檔日誌的備份，也沒新增歸檔日誌資訊，怎麼恢復？

lusklusklusk發表於2017-09-18
原文網址 : http://blog.itpub.net/30126024/viewspace-2145105/
RMAN> backup database format '/db/backup/data%U' plus archivelog format '/db/backup/arch%U' delete input;
控制檔案備份名稱/db/backup/data2bsepba0_1_1
最後一個歸檔日誌序號為8的備份名稱/db/backup/arch2csepba3_1_1

SQL> alter system archive log current;--9
SQL> alter system archive log current;--10
SQL> alter system archive log current;--11
SQL> alter system archive log current;--12

RMAN> list archivelog all;--有9、10、11、12歸檔日誌

RMAN> list backup;有最後8號歸檔日誌的備份包
SQL> shutdown immediate;




控制檔案沒有最後一個歸檔日誌備份包，怎麼恢復
--透過catalog手工新增
控制檔案中沒有控制檔案備份之後的歸檔日誌，oracle怎麼識別新增的歸檔日誌(沒有9-12號歸檔日誌)
--oracle會自動根據log_archive_format、log_archive_dest_1引數去尋找sequence為9開始的歸檔日誌
SQL> startup nomount;
RMAN> restore controlfile from  '/db/backup/data2bsepba0_1_1';
RMAN> alter database mount;
RMAN> list backup;--沒有8號歸檔日誌的備份包
RMAN> catalog backuppiece '/db/backup/arch2csepba3_1_1';--新增8號歸檔日誌的備份包
RMAN> list backup;--有8號歸檔日誌的備份包
RMAN> restore archivelog sequence 8;
RMAN> list archivelog all;--沒有9-12歸檔日誌
RMAN> recover database;--會自動找到9-12號日誌進行恢復


RMAN> list archivelog all;
List of Archived Log Copies for database with db_unique_name TESTDB
=====================================================================
Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
83      1    8       A 18-SEP-17
        Name: /db/oracle/archivelog/1_8_955034536.dbf


RMAN> recover database ;
Starting recover at 18-SEP-17
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 13 is already on disk as file /db/oracle/oradata/TESTDB/redo01.log
archived log for thread 1 with sequence 14 is already on disk as file /db/oracle/oradata/TESTDB/redo02.log
archived log for thread 1 with sequence 15 is already on disk as file /db/oracle/oradata/TESTDB/redo03.log
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=8
channel ORA_DISK_1: reading from backup piece /db/backup/arch2csepba3_1_1
channel ORA_DISK_1: piece handle=/db/backup/arch2csepba3_1_1 tag=TAG20170918T152907
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/db/oracle/archivelog/1_8_955034536.dbf thread=1 sequence=8
archived log file name=/db/oracle/archivelog/1_9_955034536.dbf thread=1 sequence=9
archived log file name=/db/oracle/archivelog/1_10_955034536.dbf thread=1 sequence=10
archived log file name=/db/oracle/archivelog/1_11_955034536.dbf thread=1 sequence=11
archived log file name=/db/oracle/archivelog/1_12_955034536.dbf thread=1 sequence=12
archived log file name=/db/oracle/oradata/TESTDB/redo01.log thread=1 sequence=13
archived log file name=/db/oracle/oradata/TESTDB/redo02.log thread=1 sequence=14
archived log file name=/db/oracle/oradata/TESTDB/redo03.log thread=1 sequence=15
media recovery complete, elapsed time: 00:00:02
Finished recover at 18-SEP-17

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

相關文章