1.錯誤描述:在做一次恢復后,數據庫能正常打開,數據表也能正常查詢,但過不了多久數據庫會自動down掉
2.查看alert日志,發現如下信息
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: 內部錯誤代碼, 參數: [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: 內部錯誤代碼, 參數: [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: 內部錯誤代碼, 參數: [4194], [15], [8], [], [], [], [], []
ORA-00600: 內部錯誤代碼, 參數: [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: 內部錯誤代碼, 參數: [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: 內部錯誤代碼, 參數: [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 進程因錯誤而終止
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 進程因錯誤而終止
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 進程因錯誤而終止
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 進程因錯誤而終止
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 進程因錯誤而終止
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 進程因錯誤而終止
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 進程因錯誤而終止
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 進程因錯誤而終止
3.經查詢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.根據metalink的提示方案來解決問題(ID 281429.1)(我的數據庫版本是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.
已連接到空閑例程。
/**//** 第一步:啟動到nomount狀態,創建pfile,
將pfile里面的自動undo管理改為手工管理,并打開數據庫*/
SQL> startup nomount
ORACLE 例程已經啟動。
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;
文件已創建。
SQL> shutdown immediate
ORA-01507: ??????
ORACLE 例程已經關閉。
SQL> startup mount pfile='c:\p1.ora';
ORACLE 例程已經啟動。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 222301060 bytes
Database Buffers 381681664 bytes
Redo Buffers 7135232 bytes
數據庫裝載完畢。
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string MANUAL
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> alter database open;
數據庫已更改。
/**//**第二步:先創建一個回滾段并使用,
再新建一個新的undo表空間,并將老的undo表空間drop*/
SQL> Create rollback segment r01 ;
回退段已創建。
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;
表空間已創建。
SQL> drop tablespace UNDOTBS1 including contents and datafiles;
表空間已刪除。
/**//**第三步:關閉數據庫,使用spfile啟動到nomount狀態(其實就是讓undo繼續自動管理),
將undo表空間指向新創建的undo表空間,再關閉數據庫再啟動數據庫*/
SQL> shutdown immediate
數據庫已經關閉。
已經卸載數據庫。
ORACLE 例程已經關閉。
SQL> startup nomount
ORACLE 例程已經啟動。
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;
系統已更改。
SQL> shutdown immediate
ORA-01507: ??????
ORACLE 例程已經關閉。
SQL> startup
ORACLE 例程已經啟動。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 222301060 bytes
Database Buffers 381681664 bytes
Redo Buffers 7135232 bytes
數據庫裝載完畢。
數據庫已經打開。
SQL> select * from dd.t1;
ID NAME
---------- ----------
1 test1
2 test2
SQL> /
ID NAME
---------- ----------
1 test1
2 test2
SQL> alter system checkpoint;
系統已更改。
SQL> alter system archive log current;
系統已更改。
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 閱讀(9798)
評論(2) 編輯 收藏 所屬分類:
oracle-備份恢復