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):
ALTER DATABASE ADD LOGFILE group 9 ('+TIER_EIGHT', '+TIER_NINE', '+TIER_TEN', '+TIER_ELEVEN') size 200M;
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

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

Edit | Attach | Watch | Print version | History: r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r1 - 2007-10-19 - RaduStoica
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LHCb All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback