The manifest file is the binary file that describes the databases that are present on a set of database devices. It can be created only if the set of databases that occupy those devices are isolated, and self-contained on those devices.
Use the create manifest file command to create a manifest file, which you need to run the quiesce database command for mounting and unmounting databases.
For more information, see “Using mount and unmount commands” in the “Backup and Recovery Plan” chapter of System Administration Guide, Volume 2.
Creates a manifest file for one or more databases.
create manifest file database_list to manifest_file_name
database_list – is the list of databases for which you are creating a manifest file.
manifest_file_name – is the name of the manifest file you are creating. Enclose full path names in quotes.
Example 1 Creates a manifest file for the database big_database in the current directory:
create manifest file big_database to big_database_manifest
Example 2 Creates a manifest file for the databases big_database, medium_database, and small_database:
create manifest file big_database, medium_database, small_database to '/sybase/data/database_manifest'
You cannot run create manifest file within a transaction.
You cannot include system databases in the database_list.
You cannot run create manifest file in a high availability system that is in a transient (failover or failback) state.
You cannot include a database in the database_list that resides on a disk that is shared by another database that is not included in the manifest file list.
You cannot create a manifest file for an archived database.
You must have the sa_role or oper_role to run create manifest file.
create manifest file is audited by audit event number 116.
