Controlfile autobackup vs manual backup (include current controlfile vs backup current controlfile)
Hi
19.14
I was wondering, is there any difference regarding restoration perspective.
Ofcourse, controlfile autobackup includes spfile also (others probably not). But if we leave this aside. Is there any reason why to prefer one to another..?
run { backup incremental level 0 database FORMAT '..' plus archivelog FORMAT '..' include current controlfile; } vs run { backup incremental level 0 database FORMAT '..' plus archivelog FORMAT '..'; backup current controlfile; } vs # Having controlfile autobackup on previously "CONFIGURE CONTROLFILE AUTOBACKUP ON;" run { backup incremental level 0 database FORMAT '..' plus archivelog FORMAT '..'; }
Regards
Raul