Page Comparison

...

For a complete overview of creating the standby database, please see Start the Dbvisit Standby command console from the Start Menu > Programs > Dbvisit > Standby > Dbvisit Standby setup.

Image RemovedImage Added

1. To create a standby database, choose option 7.

...

Section

Column

width	5%

Column

width	95

Panel

bgColor	CCC

=>Creating Standby Database. 
Primary database will NOT be shutdown. 
For which primary database do you want to create a standby database? 
The following Oracle database(s) have a a

Dbvisit Database configuration (DDC) file on this server: 
SID 
=== 
1) w120n 
3) Return to menu 
Please enter choice : 1 
Is this correct? <Yes/No> [Yes]:

...

Section

Column

width	5%

Column

width	95

Panel

bgColor	CCC

------------------------------------------------------------------------------ 
Dbvisit has functionality to create missing missing

filesystem directories on the standby server automatically. 
Do you want Dbvisit to create missing missing

filesystem directories on the standby automatically? [Yes]:

Dbvisit will create missing filesystem directories automatically:Y 
Is this correct? <Yes/No> [Yes]:

...

Section

Column

width	5%

Column

width	95

Panel

bgColor	CCC

------------------------------------------------------------------------------

The following oracle database parameters will be set in the standby database pf

le or spfile:

-------------------------------------------------------------------------------

audit_file_dest                         C:\ORACLE\ADMIN\W120N\ADUMP

background_dump_dest                    C:\ORACLE\ADMIN\W120N\BDUMP

compatible                              10.2.0.1.0

control_files                           C:\ORACLE\ORADATA\W120N\CONTROL01.CTL,

                                        C:\ORACLE\ORADATA\W120N\CONTROL02.CTL,

                                        C:\ORACLE\ORADATA\W120N\CONTROL03.CTL

core_dump_dest                          C:\ORACLE\ADMIN\W120N\CDUMP

db_block_size                           8192

db_file_multiblock_read_count           16

db_name                                 w120n

db_recovery_file_dest_size              2621440000

dispatchers                             (PROTOCOL=TCP) (SERVICE=w120nXDB)

job_queue_processes                     10

log_archive_dest_1                      LOCATION=C:\oracle\oraarch\w120n

log_archive_format                      ARC_%%ORACLE_SID%%%S_%R.%T

open_cursors                            300

pga_aggregate_target                    155189248

processes                               50

remote_login_passwordfile               EXCLUSIVE

sessions                                60

sga_target                              469762048

spfile                                  OS default

standby_file_management                 AUTO

undo_management                         AUTO

undo_tablespace                         UNDOTBS1

user_dump_dest                          C:\ORACLE\ADMIN\W120N\UDUMP

-------------------------------------------------------------------------------

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.

9. 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

width	5%

Column

width	95

Panel

bgColor	CCC

------------------------------------------------------------------------------

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.

-------------------------------------------------------------------------------

Primary                   ===> Standby

-------------------------------------------------------------------------------

C:\ORACLE\ORADATA\W120N   ===> C:\ORACLE\ORADATA\W120N

-------------------------------------------------------------------------------

What would you like to do:

   1 - Confirm standby location(s) are correct and continue

   2 - Provide different standby location(s)

   Please enter your choice [1]:

Standby locations validated

Primary database contains non OMF redo logs.

To create non OMF redo logs Dbvisit requires you to specify valid filesystem

locations on the standby.

Review and confirm standby locations to create standby non OMF redo logs.

-------------------------------------------------------------------------------

Primary                   ===> Standby

-------------------------------------------------------------------------------

C:\ORACLE\ORADATA\W120N   ===> C:\ORACLE\ORADATA\W120N

-------------------------------------------------------------------------------

What would you like to do:

   1 - Confirm standby location(s) are correct and continue

   2 - Provide different standby location(s)

   Please enter your choice [1]:

Standby locations validated.

...

Versions Compared

Old Version 5

New Version Current

Key