<强>
<强>
,,,如图所示,主库为bjdb (db_unique_name),备库为shdb和gzdb。
,
<强>
<强>
* .audit_file_dest='/u01/app/oracle/admin/刺激/adump '
* .background_dump_dest='/u01/app/oracle/admin/刺激/bdump '
*适应性=' 10.2.0.1.0 '
* .control_files='/u01/app/oracle/oradata/刺激/control01.ctl ', '/disk1/oradata bj/control02.ctl ', '/disk2/oradata bj/control03.ctl '
* .core_dump_dest='/u01/app/oracle/admin/刺激/cdump '
* .db_block_size=8192
* .db_domain="
* .db_file_multiblock_read_count=16
* .DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/sh ', '/u01/app/oracle/oradata/刺激','/u01/app/oracle/oradata/广州','/u01/app/oracle/oradata/刺激的
* .db_recovery_file_dest='/u01/app/oracle/flash_recovery_area '
* .db_recovery_file_dest_size=2147483648
* .instance_name=産j’
* .job_queue_processes=10
* .open_cursors=300
* .pga_aggregate_target=94371840
* .processes=150
* .remote_login_passwordfile=岸兰摇?
* .sga_target=285212672
* .undo_management='汽车'
* .undo_tablespace=' UNDOTBS1 '
*。user_dump_dest='/u01/app/oracle/admin/刺激/udump”
* .db_name=按碳ぁ?
* .DB_UNIQUE_NAME=' bjdb '
* .FAL_CLIENT=' bjdb '
* .FAL_SERVER=皊hdb”、“gzdb”
* .LOG_ARCHIVE_CONFIG=' DG_CONFIG=(bjdb, shdb gzdb) '
* .LOG_ARCHIVE_DEST_1==/disk3/arch_bj”位置
VALID_FOR才能=(ALL_LOGFILES ALL_ROLES)
DB_UNIQUE_NAME=bjdb '才能
,,
* .LOG_ARCHIVE_DEST_2='服务=shdb LGWR 异步
VALID_FOR才能=(ONLINE_LOGFILES PRIMARY_ROLE),
DB_UNIQUE_NAME=shdb '才能
,,
* .LOG_ARCHIVE_DEST_3='服务=gzdb LGWR 异步
VALID_FOR才能=(ONLINE_LOGFILES PRIMARY_ROLE)
DB_UNIQUE_NAME=gzdb '才能
,,
* .LOG_ARCHIVE_DEST_STATE_1=捌粲谩?
* .LOG_ARCHIVE_DEST_STATE_2=捌粲谩?
* .LOG_ARCHIVE_DEST_STATE_3=捌粲谩?
* .log_archive_format=癮rch_ % t_ % s_ % r.log识别”
* .LOG_ARCHIVE_MAX_PROCESSES=3
* .LOG_FILE_NAME_CONVERT='/disk1/oradata/sh ',‘/disk1/oradata/bj’, '/disk2 oradata/sh ', '/disk2/oradata bj’,‘/disk1/oradata/广州’,‘/disk1/oradata/bj’,/disk2/oradata/广州,‘/disk2/oradata bj’
*。STANDBY_FILE_MANAGEMENT='汽车' <强>
(oracle@shsrv dbs)美元,cat initsh.ora
* .audit_file_dest='/u01/app/oracle/admin/sh/adump '
* .background_dump_dest='/u01/app/oracle/admin/sh/bdump '
*适应性=' 10.2.0.1.0 '
* .control_files='/u01/app/oracle/oradata/sh/std_control.ctl '
* .core_dump_dest='/u01/app/oracle/admin/sh/cdump '
* .db_block_size=8192
* .db_domain="
* .db_file_multiblock_read_count=16
* .DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/刺激','/u01/app/oracle/oradata/sh ', '/u01/app/oracle/广州,'/u01/app/oracle/oradata/sh '
* .instance_name=' sh '
* .job_queue_processes=10
* .open_cursors=300
* .pga_aggregate_target=94371840
* .processes=150
* .remote_login_passwordfile=岸兰摇?
* .sga_target=285212672
* .undo_management='汽车'
* .undo_tablespace=' UNDOTBS1 '
*。user_dump_dest='/u01/app/oracle/admin/sh/udump”
* .db_name=按碳ぁ?
* .DB_UNIQUE_NAME=' shdb '
* .FAL_CLIENT=' shdb '
* .FAL_SERVER=癰jdb”、“gzdb”
* .LOG_ARCHIVE_CONFIG=' DG_CONFIG=(bjdb, shdb gzdb) '
* .LOG_ARCHIVE_DEST_1==/disk3/arch_sh”位置
VALID_FOR才能=(ALL_LOGFILES ALL_ROLES)
DB_UNIQUE_NAME=shdb '才能
,,
* .LOG_ARCHIVE_DEST_2='服务=bjdb LGWR 异步
VALID_FOR才能=(ONLINE_LOGFILES PRIMARY_ROLE),
DB_UNIQUE_NAME=bjdb '才能
,,
* .LOG_ARCHIVE_DEST_3='服务=gzdb LGWR 异步
VALID_FOR才能=(ONLINE_LOGFILES PRIMARY_ROLE)
DB_UNIQUE_NAME=gzdb '才能
,,
* .LOG_ARCHIVE_DEST_STATE_1=捌粲谩?
* .LOG_ARCHIVE_DEST_STATE_2=捌粲谩?
* .LOG_ARCHIVE_DEST_STATE_3=捌粲谩?
* .log_archive_format=癮rch_ % t_ % s_ % r.log识别”
* .LOG_ARCHIVE_MAX_PROCESSES=3
* .LOG_FILE_NAME_CONVERT=?disk1/oradata/bj’,‘/disk1/oradata/sh’,‘/disk2/oradata bj’, '/disk2/oradata/sh ', '/disk1/oradata/广州','/disk1/oradata/sh ', '/disk2/oradata/广州','/disk2/oradata/sh '
*。STANDBY_FILE_MANAGEMENT='汽车'
