I'm trying to restore a cold backup from 9/22 in RMAN. Some background:
I was asked to refresh the test database from production on 9/22. The customer
made changes in the refreshed test database and now wants the original copy
restored over the current one (and will want the current one restored over the
restored one next Wednesday - but that's not important to our story at this
point).
So, checking database incarnations, I get the following:
RMAN> list incarnation of database krontest;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
385267 385744 KRONTEST 3642924242 PARENT 9891435779640 DEC-19-2014
11:33:48
385267 385268 KRONTEST 3642924242 CURRENT 9892229737239 MAR-11-2015
14:57:56
5345868 5345905 KRONTEST 3656204346 PARENT 9892407843669 MAR-24-2015
21:57:45
5345868 5345869 KRONTEST 3656204346 CURRENT 9894011234916 AUG-10-2015
10:09:00
7158792 7158829 KRONTEST 3659933678 PARENT 9892407843669 MAR-24-2015
21:57:45
7158792 7158793 KRONTEST 3659933678 CURRENT 9894493888061 SEP-22-2015
14:04:33
7197538 7197575 KRONTEST 3660013367 CURRENT 9892407843669 MAR-24-2015
21:57:45
7197538 7197539 KRONTEST 3660013367 ORPHAN 9894493888061 SEP-23-2015
12:12:40
Originally, the last one was CURRENT, but I've tried restoring several times
and RMAN seems confused now. Anyway, the RMAN restore script I'm trying to use
is:
set dbid 3660013367;
reset database to incarnation 7197575;
run {
allocate channel notarget1 device type 'sbt_tape' PARMS
'SBT_LIBRARY=/opt/simpana/Base/libobk.so,BLKSIZE=1048576';
restore controlfile from 'c-3659933678-20150922-00' ;
alter database mount;
restore database until time = "TO_DATE('09/22/2015 20:30:55','MM/DD/YYYY
HH24:MI:SS')" ;
release channel notarget1;
recover database noredo ;
alter database open resetlogs;
}
The result is that the controlfiles are restored without an issue, but when it
tries to restore the rest of the data files, it gets an error:
oracle@krontest2:KRONTEST>rman target / catalog rman/XXXXXXXXXXX@rmanprod
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Oct 9 10:39:28 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: KRONTEST (not mounted)
connected to recovery catalog database
RMAN> set dbid 3660013367;
executing command: SET DBID
reset database to incarnation 7197575;
database name is "KRONTEST" and DBID is 3660013367
run {
RMAN>
allocate channel notarget1 device type 'sbt_tape' PARMS
'SBT_LIBRARY=/opt/simpana/Base/libobk.so,BLKSIZE=1048576';
restore controlfile from 'c-3659933678-20150922-00' ;
alter database mount;
restore database until time = "TO_DATE('09/22/2015 20:30:55','MM/DD/YYYY
HH24:MI:SS')" ;
database reset to incarnation 7197575
release channel notarget1;
RMAN> 2> 3> 4> 5> 6> 7> 8> recover database noredo ;
9> alter database open resetlogs;
10> }
allocated channel: notarget1
channel notarget1: SID=134 device type=SBT_TAPE
channel notarget1: CommVault Systems for Oracle: Version 10.0.0(BUILD116)
Starting restore at OCT-09-2015 10:39:37
channel notarget1: restoring control file
channel notarget1: restore complete, elapsed time: 00:00:38
output file name=/oracle/data/KRONTEST/control01.ctl
output file name=/oracle/data/KRONTEST/control02.ctl
output file name=/oracle/data/KRONTEST/mirror_files/control03.ctl
Finished restore at OCT-09-2015 10:40:15
database mounted
Starting restore at OCT-09-2015 10:40:20
released channel: notarget1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/09/2015 10:40:20
RMAN-00600: internal error, arguments [8714] [] [] [] []
RMAN>
I've open and SR with Oracle, but I'm getting a lot of heat from the customer
as he needs this restored to this particular backup for a training class and he
"can't reschedule" it. I'm not an RMAN guru by any means. To further
complicate things, the backups are done via CommVault.
I appreciate any help! Thank you.
Scott Canaan '88 (srcdco@xxxxxxx<mailto: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
