ORA-27090,ORA-00600: internal error code, arguments: [4194],的解決方法

eric0435發表於2013-05-17
由於突然斷電,在恢復供電後啟動資料庫報以下錯誤資訊:
ALTER DATABASE OPEN
Fri May 17 14:22:14 CST 2013
Beginning crash recovery of 1 threads
 parallel recovery started with 7 processes
Fri May 17 14:22:14 CST 2013
Started redo scan
Fri May 17 14:22:14 CST 2013
Completed redo scan
 57 redo blocks read, 4 data blocks need recovery
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p003_14475.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 3
Additional information: 1
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Warning: recovery process cannot use async I/O
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p006_14483.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 3
Additional information: 1
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Warning: recovery process cannot use async I/O
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p004_14477.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 3
Additional information: 1
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Warning: recovery process cannot use async I/O
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p005_14479.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 3
Additional information: 1
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p000_14469.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 3
Additional information: 1
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Warning: recovery process cannot use async I/O
Fri May 17 14:22:15 CST 2013
Warning: recovery process cannot use async I/O
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p001_14471.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 3
Additional information: 1
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Warning: recovery process cannot use async I/O
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p002_14473.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Additional information: 3
Additional information: 1
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Warning: recovery process cannot use async I/O
Fri May 17 14:22:15 CST 2013
Started redo application at
 Thread 1: logseq 15220, block 3
Fri May 17 14:22:15 CST 2013
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15220 Reading mem 0
  Mem# 0: /oradata/test/redo02.ora
  Mem# 1: /oradata/test/redo12.ora
Fri May 17 14:22:15 CST 2013
Completed redo application
Fri May 17 14:22:15 CST 2013
Completed crash recovery at
 Thread 1: logseq 15220, block 60, scn 12785313401558
 4 data blocks read, 4 data blocks written, 57 redo blocks read
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p001_14471.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p006_14483.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p005_14479.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p004_14477.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p003_14475.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p002_14473.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 65536
Fri May 17 14:22:16 CST 2013
Thread 1 advanced to log sequence 15221 (thread open)
Thread 1 opened at log sequence 15221
  Current log# 3 seq# 15221 mem# 0: /oradata/test/redo03.ora
  Current log# 3 seq# 15221 mem# 1: /oradata/test/redo13.ora
Successful open of redo thread 1
Fri May 17 14:22:17 CST 2013
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri May 17 14:22:17 CST 2013
SMON: enabling cache recovery
Fri May 17 14:22:19 CST 2013
Successfully onlined Undo Tablespace 1.
Fri May 17 14:22:19 CST 2013
SMON: enabling tx recovery
Fri May 17 14:22:19 CST 2013
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
Fri May 17 14:22:20 CST 2013
Errors in file /orac/trace/test_ora_14467.trc:
ORA-00600: internal error code, arguments: [4194], [40], [4], [], [], [], [], []
Doing block recovery for file 2 block 27642
Resuming block recovery (PMON) for file 2 block 27642
Block recovery from logseq 15221, block 53 to scn 12785313405025
Fri May 17 14:22:24 CST 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 15221 Reading mem 0
  Mem# 0: /oradata/test/redo03.ora
  Mem# 1: /oradata/test/redo13.ora
Block recovery stopped at EOT rba 15221.55.16
Block recovery completed at rba 15221.55.16, scn 2976.3490728813
Doing block recovery for file 2 block 89
Resuming block recovery (PMON) for file 2 block 89
Block recovery from logseq 15221, block 53 to scn 12785313401708
Fri May 17 14:22:24 CST 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 15221 Reading mem 0
  Mem# 0: /oradata/test/redo03.ora
  Mem# 1: /oradata/test/redo13.ora
Block recovery completed at rba 15221.55.16, scn 2976.3490728813
Fri May 17 14:22:24 CST 2013
Errors in file /orac/trace/test_ora_14467.trc:
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
DEBUG: Replaying xcb 0x1196da808, pmd 0x118394558 for failed op 8
Doing block recovery for file 2 block 4266
No block recovery was needed
Fri May 17 14:22:26 CST 2013
Errors in file /orac/trace/test_ora_14467.trc:
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
Fri May 17 14:22:27 CST 2013
Errors in file /orac/trace/test_ora_14467.trc:
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
Fri May 17 14:22:31 CST 2013
DEBUG: Replaying xcb 0x1196da808, pmd 0x118394558 for failed op 8
Doing block recovery for file 2 block 4266
No block recovery was needed
Fri May 17 14:22:33 CST 2013
Errors in file /orac/admin/test/bdump/test_pmon_14433.trc:
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
Fri May 17 14:22:34 CST 2013
Errors in file /orac/admin/test/bdump/test_pmon_14433.trc:
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
PMON: terminating instance due to error 472

對於ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
這個錯誤可以修改作業系統核心引數
核心引數的值:fs.aio-max-nr設定太低,推薦設定為fs.aio-max-nr= 3145728。修改引數使用/sbin/sysctl -p重新載入引數後,重啟資料庫即可。

對於ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []

這個是回滾表空間出錯,
可以先使用手功管理的回滾表空間的方式將資料庫開啟
設定如下引數
undo_tablespace='SYSTEM'
undo_management='MANUAL'
SQL> create pfile from spfile;

File created.

[root@powerdb dbs]# vi inittest.ora
test.__db_cache_size=2868903936
test.__java_pool_size=16777216
test.__large_pool_size=16777216
test.__shared_pool_size=285212672
test.__streams_pool_size=16777216
*.audit_file_dest='/orac/admin/test/adump'
*.background_dump_dest='/orac/admin/test/bdump'
*.compatible='10.2.0.5.0'
*.control_files='/oradata/test/control01.ctl','/oradata/test/control02.ctl','/oradata/test/control03.ctl'
*.core_dump_dest='/orac/admin/test/cdump'
*.db_block_size=8192
*.db_cache_size=0
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='test'
*.db_recovery_file_dest='/orac/flash_recovery_area'
*.db_recovery_file_dest_size=21474836480
*.db_writer_processes=5
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
*.job_queue_processes=10
*.max_dump_file_size='500'
*.open_cursors=700
*.optimizer_mode='ALL_ROWS'
*.pga_aggregate_target=805306368
*.processes=500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=600
*.sga_max_size=3221225472
*.sga_target=3221225472
*.sort_area_size=1048576
#*.undo_management='AUTO'
*.undo_retention=120
#*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/orac/trace'
undo_tablespace='SYSTEM'
undo_management='MANUAL'
修改引數後使用修改的引數檔案來啟動資料庫
SQL> startup pfile=/orac/10.2.0/db_1/dbs/inittest.ora
ORACLE instance started.

Total System Global Area 3221225472 bytes
Fixed Size                  2099752 bytes
Variable Size             335545816 bytes
Database Buffers         2868903936 bytes
Redo Buffers               14675968 bytes
Database mounted.
Database opened.

然後建立新的回滾表空間
SQL> create undo tablespace undotbs02 datafile '/oradata/test/undotbs02.dbf' size 5G;

Tablespace created.
刪除原來的回滾表空間
SQL> drop tablespace undotbs1;

Tablespace dropped.
將回滾表空間設定為新建立的回滾表空間
SQL> alter system set undo_tablespace="undotbs02" scope=spfile;

System altered.
將回滾表空間管理方式設定為自動
SQL> alter system set undo_management=auto scope=spfile;

System altered.
修改伺服器引數檔案
SQL> create pfile from spfile;

File created.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 3221225472 bytes
Fixed Size                  2099752 bytes
Variable Size             352323032 bytes
Database Buffers         2852126720 bytes
Redo Buffers               14675968 bytes
Database mounted.
Database opened.
SQL> select * from v$tablespace;

       TS# NAME                           INC BIG FLA ENC
---------- ------------------------------ --- --- --- ---
         0 SYSTEM                         YES NO  YES
         2 SYSAUX                         YES NO  YES
         4 USERS                          YES NO  YES
         3 TEMP                           NO  NO  YES
         6 HYGEIA                         YES NO  YES
         9 UNDOTBS02                      YES NO  YES

6 rows selected.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26015009/viewspace-761356/,如需轉載,請註明出處,否則將追究法律責任。

相關文章