Re: RMAN Question

From: Ram Cheruvattath <ram.cheruvattath_at_gmail.com>
Date: Wed, 12 Aug 2015 12:04:30 -0400
Message-ID: <557F4D4729DA43A78D6D8E37E71E6855_at_RAMPC>

it looks like you are using CommVault simpana as the media manager. Have you checked the CommVault logs on the database server? It may be that the channel configuration needs adjustment?

From: Scott Canaan
Sent: Wednesday, August 12, 2015 11:46 AM To: fmhabash_at_gmail.com ; oracle-l_at_freelists.org Subject: RE: RMAN Question

I’ve tried to specify the incarnation:  

run {

allocate auxiliary channel notarget1 device type 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/simpana/Base/libobk.so,

ENV=(CvClientName=vmora00a6,CvSrcClientName=advcdevl2,CvInstanceName=Instance001),

BLKSIZE=1048576'; allocate auxiliary channel notarget2 device type 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/simpana/Base/libobk.so,

ENV=(CvClientName=vmora00a6,CvSrcClientName=advcdevl2,CvInstanceName=Instance001),

BLKSIZE=1048576'; set dbid= 2710053647;

set until time = "TO_DATE(' 08/11/2015 01:20:49','MM/DD/YYYY HH24:MI:SS')" ;

duplicate database 'ADVCDEVL' incarnation 5388219 to 'LNXRTEST' noredo;

release channel notarget1;

release channel notarget2;

}  

And the result was:  

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 08/12/2015 11:38:09

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-06026: some targets not found - aborting restore

RMAN-06024: no backup or copy of the control file found to restore  

RMAN>   Scott Canaan ’88 (srcdco_at_rit.edu)

(585) 475-7886 – work                (585) 339-8659 – cell 

“Life is like a sewer, what you get out of it depends on what you put into it.” – Tom Lehrer  

From: fmhabash_at_gmail.com [mailto:fmhabash_at_gmail.com] Sent: Wednesday, August 12, 2015 11:43 AM To: Scott Canaan; oracle-l_at_freelists.org Subject: RE: RMAN Question    

RMAN recovery assumes restore/recovery operations to fall within the current incarnation branch. If your time/scn/sequence# falls into a different branch, you need to tell rman so via ‘reset database to incarnation …’ then perform your operation.  

Please retry and confirm.  

Thank You    

From: Scott Canaan
Sent: Wednesday, August 12, 2015 8:27 AM To: oracle-l_at_freelists.org
Subject: RMAN Question    

We are relatively new to using RMAN here. I have a scenario that I just can’t figure out how to get around. The background is this:  

• I refreshed a development database (in noarchivelog mode) from a production database (in archivelog mode)
• As part of the refresh, an RMAN “register database” was done
• Later in the day, I got a request to pull 2 tables from the backup of the original development database
• I tried to “refresh” the development database backup (from prior to the most recent “register database”) to another test database

Here are the incarnations of the database I’m trying to get a copy of:  

RMAN> list incarnation of database ADVCDEVL;    

List of Database Incarnations

DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

• ------- -------- ---------------- --- ---------- ----------

311695 311726 ADVCDEVL 2688488336 PARENT 9890186150348 16-SEP-14 311695 311696 ADVCDEVL 2688488336 CURRENT 9891412859057 10-DEC-14 5388186 5388219 ADVCDEVL 2710053647 PARENT 9892407817392 24-MAR-15 5388186 5388187 ADVCDEVL 2710053647 CURRENT 9894043390847 11-AUG-15   RMAN>   Here is the RMAN script that I’m trying to use:  

run {

allocate auxiliary channel notarget1 device type 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/simpana/Base/libobk.so,

ENV=(CvClientName=vmora00a6,CvSrcClientName=advcdevl2,CvInstanceName=Instance001),

BLKSIZE=1048576'; allocate auxiliary channel notarget2 device type 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/simpana/Base/libobk.so,

ENV=(CvClientName=vmora00a6,CvSrcClientName=advcdevl2,CvInstanceName=Instance001),

BLKSIZE=1048576'; set until time = "TO_DATE(' 08/11/2015 01:00:03','MM/DD/YYYY HH24:MI:SS')" ;

duplicate database 'ADVCDEVL' to 'LNXRTEST' noredo;

release channel notarget1;

release channel notarget2;

}  

For the TO_DATE, I’ve tried both the beginning and the ending times of the backup (this is the beginning time) and I get the same results:

Errors in memory script

RMAN-03015: error occurred in stored script Memory Script

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20208: UNTIL CHANGE is before RESETLOGS change

RMAN-03015: error occurred in stored script Memory Script

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20208: UNTIL CHANGE is before RESETLOGS change

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 08/12/2015 08:18:45

RMAN-05501: aborting duplication of target database  

RMAN>   I agree that the UNTIL CHANGE is before RESETLOGS change, but that’s exactly what I want. How do I get around this?    

Scott Canaan ’88 (srcdco_at_rit.edu)

(585) 475-7886 – work                (585) 339-8659 – cell 

“Life is like a sewer, what you get out of it depends on what you put into it.” – Tom Lehrer      

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 12 2015 - 18:04:30 CEST