Oracle database: Cold backup
Prior to deploying the Portal for operational use and periodically after installation (at least once a month is recommended), it is recommended to perform a cold backup of the Oracle database. In addition to monthly cold backups, it is also recommended to take a cold backup after a significant software upgrade to re-capture the updated database schema.
This off-line, cold backup means you physically copy or back up the Oracle database data files to another location. This cold backup will simplify the restore process, in the event of unanticipated data loss. With a cold backup, you simply have to restore the files and then import the most recent database export.
To perform a cold backup (Linux)
- Shutdown the Oracle service:
/opt/aptare/bin/oracle stop
- Using your organization's file system backup software, back up all the data files from:
$ORACLE_HOME/dbs/initscdb.ora /data0?/*
To perform a cold backup (Windows)
- Shut down the Oracle service: OracleServicescdb in the Windows Administrative Tools, Component Services window.
- Backup the following files:
$ORACLE_HOME\dbs\iniscdb.ora C:\oradata
Note:
During installation, you may choose a different drive for the oradata install, so verify its location before backing up the data.