Example of procedure for restoring an Informix database
This example shows the procedure for restoring an Informix database from the original source computer, camel, to the destination computer, giraffe. For this example, the redirected restore is necessary because the original computer, camel, failed. You also can use a redirected restore to duplicate your Informix database in a development or in a test environment.
This example assumes the following:
Source client camel is a Solaris computer that is running Informix.
SERVERNUM is 6
DBSERVERNAME is srcdb
Host name is camel
Destination client giraffe is a Solaris computer that is running Informix.
SERVERNUM is 0
DBSERVERNAME is destdb
Host name is giraffe
NetBackup master server is lion. The bp.conf on camel includes SERVER=lion.
If SERVER=lion were not the first server in the bp.conf file, then the environment variable INFXBSA_SERVER on camel you would set to lion, as follows:
export INFXBSA_SERVER=lion
Previously you performed the onbar -b Informix database backup on camel.
Previously you performed a file system backup of $INFORMIXDIR/etc on camel, which effectively backed up the following:
ixbar.6
sqlhosts
onconfig
oncfg_srcdb.6
You salvaged the logical logs on camel by using the following command:
onbar -l -s
To redirect an Informix restore (Example)
- As the NetBackup administrator, create the following file on the NetBackup server, lion:
/usr/openv/netbackup/db/altnames/giraffe
- Add the name camel to the file.
- Log into giraffe as Informix ownerId and ensure that the Informix database server is shut down.
- Perform a manual file system backup of $INFORMIXDIR/etc on giraffe.
Including the following files:
ixbar.0
sqlhosts
onconfig
oncfg_destdb.0
Note that this step is a precautionary measure. It is performed in case these configuration files are needed to recreate the environment on giraffe. This backup is not used for the redirected restore.
- On giraffe, change the Informix server environment variable to match the variable on camel.
Use the following command:
export INFORMIXSERVER=srcdb
- On giraffe, change the INFXBSA_CLIENT environment variable to camel.
For example:
export INFXBSA_CLIENT=camel
This causes giraffe to browse backups from camel.
- (Conditional) On giraffe, set the INFXBSA_SERVER environment variable to lion.
For example:
export INFXBSA_SERVER=lion
This step is needed only if the first server that is specified in the bp.conf file on giraffe is not lion.
- Browse the file system backups from camel and restore to $INFORMIXDIR/etc on giraffe.
Restore the following files:
ixbar.6
sqlhosts
onconfig
oncfg_destdb.6
- Perform the redirected restore to giraffe.
Complete the following steps:
To perform the physical restore, run the following command:
onbar -r -p
Verify the return status by using the following command:
echo $?
If the restore was successful, the return status is 0.
To perform the logical restore run the following command
onbar -r -l
Verify the return status by using the following command:
echo $?
If the restore was successful, the return status is 0.
- On the destination client (giraffe), start the database.