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 off-line, Cisco
recommends stopping the Reporting Server during a database restore to ensure that the database
is able to control all system resources in order 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.

Note: In what follows, ??? is used in place of the specific database subversion.

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.??? -- Fast Recovery…' then
wait another 5 minutes and recheck the status by typing: onstat -

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