Operating System - HP-UX
1753270 Members
5089 Online
108792 Solutions
New Discussion юеВ

restoring oracle9 database.

 
Mark Ferencak
Frequent Advisor

restoring oracle9 database.

afternoon all.
Please can you assist we are trying to restore an oracle9 database using rman on omniback5.1
we get the following errors .see below.
Note we have stopped and started deamons run omnidbcheck but still get these errors.
Filesystem restores correctly.

wblvh143:none:/app/oracle/admin/oms/udump> cat sbtio.log

SBT-4562 (?) 11/21/06 08:32:30 [Major] From: OB2BAR@wblvh143.telkom.co.za "oms" Time: 11/21/06 08:32:30

Query incomplete/failed ([12:1115] Internal Database is probably corrupt.

Please run omnidbcheck!)



SBT-4562 (?) 11/21/06 08:32:30 [SBT_Query_for_objects] Exiting with (-1), msg: OB2_QueryObjectVersions() failed, ob2erro

r=0: Details unknown.

SBT-4562 (?) 11/21/06 08:32:30 [sbtrestore] Exiting with (-1), msg: SBT_Query_for_objects(...) call failed

, ob2error=0: Details unknown.

SBT-4562 (?) 11/21/06 08:32:30 [sbtopen] Exiting with (-1), msg: Error in sbtopen(), ob2error=0: Details unknown.

SBT-4562 (?) 11/21/06 09:08:16 [Major] From: OB2BAR@wblvh143.telkom.co.za "oms" Time: 11/21/06 09:08:16

Cannot read DBSM message ([12:1012] Cannot access the file.)



SBT-4562 (?) 11/21/06 09:08:21 [Major] From: OB2BAR@wblvh143.telkom.co.za "oms" Time: 11/21/06 09:08:21

Cannot write to DBSM (Interprocess communication problem.)



SBT-4562 (?) 11/21/06 09:08:26 [Major] From: OB2BAR@wblvh143.telkom.co.za "oms" Time: 11/21/06 09:08:26

Cannot write to DBSM (Interprocess communication problem.)



SBT-4562 (?) 11/21/06 09:08:31 [Major] From: OB2BAR@wblvh143.telkom.co.za "oms" Time: 11/21/06 09:08:31

Cannot write to DBSM (Interprocess communication problem.)



SBT-4562 (?) 11/21/06 09:08:31 [SBT_Query_for_objects] Exiting with (-1), msg: OB2_QueryObjectsPartName() failed, ob2err

or=1011: Interprocess communication problem.

SBT-4562 (?) 11/21/06 09:08:31 [sbtrestore] Exiting with (-1), msg: SBT_Query_for_objects(...) call failed

, ob2error=1011: Interprocess communication problem.

SBT-4562 (?) 11/21/06 09:08:31 [sbtopen] Exiting with (-1), msg: Error in sbtopen(), ob2error=1011: Interprocess communi

cation problem.

SBT-4562 (?) 11/21/06 09:14:37 [Major] From: OB2BAR@wblvh143.telkom.co.za "oms" Time: 11/21/06 09:14:37

Cannot write to DBSM (Interprocess communication problem.)



SBT-4562 (?) 11/21/06 09:14:42 [Major] From: OB2BAR@wblvh143.telkom.co.za "oms" Time: 11/21/06 09:14:42

Cannot write to DBSM (Interprocess communication problem.)



SBT-4562 (?) 11/21/06 09:14:47 [Major] From: OB2BAR@wblvh143.telkom.co.za "oms" Time: 11/21/06 09:14:47

Cannot write to DBSM (Interprocess communication problem.)



SBT-4562 (?) 11/21/06 09:14:52 [Major] From: OB2BAR@wblvh143.telkom.co.za "oms" Time: 11/21/06 09:14:52

Cannot write to DBSM (Interprocess communication problem.)



SBT-4562 (?) 11/21/06 09:14:52 [SBT_Query_for_objects] Exiting with (-1), msg: OB2_QueryObjectsPartName() failed, ob2err

or=1011: Interprocess communication problem.

SBT-4562 (?) 11/21/06 09:14:52 [sbtrestore] Exiting with (-1), msg: SBT_Query_for_objects(...) call failed

, ob2error=1011: Interprocess communication problem.

SBT-4562 (?) 11/21/06 09:14:52 [sbtopen] Exiting with (-1), msg: Error in sbtopen(), ob2error=1011: Interprocess communi

cation problem.

SBT-9781 (?) 11/21/06 09:53:14 [Major] From: OB2BAR@wblvh143.telkom.co.za "oms" Time: 11/21/06 09:53:14

Query incomplete/failed ([12:1115] Internal Database is probably corrupt.

Please run omnidbcheck!)



SBT-9781 (?) 11/21/06 09:53:14 [SBT_Query_for_objects] Exiting with (-1), msg: OB2_QueryObjectVersions() failed, ob2erro

r=0: Details unknown.

SBT-9781 (?) 11/21/06 09:53:14 [sbtrestore] Exiting with (-1), msg: SBT_Query_for_objects(...) call failed

, ob2error=0: Details unknown.

SBT-9781 (?) 11/21/06 09:53:14 [sbtopen] Exiting with (-1), msg: Error in sbtopen(), ob2error=0: Details unknown.


4 REPLIES 4
Coolmar
Esteemed Contributor

Re: restoring oracle9 database.

It looks like your Omniback/DP database is corrupt, not your Oracle database. Please see the following link, it might help.

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=969171&admit=-682735245+1164117405353+28353475
Mark Ferencak
Frequent Advisor

Re: restoring oracle9 database.

Coolmar.

The backup was taken on omniback5.5
According to the local engineer we wont be able to restore on 5.1.

Calandrello
Trusted Contributor

Re: restoring oracle9 database.

Friend
Backup of this base was made with the base in begin? for what I am seeing the base was copied opened for the error that presents.
Mark Ferencak
Frequent Advisor

Re: restoring oracle9 database.

would the database being backed up on a higher version of omniback not be the problem?