升級失敗後對資料庫進行恢復 (2)

在上一篇文章中敘述了原因,本篇中將描述恢復的過程:
非常簡單,如下:
RMAN> restore database;
 
Starting restore at 24-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=388 device type=DISK
 
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA/cdcrm02/datafile/system.330.824013365
channel ORA_DISK_1: restoring datafile 00002 to +DATA/cdcrm02/datafile/sysaux.331.824013389
channel ORA_DISK_1: restoring datafile 00003 to +DATA/cdcrm02/datafile/undotbs1.332.824013405
channel ORA_DISK_1: restoring datafile 00004 to +DATA/cdcrm02/datafile/users.334.824013425
channel ORA_DISK_1: restoring datafile 00005 to +DATA/cdcrm02/datafile/dataccrm1.338.824066435
channel ORA_DISK_1: restoring datafile 00006 to +DATA/cdcrm02/datafile/indxccrm1.339.824066607
channel ORA_DISK_1: reading from backup piece /expdump/back/CDCRM02/backupset/2014_02_20/o1_mf_nnndf_TAG20140220T132233_9jc48t6r_.bkp
channel ORA_DISK_1: piece handle=/expdump/back/CDCRM02/backupset/2014_02_20/o1_mf_nnndf_TAG20140220T132233_9jc48t6r_.bkp tag=TAG20140220T132233
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:05:25
Finished restore at 24-FEB-14
 
RMAN> RUN
{
SET UNTIL SEQUENCE 761 THREAD 1;
  RECOVER DATABASE;  # recovers through log 761, 761 號log是不會也不用恢復的.
}    2> 3> 4> 5>
 
executing command: SET until clause
 
Starting recover at 24-FEB-14
using channel ORA_DISK_1
 
starting media recovery
 
archived log for thread 1 with sequence 759 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_20/o1_mf_1_759_9jc4c7kz_.arc
archived log for thread 1 with sequence 760 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_20/o1_mf_1_760_9jcn6xq6_.arc
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_20/o1_mf_1_759_9jc4c7kz_.arc thread=1 sequence=759
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_20/o1_mf_1_760_9jcn6xq6_.arc thread=1 sequence=760
media recovery complete, elapsed time: 00:00:06
Finished recover at 24-FEB-14

RMAN> alter database open;    --進行了不還原恢復,當然直接open,是打不開資料庫的.
 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/24/2014 10:06:26
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
 
RMAN> alter database open resetlogs;    
 
database opened

--至此,資料庫又恢復到升級前的狀態了,也可以正常使用了.
我將針對升級失敗的情況,做一些引數上的修改,再升級一次.