Sunday, February 26, 2017

oracle Backup policy


Taleo does 3 actions to backup production zones in its standard backup policy.
Backup data is kept on disk storage.  Backup Policy (Doc ID 1046592.1)

Oracle RMAN

  • Used for short term backups (30 days retention).
  • One full backup a week. For most customers, this is done on Friday or Saturday.
  • Two incremental backups per week, usually on Tuesday / Thursday or on Wednesday / Friday.
  • 6 backups of archive logs (transactions) per day.
  • These backups allows for an exact point in time recovery to be performed.

Oracle Data Pump

  • A full database export usually performed on Friday (weekly).
  • 60 days retention.
  • Copied on Tier 2 (local) and Tier 3 storage locations.

Oracle Data Guard

  • All transactions replicated to physical standby databases in Data Replication sites.

Backup Restoration

  • A database recovery is a billable service and requires a Statement of Work (SOW). Communicate with the Client Success Specialist (CSS / CE) for more information on creating this SOW.
  • During a restore, all data on the target zone is replaced by the backup's. It is not possible to restore only specific entities; the whole schema is replaced when applying the backup.
  • Any change or new data between the time the backup was taken and the moment the restore is applied is lost.

No comments:

Post a Comment