1.錯(cuò)誤描述:在做一次恢復(fù)后,數(shù)據(jù)庫(kù)能正常打開(kāi),數(shù)據(jù)表也能正常查詢(xún),但過(guò)不了多久數(shù)據(jù)庫(kù)會(huì)自動(dòng)down掉
2.查看alert日志,發(fā)現(xiàn)如下信息
Thu May 05 13:30:26 2011
Flush retried for xcb 0x333acd74, pmd 0x33bdaa68
Doing block recovery for file 2 block 499
No block recovery was needed
Thu May 05 13:30:27 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_mmon_2392.trc:
ORA-00600: 內(nèi)部錯(cuò)誤代碼, 參數(shù): [4194], [15], [8], [], [], [], [], []
ORA-600 encountered when generating server alert SMG-4120
Flush retried for xcb 0x333acd74, pmd 0x33bdaa68
Doing block recovery for file 2 block 499
No block recovery was needed
Thu May 05 13:30:29 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_mmon_2392.trc:
ORA-00600: 內(nèi)部錯(cuò)誤代碼, 參數(shù): [4194], [15], [8], [], [], [], [], []
ORA-00001: 違反唯一約束條件 (SYS.RECENT_RESOURCE_INCARNATIONS$P)
Flush retried for xcb 0x333acd74, pmd 0x33bdaa68
Doing block recovery for file 2 block 499
No block recovery was needed
Thu May 05 13:30:32 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_mmon_2392.trc:
ORA-00600: 內(nèi)部錯(cuò)誤代碼, 參數(shù): [4194], [15], [8], [], [], [], [], []
ORA-00600: 內(nèi)部錯(cuò)誤代碼, 參數(shù): [4194], [15], [8], [], [], [], [], []
ORA-00001: 違反唯一約束條件 (SYS.RECENT_RESOURCE_INCARNATIONS$P)
Thu May 05 13:30:40 2011
Flush retried for xcb 0x333acd74, pmd 0x33bdaa68
Doing block recovery for file 2 block 499
No block recovery was needed
Thu May 05 13:30:41 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_pmon_836.trc:
ORA-00600: 內(nèi)部錯(cuò)誤代碼, 參數(shù): [4194], [15], [8], [], [], [], [], []
Thu May 05 13:30:42 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_pmon_836.trc:
ORA-00600: 內(nèi)部錯(cuò)誤代碼, 參數(shù): [4194], [15], [8], [], [], [], [], []
PMON: terminating instance due to error 472
Thu May 05 13:30:42 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_q001_3192.trc:
ORA-00472: PMON 進(jìn)程因錯(cuò)誤而終止
Thu May 05 13:30:43 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_lgwr_1072.trc:
ORA-00472: PMON 進(jìn)程因錯(cuò)誤而終止
Thu May 05 13:30:43 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_mman_660.trc:
ORA-00472: PMON 進(jìn)程因錯(cuò)誤而終止
Thu May 05 13:30:43 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_dbw0_1384.trc:
ORA-00472: PMON 進(jìn)程因錯(cuò)誤而終止
Thu May 05 13:30:43 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_psp0_2288.trc:
ORA-00472: PMON 進(jìn)程因錯(cuò)誤而終止
Thu May 05 13:30:44 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_smon_544.trc:
ORA-00472: PMON 進(jìn)程因錯(cuò)誤而終止
Thu May 05 13:30:44 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_ckpt_300.trc:
ORA-00472: PMON 進(jìn)程因錯(cuò)誤而終止
Thu May 05 13:30:49 2011
Errors in file d:\oracle\product\10.2.0\admin\suredd\bdump\suredd_reco_1700.trc:
ORA-00472: PMON 進(jìn)程因錯(cuò)誤而終止
3.經(jīng)查詢(xún)metalink,有如下提示
Short Description of ORA-00600[4194]
---------------------------------------
A mismatch has been detected between Redo records and rollback (Undo)
records.
ARGUMENTS:
Arg [a] Maximum Undo record number in Undo block
Arg [b] Undo record number from Redo block
Refer to Note:39283.1 for more details on the description of this error.
4.根據(jù)metalink的提示方案來(lái)解決問(wèn)題(ID 281429.1)(我的數(shù)據(jù)庫(kù)版本是10.2.1,window32的)
代碼如下:
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 5月 5 14:28:31 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
已連接到空閑例程。
/**//** 第一步:啟動(dòng)到nomount狀態(tài),創(chuàng)建pfile,
將pfile里面的自動(dòng)undo管理改為手工管理,并打開(kāi)數(shù)據(jù)庫(kù)*/
SQL> startup nomount
ORACLE 例程已經(jīng)啟動(dòng)。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 222301060 bytes
Database Buffers 381681664 bytes
Redo Buffers 7135232 bytes
SQL> create pfile='c:\p1.ora' from spfile;
文件已創(chuàng)建。
SQL> shutdown immediate
ORA-01507: ??????
ORACLE 例程已經(jīng)關(guān)閉。
SQL> startup mount pfile='c:\p1.ora';
ORACLE 例程已經(jīng)啟動(dòng)。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 222301060 bytes
Database Buffers 381681664 bytes
Redo Buffers 7135232 bytes
數(shù)據(jù)庫(kù)裝載完畢。
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string MANUAL
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> alter database open;
數(shù)據(jù)庫(kù)已更改。
/**//**第二步:先創(chuàng)建一個(gè)回滾段并使用,
再新建一個(gè)新的undo表空間,并將老的undo表空間drop*/
SQL> Create rollback segment r01 ;
回退段已創(chuàng)建。
SQL>
SQL> Alter rollback segment r01 online ;
回退段已變更。
SQL> Create undo tablespace undotbs_new datafile 'D:\oracle\product\10.2.0\oradata\suredd\untotbs_new_01.dbf' size 50M;
表空間已創(chuàng)建。
SQL> drop tablespace UNDOTBS1 including contents and datafiles;
表空間已刪除。
/**//**第三步:關(guān)閉數(shù)據(jù)庫(kù),使用spfile啟動(dòng)到nomount狀態(tài)(其實(shí)就是讓undo繼續(xù)自動(dòng)管理),
將undo表空間指向新創(chuàng)建的undo表空間,再關(guān)閉數(shù)據(jù)庫(kù)再啟動(dòng)數(shù)據(jù)庫(kù)*/
SQL> shutdown immediate
數(shù)據(jù)庫(kù)已經(jīng)關(guān)閉。
已經(jīng)卸載數(shù)據(jù)庫(kù)。
ORACLE 例程已經(jīng)關(guān)閉。
SQL> startup nomount
ORACLE 例程已經(jīng)啟動(dòng)。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 222301060 bytes
Database Buffers 381681664 bytes
Redo Buffers 7135232 bytes
SQL> alter system set undo_tablespace=undotbs_new scope=spfile;
系統(tǒng)已更改。
SQL> shutdown immediate
ORA-01507: ??????
ORACLE 例程已經(jīng)關(guān)閉。
SQL> startup
ORACLE 例程已經(jīng)啟動(dòng)。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 222301060 bytes
Database Buffers 381681664 bytes
Redo Buffers 7135232 bytes
數(shù)據(jù)庫(kù)裝載完畢。
數(shù)據(jù)庫(kù)已經(jīng)打開(kāi)。
SQL> select * from dd.t1;
ID NAME
---------- ----------
1 test1
2 test2
SQL> /
ID NAME
---------- ----------
1 test1
2 test2
SQL> alter system checkpoint;
系統(tǒng)已更改。
SQL> alter system archive log current;
系統(tǒng)已更改。
SQL> select * from dd.t1;
ID NAME
---------- ----------
1 test1
2 test2
SQL> /
ID NAME
---------- ----------
1 test1
2 test2
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS_NEW
SQL>
posted on 2011-05-05 14:53
xrzp 閱讀(9791)
評(píng)論(2) 編輯 收藏 所屬分類(lèi):
oracle-備份恢復(fù)