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

DISABLED 560 - DCOSNP - -
sd PRODdg02-02 data_vol_dcl-02
ENABLED 560 0 - - -
Changing the default control file location
For Oracle 11gR2, while creating a database using DBCA, one of the control file
locations defaults to the flash recovery area. (parameter : flash_recovery_area).
Storage Foundation for databse (SFDB) utilities require that all of the control files
of a database reside on a Veritas file system other than on ORACLE_HOME.
To change the default installation
◆
Perform one of the following:
■ Instruct Oracle not to place a copy of a control file in flash recovery area
at the time of database creation.
■ Move or remove the copy of control file residing in flash recovery area
using SQL commands. Do not use OS commands to perform this task.
Updating after structural changes to the database
In case of any structural change to database, for instance adding or removing any
database objects such as control files, data files , arch location etc., you must
execute dbed_update on the node to refresh the SFDB repository. If there are any
flashsnaps which are taken before the database modification, you must perform
the following steps:
To update a flashsnap after structural change to a database
1
Resynchronize the snapshots using the dbed_vmsnap utility.
2
Run dbed_update.
3
Validate the snapplan again and take new snapshot.
About creating database snapshots
A snapshot can be a source for backing up the database or creating a clone database
for decision-support purposes. You can use Database FlashSnap commands to
create a snapshot of your entire database on the same host (node) or on a different
one.
Using Database FlashSnap for backup and off-host processing
About creating database snapshots
146