Home > Veritas Storage Foundation™ for Oracle Manual Pages

DBED_CHECKCONFIG (1)

User Commands

Table of contents


NAME

dbed_checkconfig - check the configuration of an Oracle database in a Veritas Storage Foundation for Oracle environment

SYNOPSIS

dbed_checkconfig -S ORACLE_SID -H ORACLE_HOME [ -v ]

     [ -n ] [ -h ] [ -i ]


AVAILABILITY

Veritas Storage Foundation for Oracle. To determine whether this product is installed on an \1 system, enter:

lslpp -L VRTSdbed


DESCRIPTION

The dbed_checkconfig command verifies various elements of the environment for an Oracle database.

The command attempts to use certain basic rules on Oracle settings, file system parameters, volume parameters, and layout options to verify how resilient and well configured an Oracle database environment is. The information provided is valid for the supplied Oracle database (ORACLE_SID). All output is sent to stdout.


OPTIONS

The following options are supported:
-S ORACLE_SID
Specifies the name of the Oracle database.
-H ORACLE_HOME
Specifies the ORACLE_HOME setting for the ORACLE_SID database.
-v
Sets verbose mode. If ODM is not present, specifies which datafiles are not Quick I/O files. If ODM is present, then -v specifies which Quick I/O files need to be converted to regular VxFS files in order to use ODM features. Also specifies the datafiles that are not configured for autoextend.
-n
Disables SFDB repository refresh. By default, dbed_checkconfig will refresh the SFDB repository if this option is not used.
-h
Shows command usage.
-i
Sets interactive mode.

EXAMPLE

This example shows how to check the Oracle configuration environment:

$ /opt/VRTS/bin/dbed_checkconfig -S PROD -H /oracle/product/9i

Examining file system attributes.

All file systems are VxFS.

Examining Quick I/O settings.

All datafiles are Quick I/O files.

Examining Cached Quick I/O settings.

No file systems have Cached Quick I/O enabled.

Examining datafiles fragmentation.

5 files are fragmented.

Examining File System tunable settings.

Parameters for all VxFS file systems used by PROD.
Filesystem i/o parameters for /prod_db
read_pref_io = 65536
read_nstream = 1
read_unit_io = 65536
write_pref_io = 65536
write_nstream = 1
write_unit_io = 65536
pref_strength = 10
buf_breakup_size = 1048576
discovered_direct_iosz = 262144
max_direct_iosz = 1048576
default_indir_size = 8192
qio_cache_enable = 0
write_throttle = 0
max_diskq = 1048576
initial_extent_size = 8
max_seqio_extent_size = 2048
max_buf_data_size = 8192
hsm_write_prealloc = 0
read_ahead = 1
inode_aging_size = 0
inode_aging_count = 0
fcl_maxalloc = 65075200
fcl_keeptime = 0
fcl_winterval = 3600

Examining Oracle volume and file system layout.

Data for database PROD is contained in one volume group.

Examining Oracle internal information.

Oracle Version is 9.2.0.4.0.


Control file /prod_db/control1 is on file system /prod_db.


Control file /prod_db/control2 is on file system /prod_db.

Total of 2 control files over 1 file systems.

WARNING: Control files are not spread over multiple file
systems. Spread control files over multiple file systems
for better redundancy.

Examining Oracle automatic extension of datafiles.

Total of 0 datafiles are configured to auto extend.
Total of 9 datafiles are defined to the database.

Examining Oracle log modes.

The database is running in archivelog mode.

The database is running in automatic log archiving mode.


NOTES

dbed_checkconfig must be run as the Oracle DBA user in order to retrieve information from an Oracle database.

SEE ALSO

dbed_saveconfig(1M), dbed_update(1M), oracle_edition(7)

Veritas Storage Foundation for Oracle Administrator's Guide

Last updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.