OCM_Session8_1_PreparingthePrimaryDatabaseforStandbyDatabaseCreation - 数据库编程

---------- ------------- --------- ------------ --------- 6 UNASSIGNED 0 0 104857600 512 YES UNASSIGNED 0 0 7 UNASSIGNED 0 0 104857600 512 YES UNASSIGNED 0 0 8 UNASSIGNED 0 0 104857600 512 YES UNASSIGNED 0 0 9 UNASSIGNED 0 0 104857600 512 YES UNASSIGNED 0 0 10 UNASSIGNED 0 0 104857600 512 YES UNASSIGNED 0 0 11 UNASSIGNED 0 0 104857600 512 YES UNASSIGNED 0 0
6 rows selected.
SYS@PROD>
1.4 Set Primary Database Initialization Parameters
①创建PROD的pfile，然后修改之
SYS@PROD>show parameter spfile;

NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /u01/app/oracle/product/10.2.0 /db_1/dbs/spfilePROD.ora SYS@PROD>create pfile from spfile;
File created.
SYS@PROD>! [oracle@ocm1 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs [oracle@ocm1 dbs]$ ll total 6740 -rw-rw---- 1 oracle oinstall 1544 Mar 25 08:54 hc_PROD.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 1163 Mar 25 09:34 initPROD.ora -rw-rw---- 1 oracle oinstall 24 Mar 18 10:18 lkPROD -rw-r----- 1 oracle oinstall 5120 Mar 18 09:54 orapwPROD -rw-r--r-- 1 oracle oinstall 318 Mar 17 20:37 pfile.ora -rw-r----- 1 oracle oinstall 6832128 Mar 19 19:51 snapcf_PROD.f -rw-r----- 1 oracle oinstall 3584 Mar 25 08:54 spfilePROD.ora [oracle@ocm1 dbs]$ cat initPROD.ora PROD.__db_cache_size=348127232 PROD.__java_pool_size=4194304 PROD.__large_pool_size=4194304 PROD.__shared_pool_size=163577856 PROD.__streams_pool_size=0 *.BACKGROUND_DUMP_DEST='/u01/app/oracle/admin/PROD/bdump' *.control_files='/u01/app/oracle/oradata/PROD/Disk1/control01.ctl','/u01/app/oracle/oradata/PROD/Disk2/control02.ctl','/u01/app/oracle/oradata/PROD/Disk3/control03.ctl' *.CORE_DUMP_DEST='/u01/app/oracle/admin/PROD/cdump' *.DB_BLOCK_SIZE=8192 *.DB_CREATE_FILE_DEST='/u01/app/oracle/oradata/PROD/Disk1' *.DB_CREATE_ONLINE_LOG_DEST_1='/u01/app/oracle/oradata/PROD/Disk1' *.DB_NAME='PROD' *.dispatchers='(PROTOCOL=TCP)(DISPATCHERS=3)'--------删除 *.job_queue_processes=15 *.local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=ocm1.localdomain)(PORT=1526))'-----------删除， 确保PRODSTD动态注册到1521端口上 *.LOG_ARCHIVE_DEST_1='location=/u01/app/oracle/oradata/PROD/Disk2/arch'-------删除 *.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/PROD/udump' *.utl_file_dir='/home/oracle','/home/oracle/temp','/home/oracle/scripts' [oracle@ocm1 dbs]$
②修改参数，添加以下内容
##parameter for Primary Database DB_NAME=PROD DB_UNIQUE_NAME=PROD LOG_ARCHIVE_CONFIG='DG_CONFIG=(PROD,PRODSTD)' CONTROL_FILES='/u01/app/oracle/oradata/PROD/Disk1/control01.ctl','/u01/app/oracle/oradata/PROD/Disk2/control02.ctl','/u01/app/oracle/oradata/PROD/Disk3/control03.ctl' LOG_ARCHIVE_DEST_1='location=/u01/app/oracle/oradata/PROD/Disk2/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PROD' LOG_ARCHIVE_DEST_2='SERVICE=PRODSTD LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRODSTD' LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLU

OCM_Session8_1_PreparingthePrimaryDatabaseforStandbyDatabaseCreation(四)