[oracle@ocm1 dbs]$ vi initPROD.ora 修改后的pfile： [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' *.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/PROD/udump' *.utl_file_dir='/home/oracle','/home/oracle/temp','/home/oracle/scripts'
##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=EXCLUSIVE LOG_ARCHIVE_FORMAT=%t_%s_%r.arc LOG_ARCHIVE_MAX_PROCESSES=30 ##parameter for Standby Database FAL_SERVER=PRODSTD FAL_CLIENT=PROD DB_FILE_NAME_CONVERT='PRODSTD','PROD' LOG_FILE_NAME_CONVERT='PRODSTD','PROD' STANDBY_FILE_MANAGEMENT=AUTO [oracle@ocm1 dbs]$
③通过pfile重建spfile
[oracle@ocm1 dbs]$ exit exit
SYS@PROD> SYS@PROD>shutdown immediate Database closed. Database dismounted. ORACLE instance shut down.
SYS@PROD> create spfile from pfile;
File created.
SYS@PROD>