RE: RMAN Question

From: Scott Canaan <srcdco_at_rit.edu>
Date: Mon, 17 Aug 2015 14:16:38 +0000
Message-id: <3653B77DCF6DDA4ABAD1E9416F1876D7528A32C1_at_ex03mail01.ad.rit.edu>



No, we can’t get it to work because we don’t have the controlfile from just before the backup was taken. I don’t know why RMAN is looking for that file, but it is and we can’t get around it.

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] Sent: Monday, August 17, 2015 10:15 AM
To: Scott Canaan; Ram
Cc: oracle-l_at_freelists.org
Subject: RE: RMAN Question

So, were you able to resolve it? If yes, what was the final resolution. Please.

Thank You.

From: Scott Canaan
Sent: Monday, August 17, 2015 7:49 AM
To: fmhabash_at_gmail.com;Ram<mailto:fmhabash_at_gmail.com;Ram> Cc: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: RE: RMAN Question

What we have found, via a different scenario and verified with this one, is that once we refresh the database from another instance and do another “register database” with RMAN, there are no controlfiles from the previous incarnation available. When we try to restore, it looks for the controlfile just previous to the backup window and it isn’t there. I expect it has something to do with the way CommVault is configured to back things up.

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: Friday, August 14, 2015 4:58 PM
To: Scott Canaan; Ram
Cc: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: RE: RMAN Question

Sorry, send my earlier email prematurely.

Can you please attempt this simple restore scenario as an alternate way to ‘duplicate’ …

Set dbid to to one belonging to the initial dev db before first duplication.

Restore the controlfile

Mount db using restore controlfile

List backup of database

Verify your backups are listed. If they are ,proceed to ‘restore database’ and ‘recover database’.

I’m not sure if you can use duplicate in this scenario to tell rman what CF to restore. I will double-check, however.

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<mailto: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<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 [mailto:ram.cheruvattath_at_gmail.com] Sent: Thursday, August 13, 2015 3:27 PM To: Scott Canaan
Cc: fmhabash_at_gmail.com<mailto:fmhabash_at_gmail.com>; oracle-l_at_freelists.org<mailto: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<mailto: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<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<mailto:fmhabash_at_gmail.com>; oracle-l_at_freelists.org<mailto: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 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<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-l
Received on Mon Aug 17 2015 - 16:16:38 CEST

Original text of this message