Cisco Cisco Broadband Access Center Telco Wireless 3.8
7-6
Cisco Broadband Access Center for Cable Administrator’s Guide
OL-2445-02
Chapter 7 Database Management
Changing Database Location
Database Restore
Restoring the database is the process of copying the previously recovered database snapshot to the
database location used by the RDU server. Only database that has been previously recovered can be
restored.
database location used by the RDU server. Only database that has been previously recovered can be
restored.
Since restoring the database means replacing the current RDU database, it is very important that you first
properly remove and archive the old database.
properly remove and archive the old database.
Note
Never delete the database you are replacing. Having a copy of old database may simplify future system
diagnostics.
diagnostics.
Performing Database Restore
You use the restoreDb.sh command, located in the <BPR_HOME>/rdu/bin directory, to replace the
current RDU database with another database.
current RDU database with another database.
When using this command, you must specify an input directory. This directory must contain the
recovered backup snapshot of the database to be restored to the RDU server.
recovered backup snapshot of the database to be restored to the RDU server.
Note
Before running the restoreDb.sh utility, you must stop the RDU server.
Examples
Here is an example of running restoreDb.sh utility:
# restoreDb.sh /var/backup/rdu-backup-04272003-130345
In this example, the database found in the /var/backup/rdu-backup-042752003-130345 directory is
restored to the RDU server.
restored to the RDU server.
Note
When using the restoreDb.sh command, you can use a –help option to obtain usage information on the
command.
command.
You must restart the RDU once the restore operation is completed. The RDU log file will contain
successful start up messages.
successful start up messages.
This command displays progress on screen and logs its activity into the history.log file.
Changing Database Location
It may sometimes be necessary to move the database from one partition or disk to another on the same
system for administrative reasons. This process requires stopping the RDU server and the BPR agent.
system for administrative reasons. This process requires stopping the RDU server and the BPR agent.
The process of changing the database location involves changing one or two system parameters and
copying the appropriate files to the new location. You can adjust one or both of the following parameters:
copying the appropriate files to the new location. You can adjust one or both of the following parameters:
•
BPR_DATA—This parameter is initially set during installation and points to a directory that is used
to store the database, and many other important files, such as logs, configuration files, and so on.
to store the database, and many other important files, such as logs, configuration files, and so on.
•
BPR_DBLOG—This parameter is initially set during installation and points to the directory that
stores database transaction log files.
stores database transaction log files.