RMAN Restore Problem
Date: Fri, 09 Oct 2015 15:03:41 +0000
Message-id: <3653B77DCF6DDA4ABAD1E9416F1876D75864FB30_at_ex03mail01.ad.rit.edu>
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_at_krontest2:KRONTEST>rman target / catalog rman/XXXXXXXXXXX_at_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.ctlFinished 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_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 Fri Oct 09 2015 - 17:03:41 CEST