Database Software

Dear all,

Got the following error while creating RMAN auxiliary database using DATA PROTECTOR to restore from tape.

RMAN> CONNECT TARGET *
2> CONNECT CATALOG *
3> CONNECT AUXILIARY *
4>
5> run {
6> allocate auxiliary channel 'dev_0' type 'sbt_tape'
7> parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2APPNAME=UAT,OB2BARLIST=1270532070,OB2BARHOSTNAME=xxx.xxx.com)';
8>
9>
10> duplicate target database to 'TST';
11>
12> }
13>
14> EXIT
connected to target database: UAT (DBID=2738990626)

connected to recovery catalog database

connected to auxiliary database: TST (not mounted)
.
.

contents of Memory Script:
{
set until scn 269185447;
set newname for datafile 1 to
"/backup/oratst/db/apps_st/data/system01.dbf";
set newname for datafile 2 to
"/backup/oratst/db/apps_st/data/system02.dbf";
.
.
"/backup/oratst/db/apps_st/data/appstssummary011.dbf";
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

.
.

executing command: SET NEWNAME

Starting restore at 06-APR-10

channel dev_0: starting datafile backupset restore
channel dev_0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /backup/oratst/db/apps_st/data/system01.dbf
.
. ORA-19870: error reading backup piece rman_full_online_104_uat<UAT_14:715603353:1>.dbf
ORA-19507: failed to retrieve sequential file, handle="rman_full_online_104_uat<UAT_14:715603353: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)
failover to previous backup

.
.

COMPLETED Media Agent "HP:Ultrium 4-SCSI_1"

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/backup/oratst/db/apps_st/data/system01.dbf'

released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/06/2010 11:16:00
RMAN-03015: error occurred in stored script Memory Script
RMAN-20506: no backup of archivelog found
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 62 lowscn 269177994 found to restore

Recovery Manager complete.
[Major] From: ob2rman@reeldev.ramky.com "UAT" Time: 04/06/10 11:18:43
The database reported error while performing requested operation.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/06/2010 11:16:00
RMAN-03015: error occurred in stored script Memory Script
RMAN-20506: no backup of archivelog found
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 62 lowscn 269177994 found to restore

Recovery Manager complete.


please suggest me what i miss or how to solve?


thanks
sandeep.

Edited by: user2584435 on Apr 6, 2010 2:37 PM