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:
Create redo groups (the assigned thread will be that of the actual instance the session is connected to):
Drop redo logs plus changing and archiving current/active groups:
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


    • 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

This topic: LHCb > WebHome > LHCbOnline > Oracle > Logs
Topic revision: r1 - 2007-10-19 - RaduStoica
This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2021 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback