由于突然断电,在恢复供电后启动数据库报以下错误信息:
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.