1         环境说明

2         192.168.1.52 参数说明

control_files = /data/oracle/oradata/hellodb/control1.ctl

undo_management = AUTO

undo_tablespace = UNDOTBS1

db_name = hellodb

db_block_size = 8192

processes=500

sessions=500

sga_max_size=4G

sga_target=4G

large_pool_size=1G

background_dump_dest=/data/oracle/oradata/hellodb/bdump

user_dump_dest=/data/oracle/oradata/hellodb/udump

core_dump_dest=/data/oracle/oradata/hellodb/cdump

*.DB_UNIQUE_NAME='db52'

*.FAL_CLIENT='tns52'

*.fal_server='tnsrac'

*.log_archive_config='DG_CONFIG=(testrac,db52,db02)'

*.log_archive_dest_1='LOCATION=/data/oracle/oradata/hellodb/arch'

*.log_archive_dest_2='SERVICE=tnsrac LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=testrac'

*.log_archive_dest_3='SERVICE=tns02 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=db02'

*.log_archive_dest_state_1='enable'

*.log_archive_dest_state_2='defer'

*.log_archive_dest_state_3='enable'

*.standby_file_management='AUTO'

*.compatible=10.2.0.1.0

*.log_file_name_convert='+ARCH','/data/oracle/oradata/hellodb'

*.db_create_file_dest='/data/oracle/oradata/hellodb'

*.db_file_name_convert='+DATA/testrac/datafile','/data/oracle/oradata/hellodb','+DATA/testrac/tempfile','/data/oracle/oradata/hellodb'

*._in_memory_undo=FALSE

--主要是逻辑备库可能会包 600错误 

alter system set "_in_memory_undo"=false;

alter database add supplemental log data (primary key, unique index) columns;

select supplemental_log_data_min as supp_log,

supplemental_log_data_pk as supp_pk,

supplemental_log_data_ui as supp_ui

from v$database;

select ksppstvl from x$ksppsv where indx = (select indx from x$ksppi where ksppinm = '_in_memory_undo');