Online Databases S. Krzywdzinski, V. Sirotenko February 14, 2002

1
Online DatabasesS. Krzywdzinski, V.
SirotenkoFebruary 14, 2002

• Oracle 8i Server, release 8.1.7.2
• Development DB d0on, server on d0olb, 105 (41)
  users, 11Gb allocated, 2Gb used, 35Gb disk
  space available, RAID-1
• Production DB d0onprd, server on d0olc, 64 (19)
  users, 30Gb allocated, 11Gb used, 79Gb disk space
  available, RAID-1
• Backup 71Gb available, 73 full, every night,
  d0onprd (rman and export), d0on (rman), keep last
  3 (2) backups for d0onprd (d0on).
• Recent DBA activity
• complete recovery test of d0on oracle software,
  patches, network/admin setup, database instance,
  rman data loaded from backup tape took 12 hours
  (Dec 01).
• migration test moved d0on server from node
  d0olb to d0ola and back, took lt 30 min each way
  (Feb 02).
• Plan to move d0onprd to dedicated d0ola for good.
• databases cleanup relocated cal_calib indexes,
  changed storage parameters
• checked security vulnerability turn off extproc
  on both d0onprd, d0on databases
• Application software test version of DCOracle2
  with Python 2.x is available on OSF1, Linux and
  Windows NT

2
D0onprd Performance Monitoringonline_computing
-gt documentation -gt database
of read requests satisfied by cache data buffer
(gt 95)
of PL/SQL code executed from library cache
3
DB Applications

• HDB Epics
• DB, status in use
• HDB Batch Utilities, status in use
• WebHDB status in use
• RUNS
• DB, status in use
• RunsWWW interface, status in use
• RunGrabber status in use
• RunPusher status in use
• Transfer calibration data from online DB to
  offline DB
• onl_calDbTransfer, status in use
• Calibration/Electronic DB
• CAL_CALIB, on d0onprd
• SMT_CALIB, on d0onprd
• CFT_CALIB, on d0onprd
• MUO_CALIB, on d0on