Task 10: Performing a Cold Backup of the Database (Linux)
Prior to deploying the Portal for operational use, APTARE recommends that you perform a cold backup of the Oracle database. This offline, cold backup simply means that you’ll physically copy or backup the 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. In addition to this initial cold backup, you may consider performing a cold backup periodically—for example, after a significant software upgrade—to re-capture the database schema.
Recommended Database Backup Process
1. Cold Backup
2. Daily Exports of the database
3. In the event of data loss, restore the database and then import the most recent database export.
Cold Backup Steps
1. Shutdown the Oracle service:
/opt/aptare/bin/oracle stop
2. Backup the files from the following locations:
$ORACLE_HOME\dbs\initscdb.ora
/data01/*
/data02/*
/data03/*
Once the Portal is deployed and in use, the database can be exported as a backup copy. See the APTARE StorageConsole System Administrator’s Guide.