Specifying the database and dump device

At a minimum, all dump and load commands must include the name of the database being dumped or loaded. Commands that dump or load data (rather than just truncating a transaction log) must also include a dump device.

Table 12-4 shows the syntax for backing up and loading a database or log.

Table 12-4: Indicating the database name and dump device

Backing up a database or log

Loading a database or log

Database name

dump {database | tran}   database_name

load {database | tran}   database_name

Compress (supported for backward compatibility)

 to   [compress::[compression_level::]]

 from [compress::]

Dump device

   stripe_device

    stripe_device

  [at backup_server_name]   [density = density,    blocksize = number_bytes,    capacity = number_kilobytes,    dumpvolume = volume_name,    file = file_name]  [stripe on   [compress::[compression_level::]]   stripe_device   [at backup_server_name]   [density = density,    blocksize = number_bytes,    capacity = number_kilobytes,    dumpvolume = volume_name,    file = file_name] ...]  [with{    density = density,    blocksize = number_bytes,    capacity = number_kilobytes,    compression = compress_level,    dumpvolume = volume_name,    file = file_name,    [nodismount | dismount],    [nounload | unload],    retaindays = number_days,    [noinit | init],    passwd = password,    standby_access    [notify = {client |       operator_console}]}]

  [at backup_server_name]   [density = density,    blocksize = number_bytes,    dumpvolume = volume_name,    file = file_name]  [stripe on   [compress::]stripe_device   [at backup_server_name]   [density = density,    dumpvolume = volume_name,    file = file_name] ...]  [with{    density = density,    blocksize = number_bytes,    dumpvolume = volume_name,    file = file_name,    [nodismount | dismount],    [nounload | unload],    passwd = password,    [notify = {client |      operator_console}]    until_time = datetime}]]