11.recover database

RMAN> recover database;

Starting recover at 07-JAN-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=991
channel ORA_DISK_1: reading from backup piece /home/oracle/rmanback/level0arclog_GHSJDB_14631_1_97ps540p.bak
channel ORA_DISK_1: piece handle=/home/oracle/rmanback/level0arclog_GHSJDB_14631_1_97ps540p.bak tag=TAG20150107T190808
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
archived log file name=/home/u01/app/oracle/archivelog/1_991_854121688.dbf thread=1 sequence=991
unable to find archived log
archived log thread=1 sequence=992
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/07/2015 14:47:41
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 992 and starting SCN of 1836854473

RMAN> recover database until scn 1836854473;

Starting recover at 07-JAN-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 07-JAN-15

12 .打开数据库

RMAN> alter database open resetlogs;

database opened

结束了，查看库里面的信息是否正确