Databases Reference
In-Depth Information
Table 18-1.
Description of
sbttest
Parameters
Parameter Name
Purpose
backup_file_name
The only required parameter. If this file doesn't exist, the
sbttest
utility will
create it for use during the test and then delete it upon completion.
dbname
The database name that sbt uses to identify the backup file (the default is sbtdb).
trace
The trace file name where the MML software writes diagnostic messages.
remove_before
When specified, the backup file will be deleted before it is opened. This is useful
when a previous run of
sbttest
didn't complete successfully and didn't delete
the backup file.
noremove_after
Instructs
sbttest
to not remove the backup file after successful completion.
read_only
When specified a backup file must already exist. Instructs
sbttest
to validate
the backup file contents.
no_regular_backup_restore
Instructs
sbttest
to skip the nonproxy backup and restore.
no_proxy_backup
Instructs
sbttest
to skip proxy copy backup.
no_proxy_restore
Instructs
sbttest
to skip proxy copy restore.
file_type
File type can be 1, 2, or 3.
copy_number
Specifies the
copy_number
parameter to
sbtpcbackup
.
media_pool
Specifies the
media_pool
parameter to
sbtpcbackup
.
os_res_size
Determines the size of the operating system reserved block (in bytes).
pl_res_size
Determines the size of the platform reserved block (in bytes).
block_size
Determines the size of blocks written to the backup file (default is 16,384 bytes).
block_count
Specifies number of blocks written to backup file (default is 100).
proxy_file
Specifies the operating system file name, backup file name, operating system
reserved size, block size, and block count for the proxy file.
libname
Determines the sbt library to test. The default library is libobk.so. You can
specify oracle.disksbt for Oracle's disk sbt library.
Listed next is an example showing how to specify parameters when running the
sbttest
utility. This example
shows how to limit the number of blocks written to tape to 10:
$ sbttest mml.tst -block_count 10
The next example shows how to store the diagnostic messages in a file named mml.trc:
$ sbttest mml.tst -trace /orahome/mml.trc
You can also test the backup of an existing data file. This example instructs the
sbttest
utility to use an existing
data file with the name of data_ts06.dbf in the BRDSTN database:
$ sbttest data_ts06.dbf -dbname BRDSTN
