00600 ora 关闭oracle_oracle断电重启之ORA-00600[4194]

最新推荐文章于 2021-04-08 17:34:36 发布

weixin_39611174

最新推荐文章于 2021-04-08 17:34:36 发布

阅读量97

点赞数

文章标签： 00600 ora 关闭oracle

本文链接：https://blog.csdn.net/weixin_39611174/article/details/111528681

版权

Starting up:

Oracle Database 11g Enterprise Edition Release11.2.0.1.0 -Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.

Using parameter settingsin server-side spfile D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEPRJDB.ORA

System parameters with non-defaultvalues:

processes= 150nls_language= "SIMPLIFIED CHINESE"nls_territory= "CHINA"memory_target=1232M

control_files= "D:\ORACLE\ORADATA\PRJDB\CONTROL01.CTL"control_files= "D:\ORACLE\FLASH_RECOVERY_AREA\PRJDB\CONTROL02.CTL"db_block_size= 8192compatible= "11.2.0.0.0"db_recovery_file_dest= "d:\oracle\flash_recovery_area"db_recovery_file_dest_size=3852M

undo_tablespace= "UNDOTBS1"remote_login_passwordfile= "EXCLUSIVE"db_domain= ""dispatchers= "(PROTOCOL=TCP) (SERVICE=prjdbXDB)"audit_file_dest= "D:\ORACLE\ADMIN\PRJDB\ADUMP"audit_trail= "DB"db_name= "prjdb"open_cursors= 300deferred_segment_creation=FALSE

diagnostic_dest= "D:\ORACLE"Wed Jun11 10:43:02 2014PMON started with pid=2, OS id=3868Wed Jun11 10:43:02 2014VKTM started with pid=3, OS id=2484at elevated priority

VKTM running at (10)millisec precision with DBRM quantum (100)ms

Wed Jun11 10:43:02 2014GEN0 started with pid=4, OS id=2544Wed Jun11 10:43:02 2014DIAG started with pid=5, OS id=2376Wed Jun11 10:43:02 2014DBRM started with pid=6, OS id=3264Wed Jun11 10:43:02 2014PSP0 started with pid=7, OS id=3936Wed Jun11 10:43:02 2014DIA0 started with pid=8, OS id=3836Wed Jun11 10:43:02 2014MMAN started with pid=9, OS id=2688Wed Jun11 10:43:02 2014DBW0 started with pid=10, OS id=708Wed Jun11 10:43:02 2014LGWR started with pid=11, OS id=3716Wed Jun11 10:43:02 2014CKPT started with pid=12, OS id=492Wed Jun11 10:43:02 2014SMON started with pid=13, OS id=1324Wed Jun11 10:43:02 2014RECO started with pid=14, OS id=1828Wed Jun11 10:43:02 2014MMON started with pid=15, OS id=3672starting up1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

Wed Jun11 10:43:02 2014MMNL started with pid=16, OS id=3908starting up1shared server(s) ...

ORACLE_BASEfrom environment =d:\oracle

Wed Jun11 10:43:02 2014alter database mount exclusive

Successful mount of redo thread1, with mount id 1302693302Database mountedinExclusive Mode

Lost write protection disabled

Completed: alter database mount exclusive

alter database open

Beginning crash recovery of1threads

parallel recovery started with2processes

Started redo scan

Completed redo scan

read34 KB redo, 20data blocks need recovery

Started redo application at

Thread1: logseq 4145, block 3Recovery of Online Redo Log: Thread1 Group 2 Seq 4145 Reading mem 0Mem#0: D:\ORACLE\ORADATA\PRJDB\REDO02.LOG

Completed redo application of0.02MB

Completed crash recovery at

Thread1: logseq 4145, block 71, scn 176123270

20 data blocks read, 20 data blocks written, 34 redo k-bytes read

Wed Jun11 10:43:14 2014Thread1 advanced to log sequence 4146(thread open)

Thread1 opened at log sequence 4146Current log#3 seq# 4146 mem# 0: D:\ORACLE\ORADATA\PRJDB\REDO03.LOG

Successful open of redo thread1Wed Jun11 10:43:15 2014MTTR advisoryis disabled because FAST_START_MTTR_TARGET is not setWed Jun11 10:43:15 2014SMON: enabling cache recovery

Successfully onlined Undo Tablespace2.

Verifying file header compatibilityfor11g tablespace encryption..

Verifying 11g file header compatibilityfortablespace encryption completed

SMON: enabling tx recovery

Database CharactersetisUS7ASCII

Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_smon_1324.trc (incident=69779):

ORA-00600: ??????, ??: [4194], [], [

Incident detailsin: d:\oracle\diag\rdbms\prjdb\prjdb\incident\incdir_69779\prjdb_smon_1324_i69779.trc

No Resource Manager plan active

replication_dependency_tracking turned off (noasyncmultimaster replication found)

Wed Jun11 10:43:19 2014Trace dumpingis performing id=[cdmp_20140611104319]

Doing block recoveryfor file 3 block 502Resuming block recovery (PMON)for file 3 block 502Block recoveryfrom logseq 4146, block 63 to scn 176123517Recovery of Online Redo Log: Thread1 Group 3 Seq 4146 Reading mem 0Mem#0: D:\ORACLE\ORADATA\PRJDB\REDO03.LOG

Block recovery stopped at EOT rba4146.73.16Block recovery completed at rba4146.73.16, scn 0.176123515Doing block recoveryfor file 3 block 240Resuming block recovery (PMON)for file 3 block 240Block recoveryfrom logseq 4146, block 63 to scn 176123507Recovery of Online Redo Log: Thread1 Group 3 Seq 4146 Reading mem 0Mem#0: D:\ORACLE\ORADATA\PRJDB\REDO03.LOG

Block recovery completed at rba4146.69.16, scn 0.176123509Errorsinfile d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_smon_1324.trc:

ORA-01595: ??? (2) ??? (8) ???ORA-00600: ??????, ??: [4194], [], [

Starting background process QMNC

Wed Jun11 10:43:22 2014QMNC started with pid=22, OS id=2124Wed Jun11 10:43:23 2014Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_mmon_3672.trc (incident=69795):

ORA-00600: ??????, ??: [4193], [], [

Incident detailsin: d:\oracle\diag\rdbms\prjdb\prjdb\incident\incdir_69795\prjdb_mmon_3672_i69795.trc

Completed: alter database open

Trace dumpingis performing id=[cdmp_20140611104326]

Doing block recoveryfor file 3 block 5380Resuming block recovery (PMON)for file 3 block 5380Block recoveryfrom logseq 4146, block 73 to scn 176123528Recovery of Online Redo Log: Thread1 Group 3 Seq 4146 Reading mem 0Mem#0: D:\ORACLE\ORADATA\PRJDB\REDO03.LOG

Block recovery stopped at EOT rba4146.77.16Block recovery completed at rba4146.77.16, scn 0.176123527Doing block recoveryfor file 3 block 272Resuming block recovery (PMON)for file 3 block 272Block recoveryfrom logseq 4146, block 73 to scn 176123520Recovery of Online Redo Log: Thread1 Group 3 Seq 4146 Reading mem 0Mem#0: D:\ORACLE\ORADATA\PRJDB\REDO03.LOG

Block recovery completed at rba4146.73.16, scn 0.176123521Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_mmon_3672.trc (incident=69796):

ORA-00600: ??????, ??: [4193], [: ??Incident detailsin: d:\oracle\diag\rdbms\prjdb\prjdb\incident\incdir_69796\prjdb_mmon_3672_i69796.trc

Block recovery completed at rba4146.77.16, scn 0.176123530Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_mmon_3672.trc (incident=69797):

ORA-00600: ??????, ??: [4193], [], [

Incident detailsin: d:\oracle\diag\rdbms\prjdb\prjdb\incident\incdir_69797\prjdb_mmon_3672_i69797.trc

Wed Jun11 10:43:33 2014Trace dumpingis performing id=[cdmp_20140611104333]

Wed Jun11 10:43:34 2014Doing block recoveryfor file 3 block 5380Resuming block recovery (PMON)for file 3 block 5380Block recoveryfrom logseq 4146, block 73 to scn 176123528Recovery of Online Redo Log: Thread1 Group 3 Seq 4146 Reading mem 0Mem#0: D:\ORACLE\ORADATA\PRJDB\REDO03.LOG

Block recovery completed at rba4146.77.16, scn 0.176123530Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_mmon_3672.trc (incident=69798):

ORA-00600: ??????, ??: [4193], [], [

Incident detailsin: d:\oracle\diag\rdbms\prjdb\prjdb\incident\incdir_69798\prjdb_mmon_3672_i69798.trc

Trace dumpingis performing id=[cdmp_20140611104335]

Trace dumpingis performing id=[cdmp_20140611104337]

Block recovery completed at rba4146.77.16, scn 0.176123530Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_mmon_3672.trc (incident=69799):

ORA-00600: ??????, ??: [4193], [], [

Incident detailsin: d:\oracle\diag\rdbms\prjdb\prjdb\incident\incdir_69799\prjdb_mmon_3672_i69799.trc

Block recovery completed at rba4146.77.16, scn 0.176123530Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_mmon_3672.trc (incident=69800):

ORA-00600: ??????, ??: [4193], [], [

Trace dumpingis performing id=[cdmp_20140611104339]

Block recovery completed at rba4146.77.16, scn 0.176123530Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_mmon_3672.trc (incident=69801):

ORA-00600: ??????, ??: [4193], [], [

Block recovery completed at rba4146.77.16, scn 0.176123530Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_mmon_3672.trc (incident=69802):

ORA-00600: ??????, ??: [4193], [], [

Block recovery completed at rba4146.77.16, scn 0.176123530Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_mmon_3672.trc (incident=70876):

ORA-00600: ??????, ??: [4193], [], [

Block recovery completed at rba4146.77.16, scn 0.176123530Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_mmon_3672.trc (incident=70877):

ORA-00600: ??????, ??: [4193], [], [

Block recovery completed at rba4146.77.16, scn 0.176123530Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_mmon_3672.trc (incident=70878):

ORA-00600: ??????, ??: [4193], [], [

Block recovery completed at rba4146.77.16, scn 0.176123530Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_mmon_3672.trc (incident=70879):

ORA-00600: ??????, ??: [4193], [], [

Wed Jun11 10:43:46 2014Doing block recoveryfor file 3 block 5380Resuming block recovery (PMON)for file 3 block 5380Block recoveryfrom logseq 4146, block 73 to scn 176123528Recovery of Online Redo Log: Thread1 Group 3 Seq 4146 Reading mem 0Mem#0: D:\ORACLE\ORADATA\PRJDB\REDO03.LOG

Block recovery completed at rba4146.77.16, scn 0.176123530Errorsin file d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_pmon_3868.trc (incident=69691):

ORA-00600: ??????, ??: [4193], [], [

Errorsinfile d:\oracle\diag\rdbms\prjdb\prjdb\trace\prjdb_pmon_3868.trc:

ORA-00600: ??????, ??: [4193], [], [

PMON (ospid:3868): terminating the instance due to error 472