oracle控制文件未记录的归档,恢复控制文件后，没有最后一个归档日志的备份，也没新增归档日志信息，怎么恢复？...

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