Hi I'm testing (Oracle Enterprise 19) Incrementally Updated Backups using this script with the db in open state:
BACKUP
INCREMENTAL LEVEL 1
FOR RECOVER OF COPY WITH TAG 'incr_update'
DATABASE;
RECOVER COPY OF DATABASE
WITH TAG 'incr_update';
DELETE OBSOLETE;
I'm confused about recovery copy of database command because it is a recovery (so it should made files consistent) but using an hot backup that is inherently inconsistent.
My db runs in archive log mode but the question is, my copy of datafiles after the second command (recover copy .. ) are consistent or they still need archivelog to be restored succesfully like typical rman hot backup?
I know that i need archive log to restore transaction after my incremental backup or any point in time recovery but my question is if after the recovery copy command my copy of datafiles and my autobackup (cf+spfile) are the minimal set of file that I need to restore the db at the moment of the incremental backup command,
I did some test, deleting datafiles, archivelog and online redo log and it seems to work after rman
restore database
and sqlplus
recover database until cancel
alter database open resetlogs;
It recovers all the trasaction before the incremental backup command.
But I want to be sure that this would work by logic 100% of the times.
Thanks
Have a nice day.