Re: Backup on standby database

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>
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com


--
http://www.freelists.org/webpage/oracle-l