Mounting a database

Figure 11-9: mount command

Graphic showing a server connected to one device. After you run a mount command, the server is connected to two devices, and there is an entry in the manifest file describing the event.

Use the mount command to add the information for devices and other attributes for the database to the destination or secondary Adaptive Server. The mount command decodes the information in the manifest file and makes the set of databases available online. All the required supporting activities are done, including adding database devices if not present and activating them, creating the catalog entries for the new databases, recovering them, and putting them online. When you mount databases onto an Adaptive Server:

NoteRemember that if you use the unmount command, the database is removed from the original Adaptive Server with its information on attributes, device names, and so on.

Syntax:

mount all from <manifest_file>

For example:

1> mount database all from "/work2/Devices/Mpubs_file"
2> go

Redo pass of recovery has processed 1 committed and 0 aborted transactions.
MOUNT DATABASE: Completed recovery of mounted database 'pubs2'

Once the mount is completed, the database is still offline. Use the online database command to bring the database online. You do not have to restart the server.