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 Script
RMAN-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
--
//www.freelists.org/webpage/oracle-l