Cisco Cisco Unified Customer Voice Portal 11.0(1)

Database Recovery

Unified CVP database recovery returns the database to the state of the most recent complete
backup. For example, if the user schedules a backup at 01:00 and restores the database at 23:00,
the same day, the restored database is in the state it was in at 01:00.

Even though the Reporting Server can operate in partial mode, if the database is offline, Cisco
recommends stopping the Reporting Server during a database restore to ensure the database is
able to control all system resources to minimize the time it takes to complete the database restore.

Note: Data loss will occur if the Reporting Server is turned off and the message bus exceeds
its temporary persistence capabilities.

1. Before the restore, disable scheduled tasks (backup, purge).

2. After the restore, re-enable scheduled tasks.

How to Perform a Complete Database Restore

The following task effects a complete restore of the full database if performed on the original
database server. It assumes that the backup was performed through Unified CVP.

Go to Windows Services and stop the Informix IDS Service

At the command line type: ontape –r

Answer the prompts with the following answers:

a.

Continue Restore? y

b.

Do you want to back up the logs? n

c.

Restore a level 1 archive? n

d.

Do you want to restore log tapes? n

After the program terminates, wait at least 5 minutes. At the command prompt, check the status
of Informix by typing : onstat -

a.

If it returns 'IBM Informix Dynamic Server Version 10.00.xxx-- Fast Recovery…' then
wait another 5 minutes and recheck the status by typing: onstat -(10.00.xxx where xxx is
the database subversion number).

Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)