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