copydb/unloaddb Database Backup
A copydb or unloaddb command will create scripts with database object definitions and commands to unload the database or individual tables. The advantage of this approach is that it is self-contained and simple to understand. In addition you can back up a subset of the database. Disadvantages of this backup mechanism are the amount of storage space required to store the resulting data files and the time to perform the unload and reload of the database.
To back up the database:
• Stop the applications accessing the database.
• Run copydb or unloaddb and the associated scripts on the database.
• Resume the applications accessing the database.
To restore the database:
• Stop the applications accessing the database.
• Either drop the database objects, or destroy/create the database.
• Run the scripts to reload the database.
• Resume the applications accessing the database.
For more information, see copydb and unloaddb in the Vector User Guide.