恢復控制檔案後,沒有最後一個歸檔日誌的備份,也沒新增歸檔日誌資訊,怎麼恢復?
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
控制檔案備份名稱/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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 沒備份,歸檔日誌存在,丟失資料檔案的恢復
- 冷備份+歸檔日誌的恢復
- 【備份恢復】恢復 丟失已歸檔重做日誌檔案
- Oracle使用備份檔案集恢復歸檔日誌Oracle
- 恢復歸檔日誌檔案的常用方法
- 恢復案例:無歸檔,丟失全部控制檔案、日誌檔案恢復案例
- 備份與恢復--從備份的歸檔日誌中恢復資料
- DG歸檔日誌缺失恢復
- 歸檔模式,恢復沒有備份的資料檔案模式
- RMAN備份與恢復(新舊控制檔案及歸檔日誌)測試
- RMAN備份及恢復歸檔日誌的語法
- 非歸檔丟失日誌檔案的恢復
- 老虎是如何從備份集中恢復歸檔日誌
- RMAN備份與恢復(新舊控制檔案及歸檔日誌)測試(敘)
- 不完全恢復(資料檔案備份--新建表空間--控制檔案備份--日誌歸檔檔案)
- 用restore archivelog從備份集中恢復歸檔日誌RESTHive
- oracle歸檔日誌丟失後的資料庫恢復Oracle資料庫
- 兩個日誌組未能歸檔之後恢復資料庫資料庫
- 備份歸檔日誌檔案
- 歸檔模式有備份丟失控制檔案和資料檔案後恢復模式
- 在歸檔模式下丟失日誌檔案的恢復模式
- RMAN備份恢復之歸檔日誌對BLOCKRECOVER的影響BloC
- oracle dg 歸檔日誌恢復情況Oracle
- 無歸檔日誌恢復rman資料
- Oracle控制檔案在缺失歸檔日誌的情況下的恢復Oracle
- 跳過歸檔日誌的非常規恢復(一)
- 對歸檔模式下CLEAR 未歸檔日誌後恢復資料庫的一點看法模式資料庫
- 使用logmnr,在RMAN備份檔案中恢復備份的歸檔日誌檔案進行分析
- 歸檔模式有備份丟失資料檔案後恢復模式
- 【備份恢復】恢復inactive狀態的日誌檔案
- 從備份集恢復歸檔日誌的測試與說明
- 備份歸檔日誌
- 11.2.0.3.2 RMAN無法恢復歸檔日誌
- Oracle RMAN 不完全恢復(只有資料檔案備份,丟失歸檔日誌備份)Oracle
- 控制檔案/歸檔日誌
- RMAN備份資料檔案+控制檔案+歸檔日誌
- 丟失已歸檔日誌檔案下恢復資料庫資料庫
- REDO日誌損壞,非歸檔模式資料檔案恢復模式