單節點主庫、邏輯備庫升級為RAC、物理備庫、邏輯備庫（1）

最近都在搞單節點主庫、邏輯備庫升級為RAC、物理備庫、邏輯備庫，進行了很多的測試，最後升級時操作非常順利，記錄一下：

 

 

1         環境說明

IP	db_name	DB_UNIQUE_NAME	instance_name	tns	Database_role	target
192.168.1.52	hellodb	db52	hellodb	tns52	primary	Physical stdby
192.168.1.2	hellodb	db02	hellodb	tns02	Lgstdby	No change
192.168.1.21	hellodb	testrac	testrac1	tnsrac	Physical stdby	No change
192.168.1.22	hellodb	testrac	testrac2	tnsrac	Physical stdby	primary

 

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');