...
1. Automatically by Dbvisit Standby , when it detects that new datafile(s) have been added to the primary databaseduring:
- During Create Standby Database (CSD) process
- During the Re-Synchronize of a Standby Database
2. Manually by running dbv_functions –Q
...
The logic of renaming standby temp files and redo logs can be quite complex, especially for non standard database configurations.
The following settings are taken into account by Dbvisit Standby when renaming the standby database files: DEFAULT
- DEFAULT_STDBY_TEMP_
...
- LOC
Default location to create standby temp files when none of locations recorded in either old or new control file, are valid. If null then set to location of the first standby system file
...
- DEFAULT_STDBY_REDO_
...
- LOC
Default location to create standby redo files when none of locations recorded in either old or new control file, are valid. If null then set to location of the first standby system file
...
- DEFAULT_STDBY_TEMP_NAME = '%T_%N.
...
- dbf
Name pattern to use when creating non OMF standby temp files, %N is counter starting from 1, %T is tablespace name
...
- DEFAULT_STDBY_REDO_NAME = 'redo_%G_%N.log';
...
-
Name pattern to use when creating non OMF redo logs , %N is counter starting from 1, %G is group number
The
The user should avoid adding the above settings to the Dbvisit Configuration file unless advised by Dbvisit support
...
Here is a sample output of a successful dbv_functions –Q run:>
oracle@dbvlin505[/usr/dbvisit/standby]: ./dbv_functions -Q
...
testdb
Dbvisit Database configuration (DDC) file dbv_
...
testdb.env.
=>Replace current standby controfiles on
...
dbvlin506 with new standby
controlfile? <Yes/No> [No]:
...
Yes
Creating standby
...
controlfile as '/usr/dbvisit/standby/tmp/13465_testdb_ctl.dbv'...
> Transferring '13465_testdb_ctl.dbv' to server dbvlin506:7890
Progress: 0%...20%...40%...60%...80%...100% [11834 KB/s] - done.
Replacing standby controlfile...
----------------------------
Dbvisit Database configuration (DDC) file dbv_
...
testdb.env.
Starting Standby Database
...
testdb...
Standby Database
...
testdb started nomount.
Controlfile backed up as /usr/dbvisit/standby/tmp/standby_
...
testdb_
...
201306281321.ctl.
===>Should recreating of control file fails, see file /
...
usr/
...
dbvisit/
...
standby/
...
log/dbv_stdby_ctl_
...
testdb.lck on
...
dbvlin506 for steps to resolve.
Starting Standby Database
...
testdb...
Standby Database
...
testdb started nomount.
STANDBY
...
Starting Standby Database dbvlx102...
Standby Database dbvlx102 started .
Standby file +DATA/dbvlx102/datafile/system.298.754676807 renamed to +DATA/dbvlx102/datafile/system.276.779280379 in database dbvlx102.
Standby file +DATA/dbvlx102/users.dbf renamed to +DATA/dbvlx102/datafile/users.274.779280585 in database dbvlx102.
Standby file +DATA/dbvlx102/datafile/sysaux.297.754676905 renamed to +DATA/dbvlx102/datafile/sysaux.260.779280473 in database dbvlx102.
Standby file +DATA/dbvlx102/datafile/undotbs1.287.754676863 renamed to +DATA/dbvlx102/datafile/undotbs1.266.779280433 in database dbvlx102.
Standby file +DATA/dbvlx102/datafile/users.290.754677031 renamed to +DATA/dbvlx102/datafile/users.273.779280601 in database dbvlx102.
alter database rename file '+ONLINELOGS/dbvlx102/onlinelog/redo_2_1' to '+ONLINELOGS';
alter database rename file '+ONLINELOGS/dbvlx102/onlinelog/redo_2_2' to '+ONLINELOGS';
alter database rename file '+ARCHIVELOGS/dbvlx102/onlinelog/group_3.450.779106171' to '+ARCHIVELOGS';
alter database rename file '+ARCHIVELOGS/dbvlx102/onlinelog/group_3.451.779106175' to '+ARCHIVELOGS';
alter database rename file '+DATA/dbvlx102/tempfile/temp1.307.775046681' to '+DATA';
alter database rename file '+DATA/dbvlx102/tempfile/temp01.dbf' to '+DATA';
controlfile(s) restored from /usr/dbvisit/standby/tmp/13465_testdb_ctl.dbv.
Starting Standby Database testdb...
Standby Database testdb started .
OK
----------------------------
Standby controfiles on
...
dbvlin506 replaced.
To complete please run Dbvisit on the primary node(s), then on the standby.
oracle@dbvlin505[/usr/dbvisit/standby]: