Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
sridharreddy_d Absent Member.
Absent Member.
2161 views

create oracle duplicate database using RMAN-OMNIBACK tape backup

hi all,
I am creating the duplicate database(on developement machine) from target database(production server) using RMAN auxiliary.
The restoration is done from vendor specific tape backup(omniback/dataprotector).

when I run the following script..

rman << EOF
connect target user-prod/pass-prod@ers;
connect catalog rman/rman@ersoms;
connect auxiliary ers/password@ersdev;
run {
allocate auxiliary channel dev_1 type 'SBT_TAPE'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=name>)';
set newname for datafile 1 to '/u01/oradata/ersdev/system01.dbf';
set newname for datafile 2 to '/u03/oradata/ersdev/undotbs01.dbf';
...
...
...
set newname for datafile 160 to '/u07/oradata/ersdev/undotbs02.dbf';
duplicate target database to ERSDEV;
}
EOF
..
..
..
the output is..

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>
connected to target database: ERS (DBID=4019861429)

RMAN>
connected to recovery catalog database

RMAN>
connected to auxiliary database: ersdev (not mounted)
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19>.....
allocated channel: dev_1
channel dev_1: sid=12 devtype=SBT_TAPE
channel dev_1: Data Protector A.05.50/PHSS_34495/PHSS_34496/DPSOL_002
06

executing command: SET NEWNAME
executing command: SET NEWNAME
..
..
..
Starting Duplicate Db at 28-AUG-06

printing stored script: Memory Script
{
set until scn 57286942883;
set newname for datafile 1 to
"/u01/oradata/ersdev/system01.dbf";
set newname for datafile 2 to
"/u03/oradata/ersdev/undotbs01.
..
..
..
}
executing script: Memory Script

executing command: SET until clause

executing command: SET NEWNAME
..
..
..
channel dev_1: starting datafile backupset restore
channel dev_1: specifying datafile(s) to restore from backup set
restoring datafile 00137 to /u09/oradata/ersdev/ers_indx03.dbf
released channel: dev_1
RMAN-00571: =========================================================
==
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============
==
RMAN-00571: =========================================================
==
RMAN-03002: failure of Duplicate Db command at 08/28/2006 21:02:46
RMAN-03015: error occurred in stored script Memory Script
ORA-19507: failed to retrieve sequential file, handle="ERSDB1_RMAN_ER
S1_Weekly<599561329:1>.dbf", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Vendor specific error: OB2_StartObjectRestoreFullName() failed ERR
(-2)

RMAN>
Recovery Manager complete.

Tags (1)
0 Likes
6 Replies
Pablo Salazar Absent Member.
Absent Member.

Re: create oracle duplicate database using RMAN-OMNIBACK tape backup

Hi,

Do you have a solution for this???

We have the same problem.

REgards,

Saber lo que uno busca, es vivir con la conviccion de saber lo que uno es.
0 Likes
Joe Profaizer Absent Member.
Absent Member.

Re: create oracle duplicate database using RMAN-OMNIBACK tape backup

And we just ran into the same exact issue. Any suggestions/solutions is greatly appreciated.

Thanks,

..Joe
0 Likes
sintex Absent Member.
Absent Member.

Re: create oracle duplicate database using RMAN-OMNIBACK tape backup

Hi!

Did somebody found the solution? May be this error appears because tape drive requested by current restore session is busy by another task?
0 Likes
Zoran Popovic Absent Member.
Absent Member.

Re: create oracle duplicate database using RMAN-OMNIBACK tape backup

I have the same issue (DP 6.1 + 1st set of patches) - it definitely coincides with waiting for free device in the session report (which shouldn't normally be an issue).
0 Likes
Rico Steinhilpe Absent Member.
Absent Member.

Re: create oracle duplicate database using RMAN-OMNIBACK tape backup

Has anybody a solution ?
0 Likes
Ivan Ferreira Absent Member.
Absent Member.

Re: create oracle duplicate database using RMAN-OMNIBACK tape backup

 Just in case someone needs this information in the future, the problem in our case for
OB2_StartObjectRestoreFullName() was locked devices and media.

 

You should ensure that there are no locked devices or media related to this restore. You can use the following commands:

 

Kill any hang process on the OS.

 

Check and release locked devices with:

 

omnidbutil -show_locked_devs
omnidbutil -free_locked_devs

 

Cheers.

 

Por que hacerlo dificil si es posible hacerlo facil? - Why do it the hard way, when you can do it the easy way?
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.