ITPub博客

首页 > 数据库 > Oracle > 升级失败后对数据库进行恢复 (1)

升级失败后对数据库进行恢复 (1)

原创 Oracle 作者:xchui702 时间:2014-02-24 10:12:46 0 删除 编辑

对数据库进行升级,由11.2.0.3 升级到11.2.0.4.
由于11.2.0.4是full 安装包,所有要在与原来oracle_home不同的目录里分别安装ASM 和Oracle软件.
安装Asm软件时候选择的Option是升级现有的ASM,所以安装过程从会自动把CRS里的信息注册到新的CRS里.
安装Oracle软件时候,也选择了升级现有的数据库,所以在安装过程中自动调用dbua的程序.

启动有一个数据库升级失败了,想通过升级前的备份,还原到正常状态.因为11.2.0.3的oracle home 还是存在的,还可以正常工作的.
但是还原后数据库还是不能正常启动,是什么原因了? 分析如下:


RMAN> report schema;   
 
Report of database schema for database with db_unique_name CDCRM02
 
List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    750      SYSTEM               ***     +DATA/cdcrm02/datafile/system.330.824013365
2    840      SYSAUX               ***     +DATA/cdcrm02/datafile/sysaux.331.824013389
3    575      UNDOTBS1             ***     +DATA/cdcrm02/datafile/undotbs1.332.824013405
4    5        USERS                ***     +DATA/cdcrm02/datafile/users.334.824013425
5    5000     DATACCRM1            ***     +DATA/cdcrm02/datafile/dataccrm1.338.824066435
6    1000     INDXCCRM1            ***     +DATA/cdcrm02/datafile/indxccrm1.339.824066607
 
List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    199      TEMP                 32767       +DATA/cdcrm02/tempfile/temp.333.824013413
 
RMAN> restore database;
 
Starting restore at 21-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=769 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:03:05
Finished restore at 21-FEB-14
 
--我是2/20下午做的备份, 2/21号上午做的升级,而archive log 里显示的有21号的archive log, 所以说明在升级过程中也产生的archive log.
RMAN> list copy;
 
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
List of Archived Log Copies for database with db_unique_name CDCRM02
=====================================================================
 
Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
1       1    758     A 19-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_20/o1_mf_1_758_9jc48n8o_.arc
 
2       1    759     A 20-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_20/o1_mf_1_759_9jc4c7kz_.arc
 
3       1    760     A 20-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_20/o1_mf_1_760_9jcn6xq6_.arc
 
4       1    761     A 20-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_761_9jfdf2l7_.arc
 
5       1    762     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_762_9jfdyt78_.arc
 
6       1    763     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_763_9jfdz27m_.arc
 
7       1    764     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_764_9jff1p33_.arc
 
8       1    765     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_765_9jff4kmr_.arc
 
9       1    766     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_766_9jff8492_.arc
 
10      1    767     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_767_9jfffb4l_.arc
 
11      1    768     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_768_9jffkp3t_.arc
 
12      1    769     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_769_9jffm50o_.arc
 
13      1    770     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_770_9jffnbmo_.arc
 
14      1    771     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_771_9jffokkc_.arc
 
15      1    772     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_772_9jffrnq9_.arc
 
16      1    773     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_773_9jffy9fp_.arc
 
17      1    774     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_774_9jfg1vr0_.arc
 
18      1    775     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_775_9jfg6snt_.arc
 
19      1    776     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_776_9jfgb3pc_.arc
 
20      1    777     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_777_9jfgg1o5_.arc
 
21      1    778     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_778_9jfgj749_.arc
 
22      1    779     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_779_9jfgnkbx_.arc
 
23      1    780     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_780_9jfgq18r_.arc
 
24      1    781     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_781_9jfgscc2_.arc
 
25      1    782     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_782_9jfgvbmf_.arc
 
26      1    783     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_783_9jfgxgfj_.arc
 
27      1    784     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_784_9jfgyzh6_.arc
 
28      1    785     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_785_9jfh0yon_.arc
 
29      1    786     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_786_9jfh22r1_.arc
 
30      1    787     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_787_9jfh3ow7_.arc
 
31      1    788     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_788_9jfh4y33_.arc
 
32      1    789     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_789_9jfh78g7_.arc
 
33      1    790     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_790_9jfnsgqh_.arc
 
34      1    791     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_791_9jfp3gz6_.arc
 
35      1    792     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_792_9jfp5q2q_.arc
 
36      1    793     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_793_9jfp8n3c_.arc
 
37      1    794     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_794_9jfpcq7g_.arc
 
38      1    795     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_795_9jfpfpkd_.arc
 
39      1    796     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_796_9jfqpwvk_.arc
 
40      1    797     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_797_9jfr1c4b_.arc
 
46      1    798     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_798_9jg1o5yp_.arc
 
41      1    799     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_799_9jfvd7hd_.arc
 
42      1    800     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_800_9jfvhmpk_.arc
 
43      1    801     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_801_9jfzmnxk_.arc
 
44      1    802     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_802_9jg1mw72_.arc
 
45      1    803     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_803_9jg1o5yz_.arc
 
47      1    804     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_804_9jg1r845_.arc
 
48      1    805     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_805_9jg1t1jo_.arc
 
49      1    806     A 21-FEB-14
        Name: /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_806_9jg6c59f_.arc
 
 -- 恢复过程了所有的archive log, 所以有恢复到数据库的最后状态,即数据库升级一半的状态.
RMAN> recover database;
 
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 for thread 1 with sequence 761 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_761_9jfdf2l7_.arc
archived log for thread 1 with sequence 762 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_762_9jfdyt78_.arc
archived log for thread 1 with sequence 763 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_763_9jfdz27m_.arc
archived log for thread 1 with sequence 764 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_764_9jff1p33_.arc
archived log for thread 1 with sequence 765 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_765_9jff4kmr_.arc
archived log for thread 1 with sequence 766 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_766_9jff8492_.arc
archived log for thread 1 with sequence 767 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_767_9jfffb4l_.arc
archived log for thread 1 with sequence 768 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_768_9jffkp3t_.arc
archived log for thread 1 with sequence 769 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_769_9jffm50o_.arc
archived log for thread 1 with sequence 770 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_770_9jffnbmo_.arc
archived log for thread 1 with sequence 771 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_771_9jffokkc_.arc
archived log for thread 1 with sequence 772 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_772_9jffrnq9_.arc
archived log for thread 1 with sequence 773 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_773_9jffy9fp_.arc
archived log for thread 1 with sequence 774 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_774_9jfg1vr0_.arc
archived log for thread 1 with sequence 775 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_775_9jfg6snt_.arc
archived log for thread 1 with sequence 776 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_776_9jfgb3pc_.arc
archived log for thread 1 with sequence 777 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_777_9jfgg1o5_.arc
archived log for thread 1 with sequence 778 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_778_9jfgj749_.arc
archived log for thread 1 with sequence 779 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_779_9jfgnkbx_.arc
archived log for thread 1 with sequence 780 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_780_9jfgq18r_.arc
archived log for thread 1 with sequence 781 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_781_9jfgscc2_.arc
archived log for thread 1 with sequence 782 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_782_9jfgvbmf_.arc
archived log for thread 1 with sequence 783 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_783_9jfgxgfj_.arc
archived log for thread 1 with sequence 784 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_784_9jfgyzh6_.arc
archived log for thread 1 with sequence 785 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_785_9jfh0yon_.arc
archived log for thread 1 with sequence 786 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_786_9jfh22r1_.arc
archived log for thread 1 with sequence 787 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_787_9jfh3ow7_.arc
archived log for thread 1 with sequence 788 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_788_9jfh4y33_.arc
archived log for thread 1 with sequence 789 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_789_9jfh78g7_.arc
archived log for thread 1 with sequence 790 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_790_9jfnsgqh_.arc
archived log for thread 1 with sequence 791 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_791_9jfp3gz6_.arc
archived log for thread 1 with sequence 792 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_792_9jfp5q2q_.arc
archived log for thread 1 with sequence 793 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_793_9jfp8n3c_.arc
archived log for thread 1 with sequence 794 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_794_9jfpcq7g_.arc
archived log for thread 1 with sequence 795 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_795_9jfpfpkd_.arc
archived log for thread 1 with sequence 796 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_796_9jfqpwvk_.arc
archived log for thread 1 with sequence 797 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_797_9jfr1c4b_.arc
archived log for thread 1 with sequence 798 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_798_9jg1o5yp_.arc
archived log for thread 1 with sequence 799 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_799_9jfvd7hd_.arc
archived log for thread 1 with sequence 800 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_800_9jfvhmpk_.arc
archived log for thread 1 with sequence 801 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_801_9jfzmnxk_.arc
archived log for thread 1 with sequence 802 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_802_9jg1mw72_.arc
archived log for thread 1 with sequence 803 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_803_9jg1o5yz_.arc
archived log for thread 1 with sequence 804 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_804_9jg1r845_.arc
archived log for thread 1 with sequence 805 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_805_9jg1t1jo_.arc
archived log for thread 1 with sequence 806 is already on disk as file /expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_806_9jg6c59f_.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
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_761_9jfdf2l7_.arc thread=1 sequence=761
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_762_9jfdyt78_.arc thread=1 sequence=762
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_763_9jfdz27m_.arc thread=1 sequence=763
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_764_9jff1p33_.arc thread=1 sequence=764
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_765_9jff4kmr_.arc thread=1 sequence=765
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_766_9jff8492_.arc thread=1 sequence=766
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_767_9jfffb4l_.arc thread=1 sequence=767
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_768_9jffkp3t_.arc thread=1 sequence=768
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_769_9jffm50o_.arc thread=1 sequence=769
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_770_9jffnbmo_.arc thread=1 sequence=770
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_771_9jffokkc_.arc thread=1 sequence=771
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_772_9jffrnq9_.arc thread=1 sequence=772
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_773_9jffy9fp_.arc thread=1 sequence=773
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_774_9jfg1vr0_.arc thread=1 sequence=774
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_775_9jfg6snt_.arc thread=1 sequence=775
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_776_9jfgb3pc_.arc thread=1 sequence=776
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_777_9jfgg1o5_.arc thread=1 sequence=777
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_778_9jfgj749_.arc thread=1 sequence=778
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_779_9jfgnkbx_.arc thread=1 sequence=779
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_780_9jfgq18r_.arc thread=1 sequence=780
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_781_9jfgscc2_.arc thread=1 sequence=781
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_782_9jfgvbmf_.arc thread=1 sequence=782
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_783_9jfgxgfj_.arc thread=1 sequence=783
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_784_9jfgyzh6_.arc thread=1 sequence=784
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_785_9jfh0yon_.arc thread=1 sequence=785
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_786_9jfh22r1_.arc thread=1 sequence=786
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_787_9jfh3ow7_.arc thread=1 sequence=787
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_788_9jfh4y33_.arc thread=1 sequence=788
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_789_9jfh78g7_.arc thread=1 sequence=789
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_790_9jfnsgqh_.arc thread=1 sequence=790
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_791_9jfp3gz6_.arc thread=1 sequence=791
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_792_9jfp5q2q_.arc thread=1 sequence=792
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_793_9jfp8n3c_.arc thread=1 sequence=793
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_794_9jfpcq7g_.arc thread=1 sequence=794
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_795_9jfpfpkd_.arc thread=1 sequence=795
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_796_9jfqpwvk_.arc thread=1 sequence=796
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_797_9jfr1c4b_.arc thread=1 sequence=797
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_798_9jg1o5yp_.arc thread=1 sequence=798
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_799_9jfvd7hd_.arc thread=1 sequence=799
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_800_9jfvhmpk_.arc thread=1 sequence=800
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_801_9jfzmnxk_.arc thread=1 sequence=801
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_802_9jg1mw72_.arc thread=1 sequence=802
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_803_9jg1o5yz_.arc thread=1 sequence=803
archived log file name=/expdump/back/CDCRM02/archivelog/2014_02_21/o1_mf_1_804_9jg1r845_.arc thread=1 sequence=804
media recovery complete, elapsed time: 00:02:15
Finished recover at 24-FEB-14
--所以数据库还是打不开
RMAN> alter database open;
 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/24/2014 09:25:59
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 9352
Session ID: 1144 Serial number: 19
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: not connected to ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/24/2014 09:25:59
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option  
Process ID: 9352
Session ID: 1144 Serial number: 19 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/674865/viewspace-1086706/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-05-16

  • 博文量
    38
  • 访问量
    117710