One strategy for making a database
solution highly available is maintaining a primary database to respond
to user application requests, and a secondary or standby database
that can take over database operations for the primary database if
the primary database fails.
Initializing the standby
database entails copying the primary database to the standby database.
Procedure
There are several ways to initialize the standby database.
For example:
- Use disk mirroring to copy the primary database, and use DB2® database suspended I/O support
to split the mirror to create the second database.
- Create a backup image of the primary database and recovery
that image to the standby database.
- Use SQL replication to capture data from the primary database
and apply that data to the standby database.
What to do next
After initializing the standby database, you must configure
your database solution to synchronize the primary database and standby
database so the standby database can take over for the primary database
if the primary database fails.