OCM_Session8_2_Step-by-StepInstructionsforCreatingaPhysicalStandbyDatabase - 数据库编程

all 6832128 Mar 19 19:51 snapcf_PROD.f -rw-r----- 1 oracle oinstall 4608 Mar 25 09:57 spfilePROD.ora [oracle@ocm1 dbs]$ scp initPROD.ora ocm2.localdomain:/u01/app/oracle/product/10.2.0/db_1/dbs The authenticity of host 'ocm2.localdomain (192.168.1.156)' can't be established. RSA key fingerprint is de:2a:4c:d0:b2:20:88:4c:a2:72:24:11:50:4b:d6:74. Are you sure you want to continue connecting (yes/no) yes Warning: Permanently added 'ocm2.localdomain,192.168.1.156' (RSA) to the list of known hosts. oracle@ocm2.localdomain's password: initPROD.ora 100% 1827 1.8KB/s 00:00 [oracle@ocm1 dbs]$
②，在备库中修改pfile
[oracle@ocm2 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs [oracle@ocm2 dbs]$ ll total 48 -rw-rw---- 1 oracle oinstall 1544 Mar 24 14:10 hc_EMREP.dat -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r--r-- 1 oracle oinstall 1827 Mar 25 10:08 initPROD.ora -rw-rw---- 1 oracle oinstall 24 Mar 20 15:14 lkEMREP -rw-r----- 1 oracle oinstall 1536 Mar 20 16:16 orapwEMREP -rw-r----- 1 oracle oinstall 2560 Mar 24 14:10 spfileEMREP.ora [oracle@ocm2 dbs]$ mv initPROD.ora initPRODSTD.ora [oracle@ocm2 dbs]$ vi initPRODSTD.ora
修改内容如下：

PRODSTD.__db_cache_size=331350016 PRODSTD.__java_pool_size=4194304 PRODSTD.__large_pool_size=4194304 PRODSTD.__shared_pool_size=180355072 PRODSTD.__streams_pool_size=0 *.BACKGROUND_DUMP_DEST='/u01/app/oracle/admin/ PRODSTD/bdump' *.control_files='/u01/app/oracle/oradata/ PRODSTD/Disk1/control01.ctl','/u01/app/oracle/oradata/ PRODSTD/Disk2/control02.ctl','/u01/app/oracle/oradata/ PRODSTD/Disk3/control03.ctl' *.CORE_DUMP_DEST='/u01/app/oracle/admin/ PRODSTD/cdump' *.DB_BLOCK_SIZE=8192 *.DB_CREATE_FILE_DEST='/u01/app/oracle/oradata/ PRODSTD/Disk1' *.DB_CREATE_ONLINE_LOG_DEST_1='/u01/app/oracle/oradata/ PRODSTD/Disk1' *.DB_NAME=' PROD' *.db_recovery_file_dest_size=4294967296 *.db_recovery_file_dest='/home/oracle/flash' *.job_queue_processes=15 *.max_dispatchers=10 *.max_shared_servers=30 *.processes=135 *.sessions=300 *.SGA_TARGET=500M *.shared_server_sessions=200 *.shared_servers=10 *.UNDO_MANAGEMENT='auto' *.undo_retention=5400 *.UNDO_TABLESPACE='undotbs1' *.USER_DUMP_DEST='/u01/app/oracle/admin/ PRODSTD/udump' *.utl_file_dir='/home/oracle','/home/oracle/temp','/home/oracle/scripts'
##parameter for Primary Database DB_NAME= PROD DB_UNIQUE_NAME= PRODSTD LOG_ARCHIVE_CONFIG='DG_CONFIG=(PROD,PRODSTD)' CONTROL_FILES='/u01/app/oracle/oradata/ PRODSTD/Disk1/control01.ctl','/u01/app/oracle/oradata/ PRODSTD/Disk2/control02.ctl','/u01/app/oracle/oradata/ PRODSTD/Disk3/control03.ctl' LOG_ARCHIVE_DEST_1='location=/u01/app/oracle/oradata/ PRODSTD/Disk2/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME= PRODSTD' LOG_ARCHIVE_DEST_2='SERVICE= PROD LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME= PROD' LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE LOG_ARCHIVE_FORMAT=%t_%s_%r.arc LOG_ARCHIVE_MAX_PROCESSES=30 ##parameter for Standby Database FAL_SERVER= PROD FAL_CLIENT= PRODSTD DB_FILE_NAME_CONVERT=' PROD',' PRODSTD' LOG_FILE_NAME_CONVERT=' PROD',' PRODSTD' STANDBY_FILE_MANAGEMENT=AUTO

Note： 此处需注意参数文

OCM_Session8_2_Step-by-StepInstructionsforCreatingaPhysicalStandbyDatabase(二)