ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []

Thu Dec 20 15:40:18 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
WARNING: db_recovery_file_dest is same as db_create_file_dest
Autotune of undo retention is turned on.
IMODE=BR
ILAT =134
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /u01/app/product/11.2
System name: AIX
Node name: P550
Release: 1
Version: 6
Machine: 00C8F0564C00
Using parameter settings in server-side spfile /u01/app/product/11.2/dbs/spfilesgerp5.ora
System parameters with non-default values:
  processes                = 800
  sessions                 = 1224
  event                    = "10949 trace name context forever, level 1"
  memory_target            = 33G
  control_files            = "+DATA/sgerp5/controlfile/current.256.802493563"
  control_files            = "+DATA/sgerp5/controlfile/current.257.802493563"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  log_archive_dest_1       = "location=/oraarch"
  log_archive_format       = "ARC_ERP5_%s_%r_%t.log"
  db_create_file_dest      = "+DATA"
  db_recovery_file_dest    = "+DATA"
  db_recovery_file_dest_size= 30G
  _allow_resetlogs_corruption= TRUE
  undo_tablespace          = "UNDOTBS1"
  undo_retention           = 25200
  recyclebin               = "OFF"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  distributed_lock_timeout = 300
  session_cached_cursors   = 100
  audit_file_dest          = "/u01/app/admin/sgerp5/adump"
  audit_trail              = "NONE"
  db_name                  = "sgerp5"
  open_cursors             = 1000
  diagnostic_dest          = "/u01/app"
Thu Dec 20 15:40:19 2012
PMON started with pid=2, OS id=6422922
Thu Dec 20 15:40:19 2012
PSP0 started with pid=3, OS id=6357428
Thu Dec 20 15:40:20 2012
VKTM started with pid=4, OS id=4587932 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Dec 20 15:40:20 2012
GEN0 started with pid=5, OS id=6095268
Thu Dec 20 15:40:20 2012
DIAG started with pid=6, OS id=5571024
Thu Dec 20 15:40:20 2012
DBRM started with pid=7, OS id=5505358
Thu Dec 20 15:40:20 2012
DIA0 started with pid=8, OS id=6619378
Thu Dec 20 15:40:20 2012
MMAN started with pid=9, OS id=4784448
Thu Dec 20 15:40:21 2012
DBW0 started with pid=10, OS id=5963816
Thu Dec 20 15:40:21 2012
LGWR started with pid=11, OS id=7012574
Thu Dec 20 15:40:21 2012
CKPT started with pid=12, OS id=3801422
Thu Dec 20 15:40:21 2012
SMON started with pid=13, OS id=6750228
Thu Dec 20 15:40:21 2012
RECO started with pid=14, OS id=6357154
Thu Dec 20 15:40:21 2012
RBAL started with pid=15, OS id=6291618
Thu Dec 20 15:40:21 2012
ASMB started with pid=16, OS id=6881294
Thu Dec 20 15:40:21 2012
MMON started with pid=17, OS id=5505054
NOTE: initiating MARK startup
Starting background process MARK
Thu Dec 20 15:40:22 2012
MMNL started with pid=18, OS id=5636480
ORACLE_BASE from environment = /u01/app
Thu Dec 20 15:40:22 2012
MARK started with pid=19, OS id=3604890
NOTE: MARK has subscribed
Thu Dec 20 15:40:22 2012
ALTER DATABASE   MOUNT
Thu Dec 20 15:40:22 2012
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=129.100.253.147)(PORT=1521))))' SCOPE=MEMORY SID='sgerp5';
NOTE: Loaded library: System
SUCCESS: diskgroup DATA was mounted
NOTE: dependency between database sgerp5 and diskgroup resource ora.DATA.dg is established
Successful mount of redo thread 1, with mount id 3583548966
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Thu Dec 20 15:40:30 2012
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
 parallel recovery started with 7 processes
Started redo scan
Completed redo scan
 read 1 KB redo, 2 data blocks need recovery
Started redo application at
 Thread 1: logseq 2, block 3
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_2.407.802538325
  Mem# 1: +DATA/sgerp5/onlinelog/group_2.408.802538331
Completed redo application of 0.00MB
Completed crash recovery at
 Thread 1: logseq 2, block 5, scn 112603060
 2 data blocks read, 2 data blocks written, 1 redo k-bytes read
Thu Dec 20 15:40:32 2012
Thread 1 advanced to log sequence 3 (thread open)
Thread 1 opened at log sequence 3
  Current log# 3 seq# 3 mem# 0: +DATA/sgerp5/onlinelog/group_3.409.802538841
  Current log# 3 seq# 3 mem# 1: +DATA/sgerp5/onlinelog/group_3.410.802538851
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Dec 20 15:40:32 2012
SMON: enabling cache recovery
[6226180] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:57721121 end:57722061 diff:940 (9 seconds)
Dictionary check beginning
File #9 is offline, but is part of an online tablespace.
data file 9: '+DATA/sgerp5/datafile/erp2010.404.802535901'
Successfuly brought file #9 online.
File #10 is offline, but is part of an online tablespace.
data file 10: '+DATA/sgerp5/datafile/erp2011.375.802527983'
Successfuly brought file #10 online.
File #37 is offline, but is part of an online tablespace.
data file 37: '+DATA/sgerp5/datafile/erp2010.350.802520993'
Successfuly brought file #37 online.
File #38 is offline, but is part of an online tablespace.
data file 38: '+DATA/sgerp5/datafile/erp2010.291.802505971'
Successfuly brought file #38 online.
File #39 is offline, but is part of an online tablespace.
data file 39: '+DATA/sgerp5/datafile/erp2010.262.802498653'
Successfuly brought file #39 online.
File #40 is offline, but is part of an online tablespace.
data file 40: '+DATA/sgerp5/datafile/erp2010.322.802513497'
Successfuly brought file #40 online.
File #41 is offline, but is part of an online tablespace.
data file 41: '+DATA/sgerp5/datafile/erp2011.380.802528663'
Successfuly brought file #41 online.
File #42 is offline, but is part of an online tablespace.
data file 42: '+DATA/sgerp5/datafile/erp2010.351.802520995'
Successfuly brought file #42 online.
File #43 is offline, but is part of an online tablespace.
data file 43: '+DATA/sgerp5/datafile/erp2010.292.802505971'
Successfuly brought file #43 online.
File #44 is offline, but is part of an online tablespace.
data file 44: '+DATA/sgerp5/datafile/erp2010.261.802498655'
Successfuly brought file #44 online.
File #45 is offline, but is part of an online tablespace.
data file 45: '+DATA/sgerp5/datafile/erp2010.323.802513499'
Successfuly brought file #45 online.
File #46 is offline, but is part of an online tablespace.
data file 46: '+DATA/sgerp5/datafile/erp2011.381.802528663'
Successfuly brought file #46 online.
File #47 is offline, but is part of an online tablespace.
data file 47: '+DATA/sgerp5/datafile/erp2011.352.802520995'
Successfuly brought file #47 online.
File #48 is offline, but is part of an online tablespace.
data file 48: '+DATA/sgerp5/datafile/erp2011.293.802505971'
Successfuly brought file #48 online.
File #49 is offline, but is part of an online tablespace.
data file 49: '+DATA/sgerp5/datafile/erp2011.260.802498655'
Successfuly brought file #49 online.
File #50 is offline, but is part of an online tablespace.
data file 50: '+DATA/sgerp5/datafile/erp2011.324.802513499'
Successfuly brought file #50 online.
File #51 is offline, but is part of an online tablespace.
data file 51: '+DATA/sgerp5/datafile/erp2011.382.802528665'
Successfuly brought file #51 online.
File #52 is offline, but is part of an online tablespace.
data file 52: '+DATA/sgerp5/datafile/erp2011.353.802520997'
Successfuly brought file #52 online.
File #53 is offline, but is part of an online tablespace.
data file 53: '+DATA/sgerp5/datafile/erp2011.294.802505973'
Successfuly brought file #53 online.
File #54 is offline, but is part of an online tablespace.
data file 54: '+DATA/sgerp5/datafile/erp2011.271.802498657'
Successfuly brought file #54 online.
File #55 is offline, but is part of an online tablespace.
data file 55: '+DATA/sgerp5/datafile/erp2011.325.802514583'
Successfuly brought file #55 online.
File #56 is offline, but is part of an online tablespace.
data file 56: '+DATA/sgerp5/datafile/erp2011.383.802528665'
Successfuly brought file #56 online.
File #57 is offline, but is part of an online tablespace.
data file 57: '+DATA/sgerp5/datafile/erp2011.354.802520997'
Successfuly brought file #57 online.
File #58 is offline, but is part of an online tablespace.
data file 58: '+DATA/sgerp5/datafile/erp2011.295.802505973'
Successfuly brought file #58 online.
File #59 is offline, but is part of an online tablespace.
data file 59: '+DATA/sgerp5/datafile/erp2011.270.802498657'
Successfuly brought file #59 online.
File #60 is offline, but is part of an online tablespace.
data file 60: '+DATA/sgerp5/datafile/erp2011.326.802515083'
Successfuly brought file #60 online.
File #61 is offline, but is part of an online tablespace.
data file 61: '+DATA/sgerp5/datafile/erp2011.384.802530929'
Successfuly brought file #61 online.
File #62 is offline, but is part of an online tablespace.
data file 62: '+DATA/sgerp5/datafile/erp2011.355.802522093'
Successfuly brought file #62 online.
File #63 is offline, but is part of an online tablespace.
data file 63: '+DATA/sgerp5/datafile/erp2011.296.802507057'
Successfuly brought file #63 online.
File #64 is offline, but is part of an online tablespace.
data file 64: '+DATA/sgerp5/datafile/erp2011.268.802499747'
Successfuly brought file #64 online.
File #65 is offline, but is part of an online tablespace.
data file 65: '+DATA/sgerp5/datafile/erp2011.327.802515777'
Successfuly brought file #65 online.
Thu Dec 20 15:40:34 2012
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_dbw0_5963816.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '+DATA/sgerp5/tempfile/temp.267.799890715'
ORA-17503: ksfdopn:2 Failed to open file +DATA/sgerp5/tempfile/temp.267.799890715
ORA-15012: ASM file '+DATA/sgerp5/tempfile/temp.267.799890715' does not exist
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_dbw0_5963816.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '+DATA/sgerp5/tempfile/temp.267.799890715'
File 201 not verified due to error ORA-01157
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_dbw0_5963816.trc:
ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: '+DATA/sgerp5/tempfile/temp.261.799941073'
ORA-17503: ksfdopn:2 Failed to open file +DATA/sgerp5/tempfile/temp.261.799941073
ORA-15012: ASM file '+DATA/sgerp5/tempfile/temp.261.799941073' does not exist
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_dbw0_5963816.trc:
ORA-01186: file 202 failed verification tests
ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: '+DATA/sgerp5/tempfile/temp.261.799941073'
File 202 not verified due to error ORA-01157
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_dbw0_5963816.trc:
ORA-01157: cannot identify/lock data file 203 - see DBWR trace file
ORA-01110: data file 203: '+DATA/sgerp5/tempfile/temp.262.799941103'
ORA-17503: ksfdopn:2 Failed to open file +DATA/sgerp5/tempfile/temp.262.799941103
ORA-15012: ASM file '+DATA/sgerp5/tempfile/temp.262.799941103' does not exist
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_dbw0_5963816.trc:
ORA-01186: file 203 failed verification tests
ORA-01157: cannot identify/lock data file 203 - see DBWR trace file
ORA-01110: data file 203: '+DATA/sgerp5/tempfile/temp.262.799941103'
File 203 not verified due to error ORA-01157
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_dbw0_5963816.trc:
ORA-01157: cannot identify/lock data file 204 - see DBWR trace file
ORA-01110: data file 204: '+DATA/sgerp5/tempfile/temp.275.799941163'
ORA-17503: ksfdopn:2 Failed to open file +DATA/sgerp5/tempfile/temp.275.799941163
ORA-15012: ASM file '+DATA/sgerp5/tempfile/temp.275.799941163' does not exist
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_dbw0_5963816.trc:
ORA-01186: file 204 failed verification tests
ORA-01157: cannot identify/lock data file 204 - see DBWR trace file
ORA-01110: data file 204: '+DATA/sgerp5/tempfile/temp.275.799941163'
File 204 not verified due to error ORA-01157
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Re-creating tempfile +DATA/sgerp5/tempfile/temp.275.799941163 as +DATA/sgerp5/tempfile/temp.427.802539635
Re-creating tempfile +DATA/sgerp5/tempfile/temp.262.799941103 as +DATA/sgerp5/tempfile/temp.428.802539635
Re-creating tempfile +DATA/sgerp5/tempfile/temp.261.799941073 as +DATA/sgerp5/tempfile/temp.429.802539635
Re-creating tempfile +DATA/sgerp5/tempfile/temp.267.799890715 as +DATA/sgerp5/tempfile/temp.430.802539635
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
SMON: Parallel transaction recovery tried
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_smon_6750228.trc  (incident=102513):
ORA-00600: internal error code, arguments: [4194], [DATA/sgerp5/tempfile/temp.261.799941073
Starting background process QMNC
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_102513/sgerp5_smon_6750228_i102513.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Dec 20 15:40:36 2012
QMNC started with pid=43, OS id=4522142
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Thu Dec 20 15:40:37 2012
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_5505054.trc  (incident=102545):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_102545/sgerp5_mmon_5505054_i102545.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Completed: ALTER DATABASE OPEN

 

 

 

 

 解决方法：

Block recovery from logseq 3, block 536 to scn 112603630
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_3.409.802538841
  Mem# 1: +DATA/sgerp5/onlinelog/group_3.410.802538851
Block recovery stopped at EOT rba 3.1696.16
Block recovery completed at rba 3.1696.16, scn 0.112603630
Block recovery from logseq 3, block 536 to scn 112603623
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_3.409.802538841
  Mem# 1: +DATA/sgerp5/onlinelog/group_3.410.802538851
Block recovery completed at rba 3.536.16, scn 0.112603624
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_smon_6750228.trc:
ORA-01595: error freeing extent (3) of rollback segment (1))
ORA-00600: internal error code, arguments: [4194], [DATA/sgerp5/t], [], [], [], [], [], [], [], [], [], []
Thu Dec 20 15:40:38 2012
Dumping diagnostic data in directory=[cdmp_20121220154038], requested by (instance=1, osid=6750228 (SMON)), summary=[incident=102513].
Dumping diagnostic data in directory=[cdmp_20121220154039], requested by (instance=1, osid=5505054 (MMON)), summary=[incident=102545].
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_5505054.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.411.802538855'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.412.802538859'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any r
Starting background process SMCO
Thu Dec 20 15:40:40 2012
SMCO started with pid=44, OS id=5767378
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_5505054.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.411.802538855'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.412.802538859'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any r
Block recovery from logseq 3, block 1693 to scn 112603635
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_3.409.802538841
  Mem# 1: +DATA/sgerp5/onlinelog/group_3.410.802538851
Block recovery stopped at EOT rba 3.1702.16
Block recovery completed at rba 3.1702.16, scn 0.112603635
Block recovery from logseq 3, block 1693 to scn 112603627
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_3.409.802538841
  Mem# 1: +DATA/sgerp5/onlinelog/group_3.410.802538851
Block recovery completed at rba 3.1695.16, scn 0.112603629
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_5505054.trc  (incident=102546):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_102546/sgerp5_mmon_5505054_i102546.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Dumping diagnostic data in directory=[cdmp_20121220154043], requested by (instance=1, osid=5505054 (MMON)), summary=[incident=102546].
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_5505054.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.411.802538855'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.412.802538859'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any r
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_5505054.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.411.802538855'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.412.802538859'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any r
Block recovery from logseq 3, block 1702 to scn 112603639
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_3.409.802538841
  Mem# 1: +DATA/sgerp5/onlinelog/group_3.410.802538851
Block recovery stopped at EOT rba 3.1704.16
Block recovery completed at rba 3.1704.16, scn 0.112603638
Block recovery from logseq 3, block 1702 to scn 112603637
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_3.409.802538841
  Mem# 1: +DATA/sgerp5/onlinelog/group_3.410.802538851
Block recovery completed at rba 3.1704.16, scn 0.112603638
Thu Dec 20 15:40:48 2012
Restarting dead background process MMON
Thu Dec 20 15:40:48 2012
MMON started with pid=17, OS id=5505056
Thu Dec 20 15:41:27 2012
Sweep [inc][102546]: completed
Sweep [inc][102545]: completed
Sweep [inc][102513]: completed
Sweep [inc2][102546]: completed
Sweep [inc2][102545]: completed
Sweep [inc2][102513]: completed
Thu Dec 20 15:42:17 2012
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 17
ALTER DATABASE CLOSE NORMAL
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_6226182.trc  (incident=102577):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_102577/sgerp5_ora_6226182_i102577.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_102577/sgerp5_ora_6226182_i102577.trc:
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.411.802538855'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.412.802538859'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinel
Thu Dec 20 15:42:26 2012
Dumping diagnostic data in directory=[cdmp_20121220154226], requested by (instance=1, osid=6226182), summary=[incident=102577].
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_6226182.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.411.802538855'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.412.802538859'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any r
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_6226182.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.411.802538855'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_4.412.802538859'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any r
Block recovery from logseq 3, block 1714 to scn 112603676
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_3.409.802538841
  Mem# 1: +DATA/sgerp5/onlinelog/group_3.410.802538851
Block recovery stopped at EOT rba 3.1716.16
Block recovery completed at rba 3.1716.16, scn 0.112603674
Block recovery from logseq 3, block 1714 to scn 112603673
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_3.409.802538841
  Mem# 1: +DATA/sgerp5/onlinelog/group_3.410.802538851
Block recovery completed at rba 3.1716.16, scn 0.112603674
ORA-600 signalled during: ALTER DATABASE CLOSE NORMAL...
Thu Dec 20 15:44:19 2012
License high water mark = 17
USER (ospid: 6029440): terminating the instance
Instance terminated by USER, pid = 6029440
Thu Dec 20 15:44:38 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
WARNING: db_recovery_file_dest is same as db_create_file_dest
Autotune of undo retention is turned on.
IMODE=BR
ILAT =134
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /u01/app/product/11.2
System name: AIX
Node name: P550
Release: 1
Version: 6
Machine: 00C8F0564C00
Using parameter settings in server-side spfile /u01/app/product/11.2/dbs/spfilesgerp5.ora
System parameters with non-default values:
  processes                = 800
  sessions                 = 1224
  event                    = "10949 trace name context forever, level 1"
  memory_target            = 33G
  control_files            = "+DATA/sgerp5/controlfile/current.256.802493563"
  control_files            = "+DATA/sgerp5/controlfile/current.257.802493563"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  log_archive_dest_1       = "location=/oraarch"
  log_archive_format       = "ARC_ERP5_%s_%r_%t.log"
  db_create_file_dest      = "+DATA"
  db_recovery_file_dest    = "+DATA"
  db_recovery_file_dest_size= 30G
  _allow_resetlogs_corruption= TRUE
  undo_tablespace          = "UNDOTBS1"
  undo_retention           = 25200
  recyclebin               = "OFF"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  distributed_lock_timeout = 300
  session_cached_cursors   = 100
  audit_file_dest          = "/u01/app/admin/sgerp5/adump"
  audit_trail              = "NONE"
  db_name                  = "sgerp5"
  open_cursors             = 1000
  diagnostic_dest          = "/u01/app"
Thu Dec 20 15:44:38 2012
PMON started with pid=2, OS id=6357434
Thu Dec 20 15:44:38 2012
PSP0 started with pid=3, OS id=5898638
Thu Dec 20 15:44:40 2012
VKTM started with pid=4, OS id=7012578 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Dec 20 15:44:40 2012
GEN0 started with pid=5, OS id=2883744
Thu Dec 20 15:44:40 2012
DIAG started with pid=6, OS id=4522430
Thu Dec 20 15:44:40 2012
DBRM started with pid=7, OS id=6750238
Thu Dec 20 15:44:40 2012
DIA0 started with pid=8, OS id=6881302
Thu Dec 20 15:44:40 2012
MMAN started with pid=9, OS id=6095276
Thu Dec 20 15:44:40 2012
DBW0 started with pid=10, OS id=5505360
Thu Dec 20 15:44:40 2012
LGWR started with pid=11, OS id=5571032
Thu Dec 20 15:44:40 2012
CKPT started with pid=12, OS id=4784450
Thu Dec 20 15:44:41 2012
SMON started with pid=13, OS id=6619384
Thu Dec 20 15:44:41 2012
RECO started with pid=14, OS id=6291620
Thu Dec 20 15:44:41 2012
RBAL started with pid=15, OS id=3801424
Thu Dec 20 15:44:41 2012
ASMB started with pid=16, OS id=3604892
Thu Dec 20 15:44:41 2012
MMON started with pid=17, OS id=6357160
NOTE: initiating MARK startup
Thu Dec 20 15:44:41 2012
MMNL started with pid=18, OS id=3539274
Starting background process MARK
ORACLE_BASE from environment = /u01/app
Thu Dec 20 15:44:41 2012
ALTER DATABASE   MOUNT
Thu Dec 20 15:44:41 2012
MARK started with pid=19, OS id=6095032
NOTE: MARK has subscribed
Thu Dec 20 15:44:42 2012
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=129.100.253.147)(PORT=1521))))' SCOPE=MEMORY SID='sgerp5';
Thu Dec 20 15:44:44 2012
Sweep [inc][102577]: completed
Sweep [inc2][102577]: completed
NOTE: Loaded library: System
SUCCESS: diskgroup DATA was mounted
NOTE: dependency between database sgerp5 and diskgroup resource ora.DATA.dg is established
Successful mount of redo thread 1, with mount id 3583538730
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Thu Dec 20 15:44:49 2012
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
 parallel recovery started with 7 processes
Started redo scan
Completed redo scan
 read 1 KB redo, 0 data blocks need recovery
Started redo application at
 Thread 1: logseq 3, block 1714
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_3.409.802538841
  Mem# 1: +DATA/sgerp5/onlinelog/group_3.410.802538851
Completed redo application of 0.00MB
Completed crash recovery at
 Thread 1: logseq 3, block 1716, scn 112623674
 0 data blocks read, 0 data blocks written, 1 redo k-bytes read
Thu Dec 20 15:44:51 2012
Thread 1 advanced to log sequence 4 (thread open)
Thread 1 opened at log sequence 4
  Current log# 4 seq# 4 mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Current log# 4 seq# 4 mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Dec 20 15:44:51 2012
SMON: enabling cache recovery
[4587946] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:57980557 end:57981465 diff:908 (9 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_smon_6619384.trc  (incident=108917):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_108917/sgerp5_smon_6619384_i108917.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Thu Dec 20 15:44:54 2012
QMNC started with pid=34, OS id=6029472
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x141343B0E] [PC:0x1000E1984, kgegpa()+36] [flags: 0x0, count: 1]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x141343B0E] [PC:0x1000E1984, kgegpa()+36] [flags: 0x2, count: 2]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x141343B0E] [PC:0x1000E1984, kgegpa()+36] [flags: 0x2, count: 2]
Thu Dec 20 15:44:54 2012
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_6357160.trc  (incident=108949):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_108949/sgerp5_mmon_6357160_i108949.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Dec 20 15:44:55 2012
Dumping diagnostic data in directory=[cdmp_20121220154455], requested by (instance=1, osid=6619384 (SMON)), summary=[incident=108917].
Block recovery from logseq 4, block 525 to scn 112625219
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery stopped at EOT rba 4.528.16
Block recovery completed at rba 4.528.16, scn 0.112625219
Block recovery from logseq 4, block 525 to scn 112625216
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.525.16, scn 0.112625218
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_smon_6619384.trc:
ORA-01595: error freeing extent (3) of rollback segment (1))
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Thu Dec 20 15:44:56 2012
Block recovery from logseq 4, block 525 to scn 112625219
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery stopped at EOT rba 4.528.16
Block recovery completed at rba 4.528.16, scn 0.112625219
Block recovery from logseq 4, block 525 to scn 112625218
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.528.16, scn 0.112625219
Starting background process SMCO
Thu Dec 20 15:44:57 2012
SMCO started with pid=20, OS id=5046374
Dumping diagnostic data in directory=[cdmp_20121220154458], requested by (instance=1, osid=6357160 (MMON)), summary=[incident=108949].
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_6357160.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_6357160.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Block recovery from logseq 4, block 525 to scn 112625224
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery stopped at EOT rba 4.529.16
Block recovery completed at rba 4.529.16, scn 0.112625222
Block recovery from logseq 4, block 525 to scn 112625218
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.528.16, scn 0.112625221
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_6357160.trc  (incident=108950):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_108950/sgerp5_mmon_6357160_i108950.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_6357160.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Dumping diagnostic data in directory=[cdmp_20121220154503], requested by (instance=1, osid=6357160 (MMON)), summary=[incident=108950].
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_6357160.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Block recovery from logseq 4, block 529 to scn 112625228
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery stopped at EOT rba 4.531.16
Block recovery completed at rba 4.531.16, scn 0.112625227
Block recovery from logseq 4, block 529 to scn 112625226
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.531.16, scn 0.112625227
Restarting dead background process MMON
Thu Dec 20 15:45:06 2012
MMON started with pid=17, OS id=3211626
Thu Dec 20 15:45:46 2012
Sweep [inc][108950]: completed
Sweep [inc][108949]: completed
Sweep [inc][108917]: completed
Sweep [inc2][108950]: completed
Sweep [inc2][108949]: completed
Sweep [inc2][108917]: completed
Thu Dec 20 15:47:06 2012
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_5767634.trc  (incident=109117):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_109117/sgerp5_ora_5767634_i109117.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_109117/sgerp5_ora_5767634_i109117.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Thu Dec 20 15:47:10 2012
Dumping diagnostic data in directory=[cdmp_20121220154710], requested by (instance=1, osid=5767634), summary=[incident=109117].
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_5767634.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_5767634.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Block recovery from logseq 4, block 531 to scn 112625272
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery stopped at EOT rba 4.533.16
Block recovery completed at rba 4.533.16, scn 0.112625270
Block recovery from logseq 4, block 531 to scn 112625269
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.533.16, scn 0.112625270
Thu Dec 20 15:47:13 2012
Sweep [inc][109117]: completed
Sweep [inc2][109117]: completed
Thu Dec 20 15:47:19 2012
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_4718730.trc  (incident=109118):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_109118/sgerp5_ora_4718730_i109118.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_4718730.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Thu Dec 20 15:47:21 2012
Dumping diagnostic data in directory=[cdmp_20121220154721], requested by (instance=1, osid=4718730), summary=[incident=109118].
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_4718730.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Block recovery from logseq 4, block 533 to scn 112625276
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery stopped at EOT rba 4.535.16
Block recovery completed at rba 4.535.16, scn 0.112625275
Block recovery from logseq 4, block 533 to scn 112625274
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.535.16, scn 0.112625275
Thu Dec 20 15:48:13 2012
Sweep [inc][109118]: completed
Sweep [inc2][109118]: completed
Thu Dec 20 15:49:46 2012
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3211626.trc  (incident=108951):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_108951/sgerp5_mmon_3211626_i108951.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Dec 20 15:49:48 2012
Dumping diagnostic data in directory=[cdmp_20121220154948], requested by (instance=1, osid=3211626 (MMON)), summary=[incident=108951].
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3211626.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3211626.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Block recovery from logseq 4, block 536 to scn 112625328
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery stopped at EOT rba 4.538.16
Block recovery completed at rba 4.538.16, scn 0.112625327
Block recovery from logseq 4, block 536 to scn 112625326
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.538.16, scn 0.112625327
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3211626.trc  (incident=108952):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_108952/sgerp5_mmon_3211626_i108952.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3211626.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Dumping diagnostic data in directory=[cdmp_20121220154954], requested by (instance=1, osid=3211626 (MMON)), summary=[incident=108952].
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3211626.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Block recovery from logseq 4, block 540 to scn 112625335
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery stopped at EOT rba 4.542.16
Block recovery completed at rba 4.542.16, scn 0.112625334
Block recovery from logseq 4, block 540 to scn 112625333
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.542.16, scn 0.112625334
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3211626.trc  (incident=108953):
ORA-00600: internal error code, arguments: [kewrose_1], [600], [ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_108953/sgerp5_mmon_3211626_i108953.trc
Thu Dec 20 15:49:57 2012
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x183656A0C] [PC:0x1000E1984, kgegpa()+36] [flags: 0x0, count: 1]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x183656A0C] [PC:0x1000E1984, kgegpa()+36] [flags: 0x2, count: 2]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x183656A0C] [PC:0x1000E1984, kgegpa()+36] [flags: 0x2, count: 2]
Thu Dec 20 15:49:58 2012
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_smon_6619384.trc  (incident=108918):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Dumping diagnostic data in directory=[cdmp_20121220154958], requested by (instance=1, osid=3211626 (MMON)), summary=[incident=108953].
Thu Dec 20 15:50:00 2012
Block recovery from logseq 4, block 545 to scn 112625338
Block recovery from logseq 4, block 545 to scn 112625338
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.552.16, scn 0.112625339
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.552.16, scn 0.112625339
Block recovery from logseq 4, block 545 to scn 112625339
Block recovery from logseq 4, block 545 to scn 112625338
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.552.16, scn 0.112625339
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 1 out of maximum 100 non-fatal internal errors.
Block recovery completed at rba 4.554.16, scn 0.112625340
Restarting dead background process MMON
Thu Dec 20 15:50:01 2012
MMON started with pid=17, OS id=4850102
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_4850102.trc  (incident=108954):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_108954/sgerp5_mmon_4850102_i108954.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Dec 20 15:50:04 2012
Sweep [inc][108953]: completed
Sweep [inc][108952]: completed
Sweep [inc][108951]: completed
Sweep [inc][108918]: completed
Sweep [inc2][108953]: completed
Sweep [inc2][108952]: completed
Sweep [inc2][108951]: completed
Thu Dec 20 15:50:06 2012
Dumping diagnostic data in directory=[cdmp_20121220155006], requested by (instance=1, osid=4850102 (MMON)), summary=[incident=108954].
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_4850102.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_4850102.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Block recovery from logseq 4, block 554 to scn 112625343
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery stopped at EOT rba 4.557.16
Block recovery completed at rba 4.557.16, scn 0.112625343
Block recovery from logseq 4, block 554 to scn 112625341
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.556.16, scn 0.112625342
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_4850102.trc  (incident=108955):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_4850102.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_4850102.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Block recovery from logseq 4, block 557 to scn 112625347
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery stopped at EOT rba 4.559.16
Block recovery completed at rba 4.559.16, scn 0.112625346
Block recovery from logseq 4, block 557 to scn 112625345
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.559.16, scn 0.112625346
Thu Dec 20 15:52:18 2012
Restarting dead background process MMON
Thu Dec 20 15:52:18 2012
MMON started with pid=17, OS id=3604510
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3604510.trc  (incident=108956):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Thu Dec 20 15:52:21 2012
Sweep [inc][108955]: completed
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sweep [inc][108954]: completed
Sweep [inc2][108954]: completed
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3604510.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3604510.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Block recovery from logseq 4, block 561 to scn 112625397
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.564.16, scn 0.112625398
Block recovery from logseq 4, block 561 to scn 112625395
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.563.16, scn 0.112625397
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3604510.trc  (incident=115214):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/sgerp5/sgerp5/incident/incdir_115214/sgerp5_mmon_3604510_i115214.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Dec 20 15:52:25 2012
Dumping diagnostic data in directory=[cdmp_20121220155225], requested by (instance=1, osid=3604510 (MMON)), summary=[incident=115214].
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3604510.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_mmon_3604510.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Block recovery from logseq 4, block 564 to scn 112625400
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery stopped at EOT rba 4.566.16
Block recovery completed at rba 4.566.16, scn 0.112625399
Block recovery from logseq 4, block 564 to scn 112625398
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.566.16, scn 0.112625399
Thu Dec 20 15:52:29 2012
ALTER SYSTEM SET event='10513 trace name context forever,level 2 : 10512 trace name context forever,level 1: 10511 trace name context forever,level 2: 10510 trace name context forever,level 1' SCOPE=SPFILE;
Thu Dec 20 15:52:39 2012
ALTER SYSTEM SET undo_management='MANUAL' SCOPE=SPFILE;
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Stopping background process MMNL
Thu Dec 20 15:52:49 2012
License high water mark = 9
ALTER DATABASE CLOSE NORMAL
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_4849762.trc  (incident=109109):

 

ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_4849762.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_4849762.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.413.802538863'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_5.414.802538867'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.415.802538873'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_6.416.802538877'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.419.802538881'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_7.420.802538885'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.421.802538889'
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '+DATA/sgerp5/onlinelog/group_8.422.802538895'
ORA-00339: archived log does not contain any r
Block recovery from logseq 4, block 567 to scn 112625410
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery stopped at EOT rba 4.569.16
Block recovery completed at rba 4.569.16, scn 0.112625409
Block recovery from logseq 4, block 567 to scn 112625408
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Block recovery completed at rba 4.569.16, scn 0.112625409
ORA-600 signalled during: ALTER DATABASE CLOSE NORMAL...
Thu Dec 20 15:53:15 2012
License high water mark = 9
USER (ospid: 3539278): terminating the instance
Instance terminated by USER, pid = 3539278
Thu Dec 20 15:53:24 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
WARNING: db_recovery_file_dest is same as db_create_file_dest
Autotune of undo retention is turned off.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /u01/app/product/11.2
System name: AIX
Node name: P550
Release: 1
Version: 6
Machine: 00C8F0564C00
Using parameter settings in server-side spfile /u01/app/product/11.2/dbs/spfilesgerp5.ora
System parameters with non-default values:
  processes                = 800
  sessions                 = 1224
  event                    = "10513 trace name context forever,level 2 : 10512 trace name context forever,level 1: 10511 trace name context forever,level 2: 10510 trace name context forever,level 1"
  memory_target            = 33G
  control_files            = "+DATA/sgerp5/controlfile/current.256.802493563"
  control_files            = "+DATA/sgerp5/controlfile/current.257.802493563"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  log_archive_dest_1       = "location=/oraarch"
  log_archive_format       = "ARC_ERP5_%s_%r_%t.log"
  db_create_file_dest      = "+DATA"
  db_recovery_file_dest    = "+DATA"
  db_recovery_file_dest_size= 30G
  _allow_resetlogs_corruption= TRUE
  undo_management          = "MANUAL"
  undo_tablespace          = "UNDOTBS1"
  undo_retention           = 25200
  recyclebin               = "OFF"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  distributed_lock_timeout = 300
  session_cached_cursors   = 100
  audit_file_dest          = "/u01/app/admin/sgerp5/adump"
  audit_trail              = "NONE"
  db_name                  = "sgerp5"
  open_cursors             = 1000
  diagnostic_dest          = "/u01/app"
Thu Dec 20 15:53:25 2012
PMON started with pid=2, OS id=7012580
Thu Dec 20 15:53:25 2012
PSP0 started with pid=3, OS id=5898642
Thu Dec 20 15:53:26 2012
VKTM started with pid=4, OS id=5963822 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Dec 20 15:53:26 2012
GEN0 started with pid=5, OS id=5571034
Thu Dec 20 15:53:26 2012
DIAG started with pid=6, OS id=6881304
Thu Dec 20 15:53:26 2012
DBRM started with pid=7, OS id=6095288
Thu Dec 20 15:53:26 2012
DIA0 started with pid=8, OS id=5505362
Thu Dec 20 15:53:27 2012
MMAN started with pid=9, OS id=6750244
Thu Dec 20 15:53:27 2012
DBW0 started with pid=10, OS id=4522432
Thu Dec 20 15:53:27 2012
LGWR started with pid=11, OS id=4784454
Thu Dec 20 15:53:27 2012
CKPT started with pid=12, OS id=6619388
Thu Dec 20 15:53:27 2012
SMON started with pid=13, OS id=3604894
Thu Dec 20 15:53:27 2012
RECO started with pid=14, OS id=3801430
Thu Dec 20 15:53:27 2012
RBAL started with pid=15, OS id=4849778
Thu Dec 20 15:53:27 2012
ASMB started with pid=16, OS id=5833024
Thu Dec 20 15:53:28 2012
MMON started with pid=17, OS id=5308854
NOTE: initiating MARK startup
Starting background process MARK
Thu Dec 20 15:53:28 2012
MMNL started with pid=18, OS id=6095034
ORACLE_BASE from environment = /u01/app
Thu Dec 20 15:53:28 2012
MARK started with pid=19, OS id=4391376
NOTE: MARK has subscribed
Thu Dec 20 15:53:28 2012
ALTER DATABASE   MOUNT
Thu Dec 20 15:53:28 2012
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=129.100.253.147)(PORT=1521))))' SCOPE=MEMORY SID='sgerp5';
Thu Dec 20 15:53:31 2012
Sweep [inc][115214]: completed
Sweep [inc][109109]: completed
Sweep [inc][108956]: completed
Sweep [inc2][115214]: completed
NOTE: Loaded library: System
SUCCESS: diskgroup DATA was mounted
NOTE: dependency between database sgerp5 and diskgroup resource ora.DATA.dg is established
Successful mount of redo thread 1, with mount id 3583552568
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Thu Dec 20 15:53:45 2012
alter database open
Beginning crash recovery of 1 threads
 parallel recovery started with 7 processes
Started redo scan
Completed redo scan
 read 1 KB redo, 0 data blocks need recovery
Started redo application at
 Thread 1: logseq 4, block 567
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0
  Mem# 0: +DATA/sgerp5/onlinelog/group_4.411.802538855
  Mem# 1: +DATA/sgerp5/onlinelog/group_4.412.802538859
Completed redo application of 0.00MB
Completed crash recovery at
 Thread 1: logseq 4, block 569, scn 112645409
 0 data blocks read, 0 data blocks written, 1 redo k-bytes read
Thu Dec 20 15:53:47 2012
Thread 1 advanced to log sequence 5 (thread open)
Thread 1 opened at log sequence 5
  Current log# 5 seq# 5 mem# 0: +DATA/sgerp5/onlinelog/group_5.413.802538863
  Current log# 5 seq# 5 mem# 1: +DATA/sgerp5/onlinelog/group_5.414.802538867
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Dec 20 15:53:47 2012
SMON: enabling cache recovery
Undo initialization finished serial:0 start:58516497 end:58516946 diff:449 (4 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Thu Dec 20 15:53:49 2012
QMNC started with pid=34, OS id=3407948
Completed: alter database open

 

 

Thu Dec 20 15:53:52 2012
db_recovery_file_dest_size of 30720 MB is 66.73% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Dec 20 15:53:53 2012
Starting background process CJQ0
Thu Dec 20 15:53:53 2012
CJQ0 started with pid=37, OS id=6488404
Thu Dec 20 15:53:54 2012
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_m001_6357182.trc:
ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'
Thu Dec 20 15:57:32 2012
CREATE UNDO TABLESPACE undotbs2 DATAFILE
  '+DATA' SIZE 8192M AUTOEXTEND OFF
RETENTION NOGUARANTEE
BLOCKSIZE 8K
FLASHBACK ON
Thu Dec 20 15:57:51 2012
Completed: CREATE UNDO TABLESPACE undotbs2 DATAFILE
  '+DATA' SIZE 8192M AUTOEXTEND OFF
RETENTION NOGUARANTEE
BLOCKSIZE 8K
FLASHBACK ON
Thu Dec 20 15:58:21 2012
ALTER SYSTEM SET undo_management='AUTO' SCOPE=SPFILE;
Thu Dec 20 15:58:43 2012
ALTER SYSTEM SET undo_tablespace='UNDOTBS2' SCOPE=SPFILE;
Thu Dec 20 15:58:50 2012
Starting background process SMCO
Thu Dec 20 15:58:50 2012
SMCO started with pid=20, OS id=4850138
Thu Dec 20 15:58:57 2012
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Thu Dec 20 15:58:58 2012
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 8
ALTER DATABASE CLOSE NORMAL
Thu Dec 20 15:59:03 2012
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Dec 20 15:59:03 2012
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 161
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 5
Successful close of redo thread 1
Thu Dec 20 15:59:03 2012
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 4
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Thu Dec 20 15:59:04 2012
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 2
Completed: ALTER DATABASE DISMOUNT
Thu Dec 20 15:59:04 2012
NOTE: Deferred communication with ASM instance
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
NOTE: force a map free for map id 161
NOTE: force a map free for map id 2
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Thu Dec 20 15:59:05 2012
Stopping background process VKTM
Thu Dec 20 15:59:05 2012
NOTE: Shutting down MARK background process
Thu Dec 20 15:59:10 2012
Instance shutdown complete
Thu Dec 20 15:59:29 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
WARNING: db_recovery_file_dest is same as db_create_file_dest
Autotune of undo retention is turned on.
IMODE=BR
ILAT =134
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /u01/app/product/11.2
System name: AIX
Node name: P550
Release: 1
Version: 6
Machine: 00C8F0564C00
Using parameter settings in server-side spfile /u01/app/product/11.2/dbs/spfilesgerp5.ora
System parameters with non-default values:
  processes                = 800
  sessions                 = 1224
  event                    = "10513 trace name context forever,level 2 : 10512 trace name context forever,level 1: 10511 trace name context forever,level 2: 10510 trace name context forever,level 1"
  memory_target            = 33G
  control_files            = "+DATA/sgerp5/controlfile/current.256.802493563"
  control_files            = "+DATA/sgerp5/controlfile/current.257.802493563"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  log_archive_dest_1       = "location=/oraarch"
  log_archive_format       = "ARC_ERP5_%s_%r_%t.log"
  db_create_file_dest      = "+DATA"
  db_recovery_file_dest    = "+DATA"
  db_recovery_file_dest_size= 30G
  _allow_resetlogs_corruption= TRUE
  undo_management          = "AUTO"
  undo_tablespace          = "UNDOTBS2"
  undo_retention           = 25200
  recyclebin               = "OFF"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  distributed_lock_timeout = 300
  session_cached_cursors   = 100
  audit_file_dest          = "/u01/app/admin/sgerp5/adump"
  audit_trail              = "NONE"
  db_name                  = "sgerp5"
  open_cursors             = 1000
  diagnostic_dest          = "/u01/app"
Thu Dec 20 15:59:30 2012
PMON started with pid=2, OS id=5505366
Thu Dec 20 15:59:30 2012
PSP0 started with pid=3, OS id=6750250
Thu Dec 20 15:59:30 2012
VKTM started with pid=4, OS id=6357448 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Dec 20 15:59:30 2012
GEN0 started with pid=5, OS id=6225962
Thu Dec 20 15:59:30 2012
DIAG started with pid=6, OS id=5833028
Thu Dec 20 15:59:30 2012
DBRM started with pid=7, OS id=6619136
Thu Dec 20 15:59:30 2012
DIA0 started with pid=8, OS id=6029482
Thu Dec 20 15:59:30 2012
MMAN started with pid=9, OS id=5898644
Thu Dec 20 15:59:30 2012
DBW0 started with pid=10, OS id=5571036
Thu Dec 20 15:59:31 2012
LGWR started with pid=11, OS id=6095300
Thu Dec 20 15:59:31 2012
CKPT started with pid=12, OS id=5963824
Thu Dec 20 15:59:31 2012
SMON started with pid=13, OS id=4980912
Thu Dec 20 15:59:31 2012
RECO started with pid=14, OS id=4784458
Thu Dec 20 15:59:31 2012
RBAL started with pid=15, OS id=4522434
Thu Dec 20 15:59:31 2012
ASMB started with pid=16, OS id=6291644
Thu Dec 20 15:59:31 2012
MMON started with pid=17, OS id=3801432
NOTE: initiating MARK startup
Thu Dec 20 15:59:31 2012
MMNL started with pid=18, OS id=4391380
Starting background process MARK
ORACLE_BASE from environment = /u01/app
Thu Dec 20 15:59:32 2012
MARK started with pid=19, OS id=3604896
Thu Dec 20 15:59:32 2012
ALTER DATABASE   MOUNT
NOTE: MARK has subscribed
Thu Dec 20 15:59:32 2012
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=129.100.253.147)(PORT=1521))))' SCOPE=MEMORY SID='sgerp5';
NOTE: Loaded library: System
SUCCESS: diskgroup DATA was mounted
NOTE: dependency between database sgerp5 and diskgroup resource ora.DATA.dg is established
Successful mount of redo thread 1, with mount id 3583555236
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Thu Dec 20 15:59:51 2012
alter database open
Thu Dec 20 15:59:51 2012
Thread 1 opened at log sequence 5
  Current log# 5 seq# 5 mem# 0: +DATA/sgerp5/onlinelog/group_5.413.802538863
  Current log# 5 seq# 5 mem# 1: +DATA/sgerp5/onlinelog/group_5.414.802538867
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Dec 20 15:59:51 2012
SMON: enabling cache recovery
[5111954] Successfully onlined Undo Tablespace 11.
Undo initialization finished serial:0 start:58880806 end:58881470 diff:664 (6 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Thu Dec 20 15:59:54 2012
QMNC started with pid=25, OS id=5767648
Completed: alter database open

 

 

 

 参考：http://www.askmaclean.com/archives/ora-6004194%E9%94%99%E8%AF%AF%E4%B8%80%E4%BE%8B.html

SQL> alter system set event='10513 trace name context forever,level 2 : 10512 trace name context forever,level 1: 10511 trace name context forever,level 2: 10510 trace name context forever,level 1' scope=spfile;
System altered.

/* 10513事件用以阻止SMON在启动数据库后执行事务恢复(transaction recovery) */
/* 10512事件用以阻止SMON shrink rollback segment */
/* 10511事件用以阻止SMON check to cleanup undo dictionary */
/* 10500事件用以阻止SMON check to offline pending offline rollback segment */

SQL> alter system set undo_management=MANUAL scope=spfile;
System altered.

SQL> shutdown immediate;
ORA-03113: end-of-file on communication channel

SQL> startup mount;
ORACLE instance started.

Total System Global Area 2634022912 bytes
Fixed Size                  2086288 bytes
Variable Size            2382367344 bytes
Database Buffers          234881024 bytes
Redo Buffers               14688256 bytes
Database mounted.
SQL> alter database open;

Database altered.

SQL>  create undo tablespace undoc datafile size 300M;

SQL> alter system set undo_management=AUTO scope=spfile;
System altered.

SQL>  alter system set undo_tablespace=undotbs2 scope=spfile;
System altered.

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

Total System Global Area 2634022912 bytes
Fixed Size                  2086288 bytes
Variable Size            2382367344 bytes
Database Buffers          234881024 bytes
Redo Buffers               14688256 bytes
Database mounted.

SQL> alter database open;
Database altered.

/* 通过重建undo表空间可以避免一些4194错误，但不是全部 */
/* 这个库目前处于随时会crash的不可控状态，我们必须要导出数据并导入到新库中 * /
/* 这种情况下direct方式 可能可以规避一些意外错误 */
[maclean@rh2 dump]$ exp maclean/maclean file=full_maclean.dmp owner=maclean  direct=y statistics=none