oracle rac迁移到单实例库,rac迁移到单实例 - Oracle数据库管理 - ITPUB论坛－中国专业的IT技术社区...

启动standby nomout的参数文件

[oracle@localhost ~]$ cat initorcl.ora

orcldg.__db_cache_size=117440512

orcldg.__java_pool_size=4194304

orcldg.__large_pool_size=8388608

orcldg.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

orcldg.__pga_aggregate_target=809500672

orcldg.__sga_target=281018368

orcldg.__shared_io_pool_size=0

orcldg.__shared_pool_size=138412032

orcldg.__streams_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'

*.audit_trail='db'

*.compatible='11.2.0.4.0'

*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/flash_recovery_area/orcldg/control02.ctl'

*.db_block_size=8192

*.db_create_file_dest='/u01/app/oracle/oradata/orcl'

*.db_domain=''

*.db_file_name_convert='+DATA/orcl/datafile','/u01/app/oracle/oradata/orcl','+DATA/orcl/tempfile','/u01/app/oracle/oradata/orcl/tempfile'

*.db_name='orcl'

*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'

*.db_recovery_file_dest_size=6291456000

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.fal_client='orcldg'

*.fal_server='ORCL'

*.job_queue_processes=0

*.log_archive_config='DG_CONFIG=(orcl,orcldg)'

*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST'

*.log_archive_dest_2='service=orcldg lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=orcldg'

*.log_archive_dest_state_1='ENABLE'

*.log_archive_dest_state_2='enable'

*.log_archive_format='%t_%s_%r.arc'

*.log_archive_max_processes=30

*.log_file_name_convert='+DATA/orcl/onlinelog','/u01/app/oracle/oradata/orcl/onlinelog','+FRA/orcl/onlinelog','/u01/app/oracle/flash_recovery_area/orcl/onlinelog'

*.memory_max_target=1024m

*.memory_target=0

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='exclusive'

*.sga_max_size=612m

*.sga_target=600m

*.standby_file_management='auto'

thread=1

undo_tablespace='UNDOTBS1'