RE: RMAN Question
Date: Wed, 12 Aug 2015 16:05:50 +0000
Message-id: <3653B77DCF6DDA4ABAD1E9416F1876D752897D87_at_ex03mail02.ad.rit.edu>
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<mailto: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<mailto:srcdco_at_rit.edu> Sent: Wednesday, August 12, 2015 11:46 AM To: fmhabash_at_gmail.com<mailto:fmhabash_at_gmail.com> ; oracle-l_at_freelists.org<mailto: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 ScriptRMAN-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<mailto: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> [mailto:fmhabash_at_gmail.com] Sent: Wednesday, August 12, 2015 11:43 AM To: Scott Canaan; oracle-l_at_freelists.org<mailto: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<mailto: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<mailto: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-lReceived on Wed Aug 12 2015 - 18:05:50 CEST