Home » RDBMS Server » Backup & Recovery » Restarting dead background process QMN0 (9.2.8.0, Solaris)
Restarting dead background process QMN0 [message #602421] Wed, 04 December 2013 04:43 Go to next message
Sumadhav
Messages: 3
Registered: December 2013
Junior Member
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=5323
Tue Dec 3 20:08:05 2013
Errors in file /app/oracle/admin/test/bdump/test_j000_5379.trc:
ORA-00600: internal error code, arguments: [4193], [14361], [13505], [], [], [], [], []
Tue Dec 3 20:08:06 2013
Doing block recovery for fno: 37 blk: 2845
block recovery range from rba 10931.170.0 to scn 0.826313736
Tue Dec 3 20:08:06 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.170.16, scn:0.826313772
Doing block recovery for fno: 37 blk: 1613
block recovery range from rba 10931.170.0 to scn 0.826318513
Tue Dec 3 20:08:06 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.3533.0, scn:0.826318514
Tue Dec 3 20:08:06 2013
Errors in file /app/oracle/admin/test/bdump/test_j000_5379.trc:
ORA-12012: error on auto execute of job 2
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [14361], [13505], [], [], [], [], []
ORA-06512: at line 18
Tue Dec 3 20:08:11 2013
Errors in file /app/oracle/admin/test/bdump/test_qmn0_5323.trc:
ORA-00600: internal error code, arguments: [4193], [12988], [14152], [], [], [], [], []
Tue Dec 3 20:08:13 2013
Doing block recovery for fno: 37 blk: 352
block recovery range from rba 10931.2157.0 to scn 0.826316587
Tue Dec 3 20:08:13 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.2159.16, scn:0.826316589
Doing block recovery for fno: 37 blk: 85
block recovery range from rba 10931.2157.0 to scn 0.826318520
Tue Dec 3 20:08:13 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.3539.0, scn:0.826318521
Tue Dec 3 20:09:16 2013
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=5393
Tue Dec 3 20:09:26 2013
Errors in file /app/oracle/admin/test/bdump/test_qmn0_5393.trc:
ORA-00600: internal error code, arguments: [4193], [14361], [13505], [], [], [], [], []
Doing block recovery for fno: 37 blk: 2845
block recovery range from rba 10931.170.0 to scn 0.826313736
Tue Dec 3 20:09:28 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.170.16, scn:0.826313772
Doing block recovery for fno: 37 blk: 1613
block recovery range from rba 10931.170.0 to scn 0.826318548
Tue Dec 3 20:09:29 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.3543.0, scn:0.826318549
Tue Dec 3 20:14:45 2013
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=5565
Tue Dec 3 20:16:24 2013
Errors in file /app/oracle/admin/test/bdump/test_qmn0_5565.trc:
ORA-00600: internal error code, arguments: [4193], [12988], [14152], [], [], [], [], []
Doing block recovery for fno: 37 blk: 352
block recovery range from rba 10931.2157.0 to scn 0.826316587
Tue Dec 3 20:16:26 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.2159.16, scn:0.826316589
Doing block recovery for fno: 37 blk: 85
block recovery range from rba 10931.2157.0 to scn 0.826319117
Tue Dec 3 20:16:26 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.3913.0, scn:0.826319118
Tue Dec 3 20:20:39 2013
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=5719
Tue Dec 3 20:20:49 2013
Errors in file /app/oracle/admin/test/bdump/test_qmn0_5719.trc:
ORA-00600: internal error code, arguments: [4193], [14361], [13505], [], [], [], [], []
Doing block recovery for fno: 37 blk: 2845
block recovery range from rba 10931.3920.0 to scn 0.826319209
Tue Dec 3 20:20:51 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
stopped block recovery at EOT rba: 10931.3921.0
completed block recovery at rba:10931.3921.0, scn:0.826319209
Doing block recovery for fno: 37 blk: 1613
block recovery range from rba 10931.3920.0 to scn 0.826319208
Tue Dec 3 20:20:51 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.3921.0, scn:0.826319209
Tue Dec 3 20:26:07 2013
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=6069
Tue Dec 3 20:26:48 2013
Errors in file /app/oracle/admin/test/bdump/test_qmn0_6069.trc:
ORA-00600: internal error code, arguments: [4193], [12988], [14152], [], [], [], [], []
Doing block recovery for fno: 37 blk: 352
block recovery range from rba 10931.2157.0 to scn 0.826316587
Tue Dec 3 20:26:51 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.2159.16, scn:0.826316589
Doing block recovery for fno: 37 blk: 85
block recovery range from rba 10931.2157.0 to scn 0.826319473
Tue Dec 3 20:26:51 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.4053.0, scn:0.826319474
Tue Dec 3 20:31:23 2013
Errors in file /app/oracle/admin/test/bdump/test_j000_6246.trc:
ORA-00600: internal error code, arguments: [4193], [14361], [13505], [], [], [], [], []
Doing block recovery for fno: 37 blk: 2845
block recovery range from rba 10931.3920.0 to scn 0.826319209
Tue Dec 3 20:31:24 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.3920.16, scn:0.826319218
Doing block recovery for fno: 37 blk: 1613
block recovery range from rba 10931.3920.0 to scn 0.826319566
Tue Dec 3 20:31:24 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.4063.0, scn:0.826319567
Tue Dec 3 20:31:24 2013
Errors in file /app/oracle/admin/test/bdump/test_j000_6246.trc:
ORA-12012: error on auto execute of job 27
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [14361], [13505], [], [], [], [], []
ORA-06512: at line 18
Tue Dec 3 20:32:07 2013
Restarting dead background process QMN0
QMN0 started with pid=14, OS id=6252
Tue Dec 3 20:32:46 2013
Errors in file /app/oracle/admin/test/bdump/test_qmn0_6252.trc:
ORA-00600: internal error code, arguments: [4193], [12988], [14152], [], [], [], [], []
Doing block recovery for fno: 37 blk: 352
block recovery range from rba 10931.4191.0 to scn 0.826319759
Tue Dec 3 20:32:48 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
stopped block recovery at EOT rba: 10931.4192.0
completed block recovery at rba:10931.4192.0, scn:0.826319759
Doing block recovery for fno: 37 blk: 85
block recovery range from rba 10931.4191.0 to scn 0.826319758
Tue Dec 3 20:32:48 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10931 Reading mem 0
Mem# 0 errs 0: /ora03/oradata/test/redo11.log
Mem# 1 errs 0: /ora04/oradata/test/redp12.log
completed block recovery at rba:10931.4192.0, scn:0.826319759
Tue Dec 3 20:38:04 2013
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=6363

[Updated on: Wed, 04 December 2013 04:47]

Report message to a moderator

Re: Restarting dead background process QMN0 [message #602422 is a reply to message #602421] Wed, 04 December 2013 04:51 Go to previous messageGo to next message
Sumadhav
Messages: 3
Registered: December 2013
Junior Member
I have recovered the database from a system crash by taking the backup from Tapes. Database Came up normally but getting these errors in the Alert Log File regularly. Please help me on this.

Report message to a moderator

Re: Restarting dead background process QMN0 [message #602428 is a reply to message #602421] Wed, 04 December 2013 05:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Looks like corrupt undo/rbs.
For ORA-0600 errors please search metalink.
A quick search in google did bring be many pages.

Report message to a moderator

Re: Restarting dead background process QMN0 [message #602534 is a reply to message #602428] Thu, 05 December 2013 07:12 Go to previous messageGo to next message
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
Senior Member
Mahesh Rajendran wrote on Wed, 04 December 2013 12:18
Looks like corrupt undo/rbs.
For ORA-0600 errors please search metalink.
A quick search in google did bring be many pages.

Especially look for the ora-600 tool whitin support.oracle.com

Report message to a moderator

Re: Restarting dead background process QMN0 [message #602541 is a reply to message #602534] Thu, 05 December 2013 07:41 Go to previous messageGo to next message
Sumadhav
Messages: 3
Registered: December 2013
Junior Member
Thanks i got the error, need to restore the undotbs file from the backup or create a new undo tablespace. Thanks for your support.

Report message to a moderator

Re: Restarting dead background process QMN0 [message #602889 is a reply to message #602541] Tue, 10 December 2013 02:23 Go to previous message
sukumar.chillakuru
Messages: 2
Registered: August 2013
Junior Member
Check whether all the Datafiles are consistent and not corrupted.

use DBV to check the block corruptions of datafiles.

http://myoracleproduct.blogspot.in/2013/11/fix-undo-block-corruption.html

Report message to a moderator

Previous Topic: Can not recover file
Next Topic: RMAN hot backup plus archivelog files
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 03:00:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.