Database and NCEDC Archive

Support

	Monitoring	Database	DART	VSM	Data Distribution	Metadata	Misc.
Continuously	-Database replication -Database server logs -DART latency -Database data import status -Web services status -EW wave & SWS servers status -Disks & running processes

	Monitoring	Database	DART	VSM	Data Distribution	Metadata	Misc.
Daily	-Database backups -[Oracle] Database tablespaces size -VSM disks & tapes status -DART archiving -New DART BG stations -Catalog snapshot -IRIS/SIS metadata updates -AWS Cloud data import -Misc. daily cron jobs

	Monitoring	Database	DART	VSM	Data Distribution	Metadata	Misc.
Weekly							-Event merging process

	Monitoring	Database	DART	VSM	Data Distribution	Metadata	Misc.
Monthly		-[Oracle] Backup files clean up	-Log files clean up		-Metrics gathering and processing. Log files cleanup

	Monitoring	Database	DART	VSM	Data Distribution	Metadata	Misc.
Quarterly		-[Oracle] Patching (ucbdb-test, ncdb2, ncdb1) (Example)	-Based on patching schedule, switch DART instances between mnlons1/2 (MP data) and ucbns1/2 (latency data)				-Based on patching schedule, switches NCEDC services access

	Monitoring	Database	DART	VSM	Data Distribution	Metadata	Misc.
Yearly		-[Oracle] WF partitions maintenance (Example)	-Log files archival	-Add new partitions (cache, disks & tape library). Update configuration files (Example) - Log files archival			-ER/Studio license renewal -Update NCEDC Holdings document -AWS Cloud setup

	Monitoring	Database	DART	VSM	Data Distribution	Metadata	Misc.
Routinely		-[Oracle] Resolve replication conflicts -Resolve server issues -[Oracle] WF/HT/IR partitions maintenance (e.g. new network) -Users, objects privileges maintenance -Database optimization -Tablespaces allocation -Schema documentation updates (ER/Studio) -[Oracle] DDL updates(Example) -[PostgreSQL] DDL updates	-Configure systems for new network or new station -Switch sites between manual QC and automatic archiving -Resolve archiving issues -Recover potential lost data	-Process and archive out of band data -New datasets archival -SAM & DB tapes Recycling -Configure next available tape for a given set -Perform routine disk (moving archive sets) and tape maintenance -Plan and configure VSM for new data sets (e.g. new network) -Resolve archiving issues and perform eventual data recovery from secondary storage -Update erroneous parameters in MiniSEED files	-Metrics database import and analysis	-Local metadata import into SIS and QC -Local metadata processing and QC (XML approach) -IRIS metadata processing -SIS metadata processing -NCSN spreadsheet processing -NSMP spreadsheet processing -Dataless V0 files processing	-NCEDC Archive Size Estimation -PWS mapping maintenance -EEW channel files maintenance -Site map maintenance -Leap seconds management -Jiggle event locks management -AQMS timing tallies -BDSN stations tallies -Waveform collection for new events