windows32位平台数据库宕机不能open怎么办(七)
19 07786908
1e0e3319 07786908 1e0e3319 02c102ff ff0180ff 018002c1 022c0011 02c11402
<32 bytes per line>
BBED> sum apply
Check value for File 1, Block 122:
current = 0x08ad, required = 0x08ad
6、修改其他错误，open数据
库数据块修改完成后，添加参数，再次尝试open数据库参数文件修改如下：
[plain]
tjserver.__db_cache_size=75497472
tjserver.__java_pool_size=4194304
tjserver.__large_pool_size=4194304
tjserver.__shared_pool_size=79691776
tjserver.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/tjserver/adump'
*.background_dump_dest='/opt/oracle/admin/tjserver/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/opt/oracle/oradata/tjserver/control01.ctl','/opt/
oracle/oradata/tjserver/control02.ctl','/opt/oracle/oradata/tjserver
/control03.ctl'
oracle/oradata/tjserver/control02.ctl','/opt/oracle/oradata/tjserver
/control03.ctl'
*.core_dump_dest='/opt/oracle/admin/tjserver/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='tjserver'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=tjserverXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=52428800
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=167772160
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/admin/tjserver/udump'
*._allow_resetlogs_corruption='true'
*._allow_error_simulation=true
*.event='10513 trace name context forever,level 2'
sql> alter database open;
ORA-1092 signalled during: alter database open...
open失败，再次查看alerttjserver.log：
[plain]
Thu Mar 21 23:00:06 2013
Errors in file /opt/oracle/admin/tjserver/udump/tjserver_ora_1613.trc:
ORA-00600: internal error code, arguments: [2662], [0], [61969008],
[0], [65698991], [4194313], [], []
[0], [65698991], [4194313], [], []
Thu Mar 21 23:00:07 2013
Errors in file /opt/oracle/admin/tjserver/udump/tjserver_ora_1613.trc:
ORA-00600: internal error code, arguments: [2662], [0], [61969008],
[0], [65698991], [4194313], [], []
Thu Mar 21 23:00:07 2013
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 1613
ORA-1092 signalled during: alter database open...
出现了ORA-00600 [2662]错误，需要调整下系统SCN：
sql>startup mount;
sql>alter session set events '10015 trace name adjust_scn level 1';
sql>alter database open;
至此数据库就OPEN起来了，不过使用PL SQL等工具，仍然不断
有错误抛出来。
有错误抛出来。
7、做全库的exp导出，然后恢复到新的数据库中。
先考虑做个exp全备恢复到其他机器上。
结果exp工具也报ORA-06553错误，执行下以下脚本：
sql> alter package standard compile;
sql>alter procedure dbms_application_info compile;
再执行exp就可以了。
cmd>set anls_lang=american_america.us7ascii
cmd>exp system@tjserver file=..... log=..... full=y buffer=
100024024 feedback=10000
100024024 feedback=10000