Post

2 followers Follow
0
Avatar

DBVISIT Version 7 - Opening the standby database for READ / READ / WRITE

Hi
We just installed DBVISIT version 7 on Linux

If we need to open the STANDBY database for reporting purpose (READ ONLY ACCESS) temporarily (let's say for 2 hours) and after that put it back into APPLY mode so that it can resume applying the archive logs from primary (that were shipped to standby during those 2 hours) what is the exact process to accomplish that using CLI?

Also, if for whatever reasons, while the standby database was open and someone make any changes on the standby (either DML or DDL) what would be the outcome of that once we start the standby in apply mode and how to address / recover from that. what would be our options?
Thanks

Kamran Irshad Answered

Official comment

Avatar
dbv_oraStartStop open <DDC>

Opens the standby database in READONLY mode.  

Example (Standby Server):

oracle@dbvlin102[/usr/dbvisit/standby]: ./dbv_oraStartStop open devdb
=============================================================
Dbvisit Standby Database Technology (7.0.04.11619) (pid 18171)
dbv_oraStartStop started on dbvlin102: Thu Jan 23 15:59:35 2014 ()
=============================================================
Open Standby Database devdb in READ ONLY mode...
Standby Database devdb opened in READ ONLY mode.
Log files cannot be applied to Database while in READ ONLY mode.
Database tempfile(s) may need to be added to this database.
=============================================================
dbv_oraStartStop ended on dbvlin102: Thu Jan 23 15:59:39 2014
=============================================================
dbv_oraStartStop restart <DDC>
Stops (shutdown) and then starts the database. This may be either a regular (primary) database or a standby database. Dbvisit Standby will determine if the database is a primary or a standby database and will stop and start it accordingly.
 

Example (Standby Server):

oracle@dbvlin102[/usr/dbvisit/standby]: ./dbv_oraStartStop restart devdb
=============================================================
Dbvisit Standby Database Technology (7.0.04.11619) (pid 17860)
dbv_oraStartStop started on dbvlin102: Thu Jan 23 15:56:19 2014 ()
=============================================================
Shutting down standby Database devdb...
Standby Database devdb shutdown successfully.
Starting Standby Database devdb...
Standby Database devdb started .
=============================================================
dbv_oraStartStop ended on dbvlin102: Thu Jan 23 15:56:27 2014
=============================================================
Dbvisit Standby will not allow any changes while the standby is in READ ONLY mode.
 
 
 
 
Charmaigne Bezuidenhout
Comment actions Permalink

Please sign in to leave a comment.

1 comment