对数据库进行升级,由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博客 ” ，链接：https://blog.itpub.net/674865/viewspace-1086706/ ，如需转载，请注明出处，否则将追究法律责任。
