SQL> select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_ ---------- ------- ------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --- 3 ONLINE +DATA_DISK NO 2 ONLINE +DATA_DISK NO 1 ONLINE +DATA_DISK NO 1 ONLINE +LOG_DISK YES 2 ONLINE +LOG_DISK YES 3 INVALID ONLINE +LOG_DISK YES 6 rows selected.
recover 数据库
在执行restore的节点执行，因为备份文件在该节点上。
RMAN> recover database;
Starting recover at 21-JUN-14
using channel ORA_DISK_1
starting media recovery
unable to find archived log
archived log thread=1 sequence=11
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/21/2014 21:02:01
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 11 and starting SCN of 995895
RMAN> recover database until scn 995895;
Starting recover at 21-JUN-14
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 21-JUN-14
RMAN> restore archivelog all;
Starting restore at 21-JUN-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=5
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=6
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=7
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=8
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=9
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=10
channel ORA_DISK_1: reading from backup piece /dba/app/rmanbak/DOMINIC_arch_0ap9pjij_20140601
channel ORA_DISK_1: piece handle=/dba/app/rmanbak/DOMINIC_arch_0ap9pjij_20140601 tag=TAG20140601T232715
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 21-JUN-14
SQL> startup
ORACLE instance started.
Total System Global Area 1152450560 bytes
Fixed Size 2252584 bytes
Variable Size 855638232 bytes
Database Buffers 285212672 bytes
Redo Buffers 9347072 bytes
Database mounted.
ORA-01589: must use RESETLOGS or