Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
------------------------------------------------------------------------------
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
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.
-------------------------------------------------------------------------------
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.

...