This discussion is archived
4 Replies Latest reply: Mar 19, 2013 5:02 AM by Adrian Taplin RSS

Problem with DUPLICATE Database

376519 Newbie
Currently Being Moderated
This is a very long post and I apologize for that:

Rman Script:
[run {
set newname for datafile 'E:\ORACLE\ORADATA\EBIZ01PD\AMWD01.DBF' to 'E:\Oracle\oradata\EBIZBLU\AMWD01.DBF';
set newname for datafile 'E:\ORACLE\ORADATA\EBIZ01PD\AMWX01.DBF' to 'E:\Oracle\oradata\EBIZBLU\AMWX01.DBF';
...
set newname for datafile 'E:\ORACLE\ORADATA\EBIZ01PD\ZXD01.DBF' to 'E:\Oracle\oradata\EBIZBLU\ZXD01.DBF';
set newname for datafile 'E:\ORACLE\ORADATA\EBIZ01PD\ZXX01.DBF' to 'E:\Oracle\oradata\EBIZBLU\ZXX01.DBF';
allocate auxiliary channel ch1 type 'sbt_tape'
PARMS="BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine= RESTORE  -jm 142 -a 2:0 -cl 43 -ins 40 -at 0 -j 44240 -bal 0 -bap 0 -rap 0 -rcp 0 -mav 0 -ms 1 -p 2 -cn nvciEBIZDB_BLUE -vm Instance001 -vm nvciebizdbblu.nvci.org)"
TRACE 2;
set until time = "TO_DATE('09/02/2009 13:08:00','MM/DD/YYYY HH24:MI:SS')" ;
duplicate target database to EBIZBLU
PFILE= E:\Oracle\product\10.2.0\dbs\initEBIZBLU.ora
LOGFILE
GROUP 1
(
'E:\oracle\oradata\EBIZBLU\REDO01A.LOG',
'D:\oracle\oradata\EBIZBLU\REDO01B.LOG'
)  SIZE 70M REUSE,
GROUP 2
(
'E:\oracle\oradata\EBIZBLU\REDO02A.LOG',
'D:\oracle\oradata\EBIZBLU\REDO02B.LOG'
)  SIZE 70K REUSE,
GROUP 3
(
'E:\oracle\oradata\EBIZBLU\REDO03A.LOG',
'D:\oracle\oradata\EBIZBLU\REDO03B.LOG'
)  SIZE 70M REUSE,
GROUP 4
(
'E:\oracle\oradata\EBIZBLU\REDO04A.LOG',
'D:\oracle\oradata\EBIZBLU\REDO04B.LOG'
)  SIZE 70M REUSE
nofilenamecheck
;
}
exit;
]
Rman Log:[

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Sep 2 13:47:30 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN> connect catalog *
2> connect target * connect auxiliary *
3> run {
4> set newname for datafile 'E:\ORACLE\ORADATA\EBIZ01PD\AMWD01.DBF' to 'E:\Oracle\oradata\EBIZBLU\AMWD01.DBF';
5> set newname for datafile 'E:\ORACLE\ORADATA\EBIZ01PD\AMWX01.DBF' to 'E:\Oracle\oradata\EBIZBLU\AMWX01.DBF';
...
86> set newname for datafile 'E:\ORACLE\ORADATA\EBIZ01PD\ZXD01.DBF' to 'E:\Oracle\oradata\EBIZBLU\ZXD01.DBF';
87> set newname for datafile 'E:\ORACLE\ORADATA\EBIZ01PD\ZXX01.DBF' to 'E:\Oracle\oradata\EBIZBLU\ZXX01.DBF';
88> allocate auxiliary channel ch1 type 'sbt_tape'
89> PARMS="BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine= RESTORE -jm 142 -a 2:0 -cl 43 -ins 40 -at 0 -j 44240 -bal 0 -bap 0 -rap 0 -rcp 0 -mav 0 -ms 1 -p 2 -cn nvciEBIZDB_BLUE -vm Instance001 -vm nvciebizdbblu.nvci.org)"
90> TRACE 2;
91> set until time = "TO_DATE('09/02/2009 13:08:00','MM/DD/YYYY HH24:MI:SS')" ;
92> duplicate target database to EBIZBLU
93> PFILE= E:\Oracle\product\10.2.0\dbs\initEBIZBLU.ora
94> LOGFILE
95> GROUP 1
96> (
97> 'E:\oracle\oradata\EBIZBLU\REDO01A.LOG',
98> 'D:\oracle\oradata\EBIZBLU\REDO01B.LOG'
99> ) SIZE 70M REUSE,
100> GROUP 2
101> (
102> 'E:\oracle\oradata\EBIZBLU\REDO02A.LOG',
103> 'D:\oracle\oradata\EBIZBLU\REDO02B.LOG'
104> ) SIZE 70K REUSE,
105> GROUP 3
106> (
107> 'E:\oracle\oradata\EBIZBLU\REDO03A.LOG',
108> 'D:\oracle\oradata\EBIZBLU\REDO03B.LOG'
109> ) SIZE 70M REUSE,
110> GROUP 4
111> (
112> 'E:\oracle\oradata\EBIZBLU\REDO04A.LOG',
113> 'D:\oracle\oradata\EBIZBLU\REDO04B.LOG'
114> ) SIZE 70M REUSE
115> nofilenamecheck
116> ;
117> }
118> exit;
connected to recovery catalog database
connected to target database: EBIZ01PD (DBID=2362778605)
connected to auxiliary database: EBIZBLU (not mounted)

executing command: SET NEWNAME
executing command: SET NEWNAME
...
executing command: SET NEWNAME
executing command: SET NEWNAME

allocated channel: ch1
channel ch1: sid=432 devtype=SBT_TAPE
channel ch1: CommVault Systems for Oracle: Version 7.0.0(BUILD76)

executing command: SET until clause

Starting Duplicate Db at 02-SEP-09

contents of Memory Script:
{
set until scn 2064568337;
set newname for datafile 1 to
"E:\ORACLE\ORADATA\EBIZBLU\SYSTEM01.DBF";
set newname for datafile 2 to
"E:\ORACLE\ORADATA\EBIZBLU\SYSTEM02.DBF";
...
set newname for datafile 418 to
"E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_SUMMARY02.DBF";
set newname for datafile 419 to
"E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_ARCHIVE02.DBF";
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME
executing command: SET NEWNAME
...
executing command: SET NEWNAME
executing command: SET NEWNAME

Starting restore at 02-SEP-09

channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM01.DBF
restoring datafile 00004 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM04.DBF
...
restoring datafile 00414 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_TX_IDX08.DBF
restoring datafile 00417 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_INTERFACE02.DBF
channel ch1: reading from backup piece 61knv3ug_1_1
ORA-19870: error reading backup piece 61knv3ug_1_1
ORA-19507: failed to retrieve sequential file, handle="61knv3ug_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
sbtrestore: Job[44240] thread[3696]: CVArchive->open() failed.
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM02.DBF
restoring datafile 00003 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM03.DBF
...
restoring datafile 00416 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_SEED03.DBF
restoring datafile 00418 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_SUMMARY02.DBF
channel ch1: reading from backup piece 63knv52m_1_1
ORA-19870: error reading backup piece 63knv52m_1_1
ORA-19507: failed to retrieve sequential file, handle="63knv52m_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
sbtrestore: Job[44240] thread[3696]: CVArchive->open() failed.
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM05.DBF
restoring datafile 00006 to E:\ORACLE\ORADATA\EBIZBLU\RBS01.DBF
...
restoring datafile 00415 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_SEED02.DBF
restoring datafile 00419 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_ARCHIVE02.DBF
channel ch1: reading from backup piece 64knv75f_1_1
ORA-19870: error reading backup piece 64knv75f_1_1
ORA-19507: failed to retrieve sequential file, handle="64knv75f_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
sbtrestore: Job[44240] thread[3696]: CVArchive->open() failed.
failover to previous backup

channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM01.DBF
restoring datafile 00004 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM04.DBF
...
restoring datafile 00414 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_TX_IDX08.DBF
restoring datafile 00417 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_INTERFACE02.DBF
channel ch1: reading from backup piece 5sknsfj2_1_1
ORA-19870: error reading backup piece 5sknsfj2_1_1
ORA-19507: failed to retrieve sequential file, handle="5sknsfj2_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
sbtrestore: Job[44240] thread[3696]: CVArchive->open() failed.
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM02.DBF
restoring datafile 00003 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM03.DBF
...
restoring datafile 00416 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_SEED03.DBF
restoring datafile 00418 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_SUMMARY02.DBF
channel ch1: reading from backup piece 5uknsgrl_1_1
ORA-19870: error reading backup piece 5uknsgrl_1_1
ORA-19507: failed to retrieve sequential file, handle="5uknsgrl_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
sbtrestore: Job[44240] thread[3696]: CVArchive->open() failed.
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM05.DBF
restoring datafile 00006 to E:\ORACLE\ORADATA\EBIZBLU\RBS01.DBF
...
restoring datafile 00415 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_SEED02.DBF
restoring datafile 00419 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_ARCHIVE02.DBF
channel ch1: reading from backup piece 5vknshlq_1_1
ORA-19870: error reading backup piece 5vknshlq_1_1
ORA-19507: failed to retrieve sequential file, handle="5vknshlq_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
sbtrestore: Job[44240] thread[3696]: CVArchive->open() failed.
failover to previous backup

channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM01.DBF
restoring datafile 00004 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM04.DBF
...
restoring datafile 00414 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_TX_IDX08.DBF
restoring datafile 00417 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_INTERFACE02.DBF
channel ch1: reading from backup piece 57knq56k_1_1
ORA-19870: error reading backup piece 57knq56k_1_1
ORA-19507: failed to retrieve sequential file, handle="57knq56k_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
sbtrestore: Job[44240] thread[3696]: CVArchive->open() failed.
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM02.DBF
restoring datafile 00003 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM03.DBF
...
restoring datafile 00416 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_SEED03.DBF
restoring datafile 00418 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_SUMMARY02.DBF
channel ch1: reading from backup piece 58knq84o_1_1
ORA-19870: error reading backup piece 58knq84o_1_1
ORA-19507: failed to retrieve sequential file, handle="58knq84o_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
sbtrestore: Job[44240] thread[3696]: CVArchive->open() failed.
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to E:\ORACLE\ORADATA\EBIZBLU\SYSTEM05.DBF
restoring datafile 00006 to E:\ORACLE\ORADATA\EBIZBLU\RBS01.DBF
...
restoring datafile 00415 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_SEED02.DBF
restoring datafile 00419 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_ARCHIVE02.DBF
channel ch1: reading from backup piece 59knq9sv_1_1
ORA-19870: error reading backup piece 59knq9sv_1_1
ORA-19507: failed to retrieve sequential file, handle="59knq9sv_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
sbtrestore: Job[44240] thread[3696]: CVArchive->open() failed.
failover to previous backup

released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/02/2009 13:50:10
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 52 found to restore

Recovery Manager complete.
]IZBLU\APPS_TS_TX_IDX07.DBF
restoring datafile 00415 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_SEED02.DBF
restoring datafile 00419 to E:\ORACLE\ORADATA\EBIZBLU\APPS_TS_ARCHIVE02.DBF
channel ch1: reading from backup piece 59knq9sv_1_1
ORA-19870: error reading backup piece 59knq9sv_1_1
ORA-19507: failed to retrieve sequential file, handle="59knq9sv_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
sbtrestore: Job[44240] thread[3696]: CVArchive->open() failed.
failover to previous backup

released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/02/2009 13:50:10
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 52 found to restore

Recovery Manager complete.
]
  • 1. Re: Problem with DUPLICATE Database
    vasu77 Newbie
    Currently Being Moderated
    Per metalink note,

    Subject: RMAN Duplicate fails with ORA-19870, ORA-19507, ORA-27029 and ORA-19511

    Doc ID: *562780.1*
    ....
    Solution:

    In this case the failing routine:

    ORA-19507: failed to retrieve sequential file,
    handle="RMAN_TRXPRAC_Online<trxp2_88184:646171398:1>.dbf", parms=""
    ORA-27029: skgfrtrv: sbtrestore returned error

    The actual eror is:

    ORA-19511: Error received from media manager layer, error text:
    Vendor specific error: Cannot find requested element ERR(2:OBE_INVARG)

    If you are restoring to a new host there will be additional media manager
    environment variables that need to be set to tell the media manager that a
    backup created on one host, is to be restored to another.

    The specific error: Cannot find requested element ERR(2:OBE_INVARG), is a media manager error, pleas contact your media manager vendor.
    ...

    There looks to be the issues with Media manager.

    Hope this helps.

    Regards,
    Vasu

    Edited by: vasu77 on Sep 2, 2009 3:46 PM
  • 2. Re: Problem with DUPLICATE Database
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Your problem seems to be
    sbtrestore: Job44240 thread3696: CVArchive->open() failed.
    Why has the open called failed repeatedly ? Is the tape drive inaccessible ?


    Hemant K Chitale
  • 3. Re: Problem with DUPLICATE Database
    376519 Newbie
    Currently Being Moderated
    I agree Hemant. It does seem to be this error"sbtrestore: Job44240 thread3696: CVArchive->open() failed." My sysadmins have opened a call with Commault the backup software vendor. I will be talking with them soon.

    In the mean time I have run a RESYNC CATALOG and performed a full backup and tried the DUPLICATE again with the same errors.
  • 4. Re: Problem with DUPLICATE Database
    Adrian Taplin Newbie
    Currently Being Moderated
    Dear Chris,

    did CommVault reply with a work around for the Re: Problem with DUPLICATE Database error you had as we have the same problem

    Thank you

    Adrian

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points