Versions Compared

Old Version 3

changes.mady.by.user KrupeshD

Saved on

compared with

New Version Current

changes.mady.by.user KrupeshD

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
========================================================= 
 Dbvisit Standby Database Technology
http://www.dbvisit.com

 Dbvisit Database setup 
 Default values will be shown in [] 

 Options: 
 1) New Dbvisit Database setup (combines options 2,3,4) 
 1a) New Dbvisit RAC Instance setup (combines options 2,3,4) 

 2) New Dbvisit Database configuration (DDC) file setup 
 3) New Dbvisit Archive Management Module (AMM) setup 
 4) New Dbvisit Database repository (DDR) setup 

 5) Manage Dbvisit Database repository (DDR) 
 6) Update Dbvisit Database configuration (DDC) file 

 7) Create Standby Database (and template) 

 9) Uninstall Dbvisit Database repository (DDR) 
 E) Exit 

 ========================================================= 
 Please enter choice : 7

...

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
=>Creating Standby Database. 
 Primary database will NOT be shutdown. 
 For which primary database do you wantwant 
 to create a standby database? 
 The following Oracle database(s) have aa 
 Dbvisit Database configuration (DDC) file on this server: 
 SID 
 === 
 1) dbvisitp 
 2) dbvlx102 
 3) Return to menu 

 Please enter choice : 1 
 Is this correct? <Yes/No> [Yes]:

...

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
------------------------------------------------------------------------------ 
Dbvisit Standby has functionality to create missing missing 
filesystem directories on the standby server automatically. 
Do you want Dbvisit Standby to create missing filesystem filesystem 
directories on the standby automatically? [Yes]: Dbvisit 
will create missing filesystem directories automatically: Y 
Is this correct? <Yes/No> [Yes]:

...

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
------------------------------------------------------------------------------
The following oracle database parameters will be set in the the 
standby database pfile or spfile:
-------------------------------------------------------------------------------
db_block_size                           8192
db_file_multiblock_read_count           16
db_name                                 dbvisitp
dispatchers                             (PROTOCOL=TCP) (SERVICE=dbvisitpXDB)
job_queue_processes                     10
log_archive_dest
log_archive_dest_1                      location=/oracle/oraarch/dbvisitp
log_archive_format                      %t_%s_%R.log
nls_language                            German
nls_territory                           germany
open_cursors                            300
pga_aggregate_target                    16777216
plsql_compiler_flags                    NATIVE, NON_DEBUG
processes                               150
remote_login_passwordfile               EXCLUSIVE
 
-------------------------------------------------------------------------------
What would you like to do:
   1 - Proceed with creating the standby database
   2 - Edit oracle database parameters for the standby database pfile/spfile
   3 - Terminate processing
   Please enter your choice [1]:
 
Validating oracle database parameters... please wait
SUCCEEDED
Note

To edit spfile parameter on standby database, select option 2 and enter full-name of the parameter and then associated new value.


10. It is possible to specify the locations of standby datafiles, redo logs and tempfiles different as primary, or alternatively keep the same structure for the standby database as primary:

Section
Column
width5%

 

Column
width95%
Panel
bgColorCCC
Primary database contains non OMF datafiles and/or tempfiles.  
To create non-OMF standby datafiles and/or tempfiles Dbvisit 
requires you to provide valid filesystem locations on the standby. 
Review and confirm standby locations to create standby non-OMF datafiles and tempfiles.

...