Re: RMAN Question

From: Ram <ram.cheruvattath_at_gmail.com>
Date: Thu, 13 Aug 2015 15:27:27 -0400
Message-Id: <8714C9AE-A76E-4351-A75C-EAFE2D290872_at_gmail.com>



What is the name of the server where the old db was backed up from? Also, what is the name of the server you are attempting the restore from?

Sent from my iPhone

> On Aug 12, 2015, at 12:05 PM, Scott Canaan <srcdco_at_rit.edu> wrote:
>
> Yes, we are using CommVault as the backup manager. The channel configuration works for all of the other restores / refreshes.
>
> 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: Ram Cheruvattath [mailto:ram.cheruvattath_at_gmail.com]
> Sent: Wednesday, August 12, 2015 12:05 PM
> To: Scott Canaan; fmhabash_at_gmail.com; oracle-l_at_freelists.org
> Subject: Re: RMAN Question
>
> 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 Thu Aug 13 2015 - 21:27:27 CEST

Original text of this message