DB_FILE_NAME_CONVERT数据库文件转换，包括datafile和tempfile，顺序为：主从 LOG_FILE_NAME_CONVERT日志转换，包括onlinelog和archivelog，顺序为：主从 注意：*.LOG_ARCHIVE_DEST_1参数指定的是本地的归档路径，同时
*.LOG_FILE_NAME_CONVERT将本地的归档日志传送到从节点上。如果将
DEST的路径设置到db_recovery_file_dest的话，在配置ogg时会出现归档文件为arc而查找文件名为dbf的问题，此处建议配置归档路径不要设置到db_recovery_file_dest目录
racheren2.__db_cache_size=436207616 racheren1.__db_cache_size=369098752 racheren2.__java_pool_size=16777216 racheren1.__java_pool_size=16777216 racheren2.__large_pool_size=16777216 racheren1.__large_pool_size=16777216
racheren1.__oracle_base='/dats/app/oracle/product/11g'#ORACLE_BASE set from environment
racheren2.__oracle_base='/dats/app/oracle/product/11g'#ORACLE_BASE set from environment
racheren2.__pga_aggregate_target=671088640 racheren1.__pga_aggregate_target=671088640 racheren2.__sga_target=989855744 racheren1.__sga_target=989855744 racheren2.__shared_io_pool_size=0 racheren1.__shared_io_pool_size=0 racheren2.__shared_pool_size=503316480 racheren1.__shared_pool_size=570425344 racheren2.__streams_pool_size=0 racheren1.__streams_pool_size=0
*.audit_file_dest='/dats/app/oracle/product/11g/admin/racheren/adump'
*.audit_trail='db' *.cluster_database=true *.compatible='11.2.0.0.0'
*.control_files='+ORADATA/racheren/controlfile/current.260.811349567','+ORAFLASH/racheren/controlfile/current.256.811349569' *.db_block_size=8192
*.db_create_file_dest='+ORADATA' *.db_domain='' *.db_name='racheren'
*.db_recovery_file_dest='+ORAFLASH' *.db_recovery_file_dest_size=4070572032 *.diagnostic_dest='/dats/app/oracle/product/11g'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racherenXDB)' racheren1.instance_number=1 racheren2.instance_number=2
racheren1.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.77.37)(PORT=1521))))' racheren2.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.77.39)(PORT=1521))))' *.log_archive_format='%t_%s_%r.dbf' *.memory_target=1655701504 *.nls_language='ENGLISH' *.nls_territory='CHINA' *.open_cursors=300 *.processes=1500
*.remote_listener='scan-vip:1521' *.remote_login_passwordfile='exclusive' *.sessions=1655
racheren2.thread=2 racheren1.thread=1
racheren1.undo_tablespace='UNDOTBS1' racheren2.undo_tablespace='UNDOTBS2'
#add below parameter for standy database *.service_names=racheren *.DB_UNIQUE_NAME=racheren
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(racheren,racheren_standby)'
*.LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=racheren'
*.LOG_ARCHIVE_DEST_2='SERVICE=racheren_standby LGWR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=racheren_standby' *.FAL_SERVER='racheren_standby' *.FAL_CLIENT='racheren'
*.STANDBY_FILE_MANAGEMENT=AUTO
*.DB_FILE_NAME_CONVERT='/dats/app/oracle/product/11g/oradata/datafile','+ORADATA/racheren/datafile','/dats/app/oracle/product/11g/oradata/tempfile','+ORADATA/racheren/tempfile'
*.LOG_FILE_NAME_CONVERT='/dats/app/oracle/product/11g/archivelog','+ORAFLASH/racheren/archivelog','/dats/app/oracle/product/11g/onlinelog','+ORADATA/racheren/onlinelog','/dats/app/oracle/product/11g/onlinelog','+ORAFLASH/racheren/onlinelog'
racheren1.fal_client='racheren1' racheren2.fal_client='racheren2'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
6.准备从库的参数文件
从库的控制文件中，由于从库会切成主库，而对应的rac主库会变为从库，这时需要关闭rac的一个节点，并将日志传送到rac存活的节点上。所以从库中配置主库的信息为一个节点，例如racheren1,参见下列参数的标红地方
#add below parameter for standy database
*.audit_file_dest='/dats/app/oracle/product/11g/admin/racheren/adump'
*.background_dump_dest='/dats/app/oracle/product/11g/admin/racheren/bdump'
*.compatible='11.2.0.1.0'
*.control_files='/dats/app/oracle/product/11g/oradata/datafile/racheren.ctl'
*.core_dump_dest='/dats/app/oracle/product/11g/admin/racheren/cdump'
*.db_block_size=8192 *.db_domain='' *.db_name='racheren'
*.DB_UNIQUE_NAME='racheren_standby' *.db_file_multiblock_read_count=18
*.DB_FILE_NAME_CONVERT='+ORADATA/racheren/datafile','/dats/app/oracle/product/11g/oradata/datafile','+ORADATA/racheren/tempfile','/dats/app/oracle/product/11g/oradata/tempfile' *.fal_client='racheren_standby'
*.FAL_SERVER='racheren1',’racheren2’ *.job_queue_processes=1000
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(racheren_standby,racheren)'
*.LOG_ARCHIVE_DEST_1='LOCATION=/dats/app/oracle/product/11g/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=racheren_standby'
*.LOG_ARCHIVE_DEST_2='SERVICE=racheren1 LGWR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=racheren'
*.LOG_FILE_NAME_CONVERT='+ORAFLASH/racheren/archivelog','/dats/app/oracle/product/11g/archivelog','+ORADATA/racheren/onlinelog','/dats/app/oracle/product/11g/onlinelog','+ORAFLASH/racheren/onlinelog','/dats/app/oracle/product/11g/onlinelog' *.open_cursors=300
*.pga_aggregate_target=671088640 *.processes=1000
*.remote_login_passwordfile='exclusive' *.service_names='racheren' *.sga_target=989855744
*.STANDBY_FILE_MANAGEMENT='AUTO' *.undo_management='AUTO' *.undo_tablespace='UNDOTBS'
*.user_dump_dest='/dats/app/oracle/product/11g/admin/racheren/udump'
7.将主库全库备份到从库上
7.1在主库上对rac进行全库备份 Bash-$>Rman target /
RMAN>backup database format ‘/dats/backup/racherenfull_U%’ plus archivelog delete all input