升級失敗後對資料庫進行恢復 (1)
對資料庫進行升級,由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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 升級失敗後對資料庫進行恢復 (2)資料庫
- 升級失敗後，資料庫降級方案（flashback database）資料庫Database
- 資料庫resetlogs後進行rman恢復1資料庫
- 【資料庫資料恢復】MongoDB資料庫服務啟動失敗的資料恢復案例資料庫資料恢復MongoDB
- 歸檔路徑更改後，如何對資料庫進行恢復(轉)資料庫
- 資料庫resetlogs後進行rman恢復7資料庫
- 資料庫resetlogs後進行rman恢復6資料庫
- 資料庫resetlogs後進行rman恢復5資料庫
- 資料庫resetlogs後進行rman恢復4資料庫
- 資料庫resetlogs後進行rman恢復3資料庫
- 資料庫resetlogs後進行rman恢復2資料庫
- 資料庫複製方式進行資料庫恢復資料庫
- DM7使用DMRAMN對多次故障恢復後使用不同資料庫的歸檔進行恢復資料庫
- 寶塔資料庫恢復 mysql資料庫丟失恢復 mysql資料庫刪除庫恢復 寶塔mysql資料庫恢復資料庫MySql
- 【vsan資料恢復】vsan資料重構失敗的資料恢復案例資料恢復
- 附加資料庫失敗,無法升級資料庫，因為它是隻讀的資料庫
- 如何在HarmonyOS對資料庫進行備份，恢復與加密資料庫加密
- 【伺服器資料恢復】Raid陣列更換故障硬碟後資料同步失敗的資料恢復案例伺服器資料恢復AI陣列硬碟
- 硬碟/行動硬碟分割槽合併失敗資料丟失瞭如何恢復?硬碟
- LogMnr-誤DML後使用logmnr對資料進行恢復
- 只有.dbf資料檔案進行資料庫恢復資料庫
- 使用netbackup進行資料庫恢復案例資料庫
- 升級win10系統後恢復印表機安裝失敗無法列印如何解決Win10
- oracle歸檔日誌丟失後的資料庫恢復Oracle資料庫
- chkdsk 後資料丟失的恢復方法
- DATA GUARD主庫丟失資料檔案的恢復(1)
- 【資料庫資料恢復】Sql Server資料庫檔案丟失的資料恢復過程資料庫資料恢復SQLServer
- 儲存互斥失敗導致資料丟失的資料恢復成功案例資料恢復
- 還是Oracle的資料庫破壞試驗，針對不同檔案的丟失進行恢復Oracle資料庫
- win7升級win10失敗怎麼辦_win7升級win10失敗進不了系統修復方法Win7Win10
- POSTGRESQL 小版本升級失敗後的原因分析SQL
- 【資料庫資料恢復】斷電導致Oracle資料庫資料丟失的資料恢復案例資料庫資料恢復Oracle
- 使用dbms_backup_restore進行資料庫恢復REST資料庫
- 透過RMAN進行資料庫恢復（step by step）資料庫
- 【伺服器資料恢復】RAID5重建初始化失敗，資料丟失的資料恢復伺服器資料恢復AI
- 電腦硬碟資料丟失後怎麼恢復？硬碟資料恢復技巧教程硬碟資料恢復
- 還是Oracle的資料庫破壞試驗，RMAN針對不同檔案的丟失進行恢復Oracle資料庫
- NAS升級如何恢復系統資料夾？