------------------------------------------------------------------------------- CREATE STANDBY DATABASE TEMPLATE SUMMARY ------------------------------------------------------------------------------- A - GENERAL SETTINGS ------------------------------------------------------------------------------- TEMPLATE ID 1 DDC FILE dbvlx102 SOURCE HOST dbvisit31 DESTINATION HOST dbvisit32 STANDBY ASM Y COPY DATAFILES DIRECTLY N COMPRESS DATAFILES Y USE TRANSPORTABLE MEDIA N PRIMARY TEMP LOCATION /usr/tmp/tmp1 STANDBY TEMP LOCATION /usr/tmp/tmp2 STOP POINT SET N CREATE DIRECTORIES AUTO Y CREATED ON 28-11-2011 10-04-27 ------------------------------------------------------------------------------- B - INIT ORA PARAMETERS ------------------------------------------------------------------------------- audit_file_dest /oracle/orabase/admin/dbvlx102/adump background_dump_dest /oracle/orabase/admin/dbvlx102/bdump compatible 10.2.0.1.0 control_files +ARCHIVELOGS/dbvlx102/control01.ctl, +DATA/dbvlx102/control02.ctl, +ONLINELOGS/dbvlx102/control03.ctl core_dump_dest /oracle/orabase/admin/dbvlx102/cdump db_block_size 8192 db_create_file_dest +DATA db_create_online_log_dest_1 +ARCHIVELOGS db_create_online_log_dest_2 +ARCHIVELOGS db_file_multiblock_read_count 16 db_name dbvlx102 db_recovery_file_dest +DATA db_recovery_file_dest_size 2147483648 dispatchers (PROTOCOL=TCP) (SERVICE=dbvlx102XDB) job_queue_processes 10 log_archive_dest_1 LOCATION=+DATA log_archive_dest_2 LOCATION=/oracle/oraarch/dbvlx102 log_archive_format %t_%s_%r.dbf log_archive_start TRUE log_file_name_convert +ARCHIVELOGS/dbvlx102/onlinelog, +ARCHIVELOGS/DBVLX102/onlinelog, +ONLINELOGS/dbvlx102/onlinelog, +ARCHIVELOGS/DBVLX102/onlinelog open_cursors 300 pga_aggregate_target 16777216 processes 150 remote_login_passwordfile EXCLUSIVE sga_target 167772160 spfile default standby_file_management MANUAL undo_management AUTO undo_tablespace UNDOTBS1 user_dump_dest /oracle/orabase/admin/dbvlx102/udump ------------------------------------------------------------------------------- C - DATABASE FILE LOCATIONS ------------------------------------------------------------------------------- TYPE ID STANDBY FILE NAME DATA 1 +DATA DATA 2 +DATA DATA 3 +DATA DATA 4 +DATA DATA 5 +DATA TEMP 1 +DATA TEMP 2 +DATA TEMP 3 +DATA ------------------------------------------------------------------------------- What would you like to do: 1 - Create standby database using existing saved template 2 - View content of existing saved template 3 - Return to the previous menu Please enter your choice [1]: Validating template... Please wait... STATUS=VALID ------------------------------------------------------------------------------- What would you like to do: 1 - Create standby database using existing saved template 2 - View content of existing saved template 3 - Return to the previous menu Please enter your choice [1]: Validating template... Please wait... STATUS=VALID |