| Worksheet ID: |
2489 |
| Record Location: |
11th Floor, Wm. R. Snodgrass TN Tower
312 Rosa L. Parks Avenue |
| File Arrangement: |
Numeric, by case number |
| Media Format Generated: |
Both |
| Media Format Stored: |
Paper/Electronic |
| Date Range: |
1977 to current |
| Annual Accumulation: |
5 cubic feet; 1 gigabyte |
| Current Volume: |
56 cubic feet; 40 gigabytes |
| Record Value: |
Legal |
| Audit Requirements: |
Both |
| Reference Frequency: |
| Current Year per Month: |
10 |
| Past Year: |
7 |
| 2 - 5 Years: |
1 |
| Over 5 Years:
|
1 |
|
| Data Update Frequency: |
Daily |
| Information Shared Outside of State: |
Yes |
| If Shared, List Agencies: |
Environmental Protection Agency |
| Essential Record: |
No |
| Essential Record Stored: |
|
| Essential Record Media Type: |
|
| Confidential: |
No |
| Confidential Legal Citation: |
|
| Media Recommendation: |
Current Format |
| Media Recommendation Other: |
|
| Agency Retention: |
Permanent |
| Agency Retention - Years Active: |
|
| Agency Retention - Years Inactive: |
|
| Records Center Retention Period: |
|
| Final Disposition after Retention Expires: |
Keep as Electronic |
| Legal Citation: |
TCA § 4-5-319 |
| Record Sample: |
No Sample |
| Legal Documentation: |
No Legal Documentation |
| Electronic Records Plan Inventory |
| System Name: |
Oracle Database - Waterlog |
| IT-ABC Number: |
BGWFB-3 |
| Hardware Description: |
Oracle NAS (Networked Attached Storage) managed by STS. Raid 6 system with 40 terrabytes of space. STS Fiber SAN managed by STS. This is the STS mandated storage medium and backed up through Enterprise Backups. |
| Software Description: |
Oracle Database Enterprise 11.2.3 NAS mounted and managed through Windows CIFS (Common Internet File System). Oracle Exports and Hot online backups are used to backup the data SAN storage from where it is backed up to the Enterprise backups. Expected to use .doc, .docs, .xls, .xlx, .pdf, and .tif file formats. |
| System Location: |
STS Data Center South |
| Backup Procedures: |
NAS stores 31 daily snapshots. In addition, full backups are taken monthly with incremental backups taken daily. The monthly backups are stored offsite for 7 years. With both methods considered, we can restore to any of the past 31 days if the file(s) existed during the time of either the snapshot or the backup, to one of the full monthly backups from up to 7 years prior. Oracle Database is run in archive log mode and all redo logs are backed up daily. Hot backup of all data files is done on weekends. |
| Disaster Recovery: |
Recovery Procedure: Helpdesk tickets to STS as "Priority 1" can restore file(s) in 2 hours' time if restoring to a point within the past 31 days. If later (as tapes must come from offsite), expected "Priority 1" recovery time is 5 hours. Major Disaster Recovery: STS has a written policy on how to handle major disaster recovery. In summary: order new hardware if required. Receive, configure and verify setup and connectability. Install required software to restore from image files and/or tapes. Inventory media and image files, restore. |
| Data Migration Description: |
STS maintains and migrates data according to system updates, upgrades and replacement standards per industry standards. Full procedures are available with the Office of Information Resources. |
| Metadata Description: |
Standard New Technology File System (NFTS) metadata. File name must conform to approved TDEC naming convention. Backup metadata is stored in a clustered Microsoft SQL server. |
