|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: |
TRACE LOG alert_rcat.log /u01/app/oracle/diag/rdbms/rcat/rcat/trace
---------------------
alter database "rcat" open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 531401
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x83900490] [PC:0x86E4932, knl_get_min_req_scn()+6]
Errors in file /u01/app/oracle/diag/rdbms/rcat/rcat/trace/rcat_ora_3963.trc (incident=1345):
ORA-07445: exception encountered: core dump [knl_get_min_req_scn()+6] [SIGSEGV] [ADDR:0x83900490] [PC:0x86E4932] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/rcat/rcat/incident/incdir_1345/rcat_ora_3963_i1345.trc
Sat Jul 11 13:46:27 2009
ALERT LOG log.xml /u01/app/oracle/diag/rdbms/rcat/rcat/alert
----------------
<msg time='2009-07-11T13:46:20.103-04:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:2935:4222364190' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='bd11g'
host_addr='127.0.0.1' module='sqlplus@bd11g (TNS V1-V3)' pid='3963'>
<txt>alter database "rcat" open resetlogs
</txt>
</msg>
<msg time='2009-07-11T13:46:20.283-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='bd11g' host_addr='127.0.0.1' module='sqlplus@bd11g (TNS V1-V3)'
pid='3963'>
<txt>RESETLOGS after incomplete recovery UNTIL CHANGE 531401
</txt>
</msg>
<msg time='2009-07-11T13:46:20.379-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='bd11g' host_addr='127.0.0.1' module='sqlplus@bd11g (TNS V1-V3)'
pid='3963'>
<txt>Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x83900490] [PC:0x86E4932, knl_get_min_req_scn()+6]
</txt>
</msg>
<msg time='2009-07-11T13:46:22.145-04:00' org_id='oracle' comp_id='rdbms'
msg_id='63653510' type='INCIDENT_ERROR' group='Access Violation'
level='1' host_id='bd11g' host_addr='127.0.0.1'
prob_key='ORA 7445 [knl_get_min_req_scn()+6]' upstream_comp='' downstream_comp=''
ecid='' errid='1345' detail_path='/u01/app/oracle/diag/rdbms/rcat/rcat/trace/rcat_ora_3963.trc'>
<txt>Errors in file /u01/app/oracle/diag/rdbms/rcat/rcat/trace/rcat_ora_3963.trc (incident=1345):
ORA-07445: exception encountered: core dump [knl_get_min_req_scn()+6] [SIGSEGV] [ADDR:0x83900490] [PC:0x86E4932] [Address not mapped to object] []
</txt>
</msg>
<msg time='2009-07-11T13:46:22.310-04:00' org_id='oracle' comp_id='rdbms'
msg_id='dbgexProcessError:1097:3370026720' type='TRACE' level='16'
host_id='bd11g' host_addr='127.0.0.1'>
<txt>Incident details in: /u01/app/oracle/diag/rdbms/rcat/rcat/incident/incdir_1345/rcat_ora_3963_i1345.trc
</txt>
</msg>
DBCA TRACE LOG trace.log /u01/app/oracle/cfgtoollogs/dbca/rcat
------------------------
[Thread-10] [14:8:9:116] [UIHost.getHtmlSummary:1055] UIHost:getHtmlSummary: running createTemplateDocument NOT for SHOW_TEMPLATE condition
[Thread-10] [14:8:9:125] [UIHost.getHtmlSummary:1061] UIHost:getHtmlSummary: after running createTemplateDocument NOT for SHOW_TEMPLATE condition
[Thread-10] [14:8:9:133] [XSLConst.generateHeaderXSL:211] NLS:Template Name:= null
[Thread-10] [14:8:9:134] [XSLConst.generateHeaderXSL:216] Template Description:= Use this database template to create a pre-configured database optimized for general purpose or transaction processing usage.
[Thread-10] [14:8:10:753] [UIHost.getHtmlSummary:1100] UIHost->getHtmlSummary: start printing of transformed document
[TaskScheduler timer] [14:8:12:553] [Host.executeSteps:4426] Executing steps....
[TaskScheduler timer] [14:8:12:554] [Host.setUpForOperation:3198] setUpForOperation: Mode = 128
[TaskScheduler timer] [14:8:12:555] [OsUtilsBase.copyFile:716] OsUtilsBase.copyFile:
[TaskScheduler timer] [14:8:12:578] [Host.executeSteps:4605] setupForOperation returned: true
[TaskScheduler timer] [14:8:12:579] [Host.createStepSQLInterface:6444] sid =rcat
[TaskScheduler timer] [14:8:12:587] [SQLEngine.initialize:253] Execing SQLPLUS/SVRMGR process...
[TaskScheduler timer] [14:8:12:688] [SQLEngine.initialize:281] m_bReaderStarted: false
[TaskScheduler timer] [14:8:12:689] [SQLEngine.initialize:285] Starting Reader Thread...
[Thread-13] [14:8:12:762] [StepContext$ModeRunner.run:2495] ---- Progress Needed:=true
[Thread-13] [14:8:13:511] [BasicStep.execute:202] Executing Step : CLONE_DB_CREATION_RMAN_RESTORE
[Thread-13] [14:8:13:512] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01092
[Thread-13] [14:8:13:513] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01034
[Thread-13] [14:8:13:513] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03114
[Thread-13] [14:8:13:513] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-12560
[Thread-13] [14:8:13:513] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01109
[Thread-13] [14:8:13:513] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-13] [14:8:13:517] [BasicStep.execute:202] Executing Step : INSTANCE_CREATION
[Thread-13] [14:8:13:518] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-13] [14:8:13:530] [InitParamAttributes.sortParams:3575] m_sortOn:-1 sortOn:4
[Thread-13] [14:8:13:569] [InitParamAttributes.createInitFile:1710] Processing init param db_block_size
[Thread-13] [14:8:13:570] [InitParamAttributes.createInitFile:1715] The value is 8192
[Thread-13] [14:8:13:570] [InitParamAttributes.createInitFile:1710] Processing init param open_cursors
[Thread-13] [14:8:13:571] [InitParamAttributes.createInitFile:1715] The value is 300
[Thread-13] [14:8:13:571] [InitParamAttributes.createInitFile:1710] Processing init param db_domain
[Thread-13] [14:8:13:575] [InitParamAttributes.createInitFile:1715] The value is ""
[Thread-13] [14:8:13:576] [InitParamAttributes.createInitFile:1710] Processing init param db_name
[Thread-13] [14:8:13:576] [InitParamAttributes.createInitFile:1715] The value is rcat
...
racle.sysman.assistants.dbca.backend.CloneRmanRestoreStep$ProgressTracker.run(CloneRmanRestoreStep.java:935)
java.lang.Thread.run(Thread.java:595)
[Thread-13] [14:11:43:80] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@19ccb73
[Thread-13] [14:11:43:81] [StepContext$ModeRunner.run:2495] ---- Progress Needed:=true
[Thread-13] [14:11:43:95] [BasicStep.execute:202] Executing Step : CLONE_DB_CREATION
[Thread-13] [14:11:43:95] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01503
[Thread-13] [14:11:43:95] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01109
[Thread-13] [14:11:43:96] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-12712
[Thread-13] [14:11:43:96] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-00942
[Thread-13] [14:11:43:96] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-13] [14:11:43:266] [SQLEngine.spoolOff:1874] Setting spool off = /u01/app/oracle/cfgtoollogs/dbca/rcat/CloneRmanRestore.log
[Thread-13] [14:11:43:266] [SQLEngine.setSpool:1806] old Spool = null
[Thread-13] [14:11:43:266] [SQLEngine.setSpool:1807] Setting Spool = /u01/app/oracle/cfgtoollogs/dbca/rcat/cloneDBCreation.log
[Thread-13] [14:11:43:267] [SQLEngine.setSpool:1808] Is spool appendable? --> true
[Thread-13] [14:11:43:273] [CloneDBCreationStep.executeImpl:342] a.createCtlFileSql = Create controlfile reuse set database "rcat"
MAXINSTANCES 8
Datafile
'/u01/app/oracle/oradata/rcat/system01.dbf',
'/u01/app/oracle/oradata/rcat/sysaux01.dbf',
'/u01/app/oracle/oradata/rcat/undotbs01.dbf',
'/u01/app/oracle/oradata/rcat/users01.dbf'
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/rcat/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/app/oracle/oradata/rcat/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/app/oracle/oradata/rcat/redo03.log') SIZE 51200K RESETLOGS;
[Thread-13] [14:11:44:665] [CloneDBCreationStep.executeImpl:421] calling zerodbid
[Thread-13] [14:11:51:70] [CloneDBCreationStep.executeImpl:431] Shutdown database
[Thread-13] [14:11:51:86] [CloneDBCreationStep.executeImpl:453] Startup ......nomount......
[Thread-13] [14:11:57:598] [CloneDBCreationStep.executeImpl:472] Enabling restricted session.
[Thread-13] [14:11:57:856] [CloneDBCreationStep.executeImpl:474] alter database "rcat" open resetlogs;
[Thread-11] [14:12:3:412] [BasicStep.handleNonIgnorableError:430] oracle.sysman.assistants.util.UIMessageHandler@19ccb73:messageHandler
[Thread-11] [14:12:3:412] [BasicStep.handleNonIgnorableError:431] ORA-03113: end-of-file on communication channel
:msg
[Thread-13] [14:12:8:846] [SQLEngine.done:2014] Done called
[Thread-13] [14:12:8:847] [SQLEngine.spoolOff:1874] Setting spool off = /u01/app/oracle/cfgtoollogs/dbca/rcat/cloneDBCreation.log
[Thread-13] [14:12:8:848] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@19ccb73
[Thread-13] [14:12:8:848] [StepContext$ModeRunner.run:2521] oracle.sysman.assistants.dbca.backend.CloneDBCreationStep.executeImpl(CloneDBCreationStep.java:894)
oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2505)
java.lang.Thread.run(Thread.java:595)
[Thread-13] [14:12:10:157] [SQLEngine.done:2014] Done called
CLONE DB CREATION LOG cloneDBCreation.log /u01/app/oracle/cfgtoollogs/dbca/rcat
-----------------------------------
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1313092 bytes
Variable Size 197134012 bytes
Database Buffers 109051904 bytes
Redo Buffers 6361088 bytes
alter database "rcat" open resetlogs
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 3963
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1313092 bytes
Variable Size 197134012 bytes
Database Buffers 109051904 bytes
Redo Buffers 6361088 bytes
alter database "rcat" open resetlogs
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 7521
|
Advertisement
| Hall of Fame |