Currently, the standard back-up strategy is to have Oracle create a nightly export file (in a .dmp file format) of all the data in your database. The Assessor is then encouraged to back-up that export file to another media (disk, dvd, tape, etc.) and to periodically store that media off-site. The export process in Oracle also creates a log file, which will provide a status (including any errors) of the export process. At a minimum, the Assessor should be reviewing that log file everyday to ensure that the oracle export ran correctly. For questions on how to check the Oracle export log file please see the FAQ on the CAMA website at:
In addition to checking the Oracle log file, the Assessor should have a continuing conversation with their IT staff about the county’s backup strategy to ensure that the Oracle export file is being adequately backed-up and secured. If the county does not have the support of an IT staff, the Assessor should take the responsibility to ensure that the Oracle export file is backed-up to the tape drive included in their CAMA server.
Remember, the DOR and CCI do not have the ability to reconstitute the Assessor’s database from the replicated DataMart or any other source of data. The only reliable source of backed-up data is the Oracle export/back-up in the Assessor’s office.
If you have any questions, please do not hesitate to contact CCI’s customer support or the Technical Services Group at the Department of Revenue.