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@xxxxxxxxxxxxx
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@xxxxxxx)
(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