Configuration for RAC01-RAC04:

Redo logs:

• • Configuration: Redo logs are split across 4 TIERs for redundancy: 8,9,10 and 11.
  • Size: 200 MB. Will be adjusted according to the requirements.
  • Various commands:

ALTER DATABASE ADD LOGFILE group 9 ('+TIER_EIGHT', '+TIER_NINE', '+TIER_TEN', '+TIER_ELEVEN') size 200M;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group <nr>.

Archive logs:

• • The archive destinations are the tiers 8, 9, 10, 11
  • Four archive processes running

Backups:

• • One full backup per week, backups run as an oracle job.
  • Backup stored with amanda. The directory used by the amanda client is $ORACLE_HOME/backup.
  • Backup can be restored on ora01.
  • Backup sets used, includes there the spfile and controlfile;
  • spfile raw disk also backed up with dd.
  • voting disk backed up with dd
  • ocr disk backed up with dd and ocrdump
  • Retention policy: 15 days (more than 2 full backups). Might change if to much space is required.
  • TODO: Add RMAN configuration plus scripts.

Flashback :

• • 15 days (bigger than 2 full backups). Might change if to much space is required.
  • TODO: Set individual flashback policies based on tablespaces.

-- RaduStoica - 19 Oct 2007