Cisco Cisco Broadband Access Center for Cable 4.0
7-4
Cisco Broadband Access Center for Cable Administrator’s Guide
OL-2445-02
Chapter 7 Database Management
Backup and Recovery
Backup and Recovery
The RDU server supports a highly efficient backup process that can be performed without stopping the
server or suspending any of its activities. Database backup and recovery involves these stages:
server or suspending any of its activities. Database backup and recovery involves these stages:
•
Backup—takes a snapshot of the RDU database from a live server
•
Recovery—prepares the database snapshot for re-use
•
Restore—copies the recovered database snapshot to the RDU server
Automated tools are provided for each of these steps. You can use these tools in either interactive mode
or silent mode, but you must have root privileges to use the tools.
or silent mode, but you must have root privileges to use the tools.
Database Backup
Backup is the process of copying the database files into a backup directory. The files can then be
compressed and placed on tape or other archive.
compressed and placed on tape or other archive.
RDU database backup is highly efficient because it involves just copying files without interrupting
server activity. However, because it involves accessing the RDU database disk, backup may adversely
affect RDU performance. The opposite is also true. RDU activity happening during backup will
adversely affect backup performance. Therefore, you should perform backups during off-peak hours.
server activity. However, because it involves accessing the RDU database disk, backup may adversely
affect RDU performance. The opposite is also true. RDU activity happening during backup will
adversely affect backup performance. Therefore, you should perform backups during off-peak hours.
Other than concurrent system activity, backup performance also depends on the underlying disk and file
system performance. Essentially, backup will perform as fast as database files can be copied from source
to target.
system performance. Essentially, backup will perform as fast as database files can be copied from source
to target.
Performing Database Backup
You use the backupDb.sh command, in the <BPR_HOME>/rdu/bin directory, to perform database
backups.
backups.
To use this command, you must provide the target directory where the backup files will be placed. This
directory should be on a disk or partition that has available disk space equivalent to 120% of the current
database file size.
directory should be on a disk or partition that has available disk space equivalent to 120% of the current
database file size.
As illustrated in the following example, this command automatically creates a time stamped
subdirectory, under the directory you specify and places the backups there.
subdirectory, under the directory you specify and places the backups there.
Examples
Here is an example of using the backupDb.sh command:
backupDb.sh /var/backup
Where:
•
/var/backup—identifies the database backup directory.
In this example, all backup database files are stored in a directory called /var/backup/rdu-backup-
09252002-130345. The last subdirectory (rdu-backup- 09252002-130345) is automatically created with
a current timestamp.
09252002-130345. The last subdirectory (rdu-backup- 09252002-130345) is automatically created with
a current timestamp.
Note
The timestamped subdirectory format used is rdu-backup-MMddyyyy-HHmmss. In this example, the
subdirectory would be rdu-backup-04272003-175430 meaning that the directory contains a backup that
was started at 5:54:30 pm on April 27, 2003.
subdirectory would be rdu-backup-04272003-175430 meaning that the directory contains a backup that
was started at 5:54:30 pm on April 27, 2003.