Database Administration (MOSC)

MOSC Banner

Few questions regarding flashback database

edited Aug 18, 2020 5:02AM in Database Administration (MOSC) 11 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center