Well, it is not possible to recover DB from an incremental backup alone.
You MUST restore the last full backup and all incremental backups taken
after the last full. It is much simpler to restore only the last full
backup and apply the logs. That is possible if you have daily full
backups w/o any incremental backups. The problem with such strategy is
storage, not the duration of the full backup which takes longer than the
incremental. That doesn't matter since the standby is not open and is
not doing anything for the end users. Nobody will suffer because you're
running backup from standby. The storage problem can be resolved by
deduplication. If the OP's backup software supports deduplication, and
pretty much every backup suite does support it, his subsequent full
backups will take as much space as an incremental.
On 5/13/21 10:01 AM, Jared Still wrote:
Hi Mladen,--
Please explain:
Also, if you plan on running incremental backups, which I don't
consider a good idea,
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Oracle ACE Alumni
Pythian Blog http://www.pythian.com/blog/author/still/ <http://www.pythian.com/blog/author/still/>
Github: https://github.com/jkstill ;<https://github.com/jkstill>