Home > Veritas Storage Foundation™ for Oracle Manual Pages
VXCKPTADM (1) |
|
User Commands |
Table of contents
vxckptadm - manage Storage Checkpoint and Storage Rollback
vxckptadm -i dbid
vxckptadm -c checkpoint_name file-spec
vxckptadm -A checkpoint_file file-spec
vxckptadm -t checkpoint_name
vxckptadm -s mount_point checkpoint_name
vxckptadm [ -a checkpoint_prefix file-spec]
vxckptadm [ -k ]
vxckptadm [ -n checkpoint_name ] file-spec
vxckptadm [ -l [ -z ] | -g | -m ] file-spec
vxckptadm [ [ -N ] [ -F atomic | serial ] | -r ]
checkpoint_name file-spec
vxckptadm -U mount-point -C checkpoint_name file-spec
vxckptadm -M mount-point
-C checkpoint_name[:new_checkpoint ]
[ -W ] file-spec
vxckptadm -Q show | on | off file-spec
vxckptadm -p #threads checkpoint_name [ -x buffsz ]
listfile logfile dbid
vxckptadm -d ckpt_policyname ckpt_metadata_policy
vxckptadm -e mvsckpt_operation
where file-spec = -f listfile | file-system-path
This command is part of Veritas Storage Foundation for Databases.
To determine whether Veritas Storage Foundation for Oracle is
installed on an \1 system, enter:
lslpp -L VRTSdbed
To determine whether Veritas Storage Foundation for DB2 is
installed on an \1 system, enter:
lslpp -L VRTSdb2ed
The vxckptadm utility is not an end-user supported utility and
should not be run by users.
The CLI interfaces to this command, allowing management of Storage Checkpoints.
The vxckptadm utility is used for creating, mounting,
unmounting, removing, and
reporting information on Storage Checkpoints. Information about
the current state of database files, tablespaces, and file
systems is also saved for use by the SFDB repository.
The following options are supported:
-
-i dbid
-
Initializes the SFDB database for the supplied
dbid argument. The dbid argument specifies the
database name.
-
-c checkpoint_name
-
Checks the validity of the named Storage Checkpoint over
the specified files or list of files.
-
-A checkpoint_file file-spec
-
Shows Storage Checkpoint information (such as read/write, complete/partial,
and the Storage Checkpoint name) for the Storage Checkpoints specified
in the supplied Storage Checkpoint list file.
-
-t checkpoint_name
-
Returns the creation timestamp for the specified Storage Checkpoint.
-
-s mount_point checkpoint_name
-
Displays statistics for the specified Storage Checkpoint for a specified mount point.
-
-a checkpoint_prefix
-
Specifies the prefix to be used when naming a Storage Checkpoint. The
default prefix is Checkpoint_. The SFDB repository
only recognize the default prefix. Specifying a different prefix may cause
the SFDB repository to fail.
-
-k
-
Prints the current time of day as an integer.
-
-n checkpoint_name
-
Creates the specified Storage Checkpoint
on file systems where the supplied files or list of files reside.
This is the default option for vxckptadm if no options are
specified.
-
file-spec
-
A placeholder for -f listfile | file-system-path.
Most vxckptadm commands require that a list of files be processed or a list file containing a list of files be specified. The -f option specifies the name of a file containing a list of files to be processed or the file system path.
-
-l
-
Lists Storage Checkpoints associated with the specified files
or list of files.
-
-z
-
Used with the -l option only. Displays a list of Storage Checkpoints
and the file system that they reside on for the specified files or list of
files.
-
-g
-
Displays a list of mount points, file types, and file information for
the specified files or list of files.
-
-m
-
Displays a list of mount points for all the containers/datafiles
listed in the listfile or in a single file. Note that if two
or more containers/datafiles in the listfile are in the same
file system, then that mount point is displayed only once.
-
-N
-
Specifies that the Storage Checkpoint being created should
not be removed if the file system runs out of space. The
default behavior is for Storage Checkpoints to be removed
when a file system encounters an ENOSPC condition.
-
-F atomic | serial
-
Specifies the file system Storage Checkpoint mechanism to use.
The atomic option is the default and specifies that
a Storage Checkpoint will be created for all file systems
in a single operation. The serial option specifies
that a Storage Checkpoint will be created for file systems
in a serial fashion. Note: The serial option has
been deprecated and is for debugging purposes only.
-
-r
-
Removes the named Storage Checkpoint from the file systems
where the specified files or list of files reside.
-
-U mount-point
-
Unmounts a Storage Checkpoint from the specified mountpoint.
-
-C checkpoint_name
-
Specifies the Storage Checkpoint to mount or unmount.
-
-M mount-point
-
Mounts a Storage Checkpoint on the specified
mountpoint.
-
-W
-
Specifies that the Storage Checkpoint should be mounted
in read/write mode. Read-only mode is the default mount
option for Storage Checkpoints.
-
-Q show | on | off
-
Shows, enables, or disables fileset quotas for the
specified file systems. File systems contained in
Storage Checkpoints mounted as read/write will inherit
the quota attributes of the corresponding primary file
systems.
-
-p #nthreads checkpoint_name
-
Rolls back to the specified Storage Checkpoint, using
#nthreads
number of concurrent threads to process
the specified files.
-
-x buffsz
-
Specifies the buffer size for reads and writes when rolling
back to a Storage Checkpoint.
-
-d ckpt_policyname ckpt_metadata_policy
-
The -d ckpt_policyname option specifies an
allocation policy to assign to Storage Checkpoint data. The
-d ckpt_metadata_policy option specifies
an allocation policy to assign to Storage Checkpoint metadata.
If the specified ckpt_policyname does not exist in the database, an
error message will be returned. Cloned Storage Checkpoints inherit
the same allocation policies assigned to the original Storage
Checkpoint.
-
-e mvsckpt_operation
-
Executes Storage Checkpoint policy operations on behalf of
DBAs with system administrator privileges. The following
Storage Checkpoint operations are available:
-
-e list file_spec
-
Displays the definitions of all Storage Checkpoint allocation
policies defined in a file system.
-
-e define ckpt_policyname mount_point
-
volname1 volname2 volname3
Defines a new Storage Checkpoint allocation policy in a file system with
specified volumes. Data allocation is done in the order in which the volumes
are specified in the allocation policy.
-
-e assignckpt ckpt_name ckpt_data_policyname
-
ckpt_metadata_policyname file_spec
Assigns a Storage Checkpoint allocation policy to a specified Storage Checkpoint.
-
-e delete ckpt_policyname file_spec
-
Deletes the specified Storage Checkpoint allocation policy.
-
-e query ckpt_policyname file_spec
-
Displays the definition of a Storage Checkpoint allocation policy.
-
-e queryvset file_spec
-
Displays the volume set information for the file system.
-
-e queryfs file_spec
-
Displays the Storage Checkpoint allocation policies assigned to a file system.
-
-e queryckpt ckpt_name file_spec
-
Displays the Storage Checkpoint allocation policy assigned to a specified Storage Checkpoint.
Database Administrators frequently have one or more levels of
symbolic links in their file systems to assist in managing
database configuration and organization.
vxckptadm
may not necessarily be able to resolve and recover these symbolic
links when attempting to rollback changes to data. This is
certainly the case when recovering across mount points.
In order to ensure that data is recovered from a Storage Checkpoint,
it is the user's responsibility to ensure that all symbolic
links between the database's view of the datafile and the actual
file on disk are resolved.
Quick I/O symbolic links are supported if the symbolic links and the
files that they point to are on the same VxFS file system.
For Oracle:
dbed_ckptcreate(1M),
dbed_ckptdisplay(1M),
dbed_ckptmount(1M),
dbed_ckptplan(1M),
dbed_ckptpolicy(1M),
dbed_ckptquota(1M),
dbed_ckptremove(1M),
dbed_ckptrollback(1M),
dbed_ckptumount(1M),
dbed_clonedb(1M),
dbed_update(1M),
oracle_edition(7)
Veritas Storage Foundation for Oracle Administrator's Guide
For DB2:
db2ed_ckptcreate(1M),
db2ed_ckptdisplay(1M),
db2ed_ckptmount(1M),
db2ed_ckptpolicy(1M),
db2ed_ckptquota(1M),
db2ed_ckptremove(1M),
db2ed_ckptrollback(1M),
db2ed_ckptumount(1M),
db2ed_ckptcreate_all(1M),
db2ed_ckptdisplay_all(1M),
db2ed_ckptmount_all(1M),
db2ed_ckptremove_all(1M),
db2ed_ckptrollback_all(1M),
db2ed_ckptumount_all(1M),
db2ed_ckptupdate_all(1M),
db2ed_clonedb(1M),
db2_edition(7)
Veritas Storage Foundation for DB2 Administrator's Guide
Last updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.