1 / 3

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

Online Databases S. Krzywdzinski, V. Sirotenko February 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

john
Download Presentation

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

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 < 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 -> documentation -> database % of read requests satisfied by cache data buffer (> 95%) % of PL/SQL code executed from library cache

  3. 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 • FPD_ONL , status: in use on d0on • Luminosity DB • DB, status: schema ready • LumReader, status: under development • LumPusher, status: under development • SMT_MONITORING, status: under development • EPICS_ARCHIVING, status: under development DB Applications

More Related