RE: RMAN Question

From: <fmhabash_at_gmail.com>
Date: Fri, 14 Aug 2015 16:51:51 -0400
Message-ID: <55ce54e9.323e320a.941d2.5f7b_at_mx.google.com>

Scott ,
Is the current Dev DB have the same DBID as the one you initially had before the first duplication?

Thank You.

From: Scott Canaan
Sent: Thursday, August 13, 2015 3:35 PM
To: Ram
Cc: fmhabash_at_gmail.com;oracle-l_at_freelists.org Subject: RE: RMAN Question

I am trying to restore a database from advcdevl2 to vmora00a6. That’s in the code below. We’ve done this many times before. The difference is that the database I’m trying to restore from has been restored to from another database and I want a copy from before that “event”. I’m sure that there must be a way to get it, but RMAN is not making it easy. With our previous backup solution (Networker), it didn’t care about “incarnations”. All I had to do was pick the source and the date I wanted and it would give me the last backup made before that date / time.

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 [mailto:ram.cheruvattath_at_gmail.com] Sent: Thursday, August 13, 2015 3:27 PM
To: Scott Canaan
Cc: fmhabash_at_gmail.com; oracle-l_at_freelists.org Subject: Re: RMAN Question

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 Fri Aug 14 2015 - 22:51:51 CEST

This message: [ Message body ]
Next message: fmhabash_at_gmail.com: "RE: RMAN Question"
Previous message: Schauss, Peter (ESS): "Character set conversion and database size"
Maybe in reply to: Scott Canaan: "RMAN Question"
Next in thread: fmhabash_at_gmail.com: "RE: RMAN Question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message