rman redundancy 1 and RMAN-06024: no backup or copy of the control file found to restore
Date: Sat, 22 Jul 2017 16:06:28 +0200
Message-ID: <62ed09bd-65cb-0f59-1e29-5c495a28e3f8_at_interia.pl>
Hi guys,
I don't know if it's well known behaviour of rman and redundancy 1 but
recenty I've hit RMAN-06024: no backup or copy of the control file found
to restore
when trying to PITR of pdb .
Suppose You do have below backup strategy :
Level 0 on Sunday (to fra)
Level 1 on any other day (to fra) .
So in theory You should be able let's say on friday to do PITR restore
to the Monday level 1 right ?
Not really, when You try :
run {
set until time "to_date('_MONDAY_', 'yyyy-mm-dd:hh24:mi:ss')";
restore pluggable database UAT;
recover pluggable database UAT auxiliary destination='/oracle/staging';
}
You get :
and getting this error :
Automatic instance removed
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 07/19/2017 15:11:19 RMAN-03015: error occurred in stored script Memory ScriptRMAN-06026: some targets not found - aborting restore RMAN-06024: no backup or copy of the control file found to restore
As there is only 1 recent copy of controlfile keep in FRA autobackup
location .
Solution would be setting retension to 5 days .
Regards .
G
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jul 22 2017 - 16:06:28 CEST