Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

You can use Cached ODM Manager to enable and disable Cached ODM settings on

database datafiles.

dbed_codm_adm -S ORACLE_SID -H ORACLE_HOME -o [ on | off ] datafile | \

-f list_file

For enabling or disabling Cached ODM on database data files:

■ Values for datafile and list_file should contain absolute pathnames.

■ The dbed_codm_adm command only turns on Cached ODM on a file level.

■ Specified files must be database datafile,

or an error is returned.

■ Specified files must be on a VXFS

filesystem, or an error is returned.

Prerequisites

■ The dbed_codm_adm does not enable

Cached ODM based on I/O hint, it only

displays I/O hint information.

■ You must supply either a datafile name

or the -f list_file option.

Notes

To enable Cached ODM

◆

To enable Cached ODM on the datafile /oradata/tb1.dbf, run:

$ dbed_codm_adm -S prod -H /orahome -o on /oradata/tb1.dbf

To disable Cached ODM on a list of datafiles

◆

To disable Cached ODM on a list of datafiles where /tmp/list_file contains a

list of datafiles name, run

$ dbed_codm_adm -S prod -H /orahome -o off -f /tmp/list_file

If user wants to turn on Cache ODM on a file and the per file system flag

odm_cache_enable is not set, dbed_codm_adm will automatically turn it on for

the filesystem. This flag needs to be turned on first so that file level caching can

be turned on. Since this requires root access, it will be done through the DBED

daemon.

Flow of control for enabling/disabling caching examples:

If you want to enable Cached ODM for file abc:

■ The Cached ODM Manager will enable filesystem odm_cache_enable flag if it

has not been enabled yet.

Improving database performance with Veritas Cached Oracle Disk Manager

Administering Cached ODM settings with Cached ODM Manager