test veritas logo


dbdst_report(1M)

NAME

dbdst_report - displays either the policy information or the audit information which are reported on the specified dates.

SYNOPSIS

dbdst_report -S ORACLE_SID -o policy

dbdst_report -S ORACLE_SID -o audit [startdate=<time_in_secs | YYYY-MM-DD>, enddate=<time_in_secs | \YYYY-MM-DD>]

dbdst_report -S ORACLE_SID -o audit [startdate=<YYYY-MM-DD>] | [enddate= <\YYYY-MM-DD>]

AVAILABILITY

Veritas Storage Foundation. To determine whether this product is installed on a Linux system, enter:

rpm -qa | grep VRTSdbed

DESCRIPTION

The dbdst_report command is used to display policy information, which consists of plan name, plan type, rule name, directory, and rule description or to display TSDB reported audit information based on the specified dates. If no date is specified, all audit information will be displayed.

OPTIONS

The following options are supported:
-S ORACLE_SID Specifies the name of the Oracle database for which information will be retrieved.
-o policy Specifies to display policy information.
-o audit Specifies to display all of the reported audit information in the repository.
-o audit [startdate=<time_in_secs | YYYY-MM-DD>,
 
  enddate=<time_in_secs | \YYYY-MM-DD>]
  Specifies to display audit information reported based specified start date and end date. Dates can be specified in UNIX time stamp (the number of seconds between a particular date and the Unix Epoch), or in date format of YYYY-MM-DD.
-o audit [startdate=<YYYY-MM-DD>] | [enddate= <\YYYY-MM-DD>]
 
  Specifies to display audit information which are reported from the start date, or to display reported audit information up to the end date but not included the end date.

NOTES

dbdst_report must be run as Oracle DBA user.

Real Application Clusters (RAC) Considerations

This command is supported in a RAC environment. This command can be run on any node of the RAC.

EXAMPLES


$ /opt/VRTS/bin/dbdst_report -S $ORACLE_SID -o policy

TSDB Database Policy Report ----------------------------------------------------- Plan Name = archivelog:archive1 Plan Type = ARCHIVE LOG Rule Name = DBED_relocate_age_ino63_ Directory=/susanvset/archive1 Rule Description = THREE >= 15 days

$ /opt/VRTS/bin/dbdst_report -S $ORACLE_SID -o audit

AUDIT DATETIME AUDIT DESCRIPTION ------------------- ------------------------------------------- 02/10/2006-23:28:15 ADMIN;Added;class name=ONE 02/10/2006-23:28:16 ADMIN;Added;class name=TWO 02/10/2006-23:28:17 ADMIN;Added;class name=THREE 02/10/2006-23:28:18 ADMIN;Modified Successfully;max/min class=4/2, statinterval=30, sweeptime=22:0, purgetime=20:0, swp/prg freq=1:30 02/10/2006-23:28:35 Convert;SUCCESS;Converting device /dev/vx/dsk/eeedg/myvset mounted at /susanvset/myvset 02/10/2006-23:28:38 Addvol;SUCCESS;volume susan1 belongs to storage_class ONE 02/10/2006-23:28:41 Addvol;SUCCESS;volume susan3 belongs to storage_class TWO

EXIT STATUS

0 Command executed successfully.
1 An Error Occured.
101 Licence check failed.
102 No license to execute this command.
103 Invalid Storage Class
104 The device or mount point is not owned by user
105 Could not get information from Oracle Database
255 Could not load program.

SEE ALSO

RAC is not supported with some SF products/configurations. For details please refer to the Veritas Storage Foundation: Storage and Availability Management for Oracle Databases Guide

dbdst_classify(1M), dbdst_admin(1M), dbdst_convert(1M), dbdst_file_move(1M), dbdst_partition_move(1M), dbdst_preset_policy(1M), dbdst_report(1M), dbdst_rmvol(1M), dbdst_show_fs(1M), dbdst_tbs_move(1M), dbdst_obj_move(1M), dbdst_obj_view(1M), oracle_edition(7)

Veritas Storage Foundation: Storage and Availability Management for Oracle Databases


SF for Oracle dbdst_report(1M)