Few questions regarding flashback database
Hi
Oracle Enterprise Linux 7
2 node RAC database 19.6 with standby present.
On primary:
- We are doing incremental level 0 backups once a week, incremental level 1 backups every night (except when we are doing lvl 0).
- We are doing archivelog backups multiple (4-5) times a day.
On standby:
- We are not backing up archivelogs to external location and we are executing archivelog delete script few times a day. So basically on standby site, archivelogs are deleted after they have been applied on standby database.
Every time we do backups on primary we execute commands with "backup archivelog all .. delete all input". So this would mean that all archivelogs in FRA location, that have been synced to our standby database, are eligible for deletion after these are backed up to external location.