Oracle shutdown（关闭）状态下从spfile中创建pfile

[oracle@db ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 28 16:37:02 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> create pfile='/home/oracle/0628.ora' from spfile;

File created.

[oracle@db ~]$ cat 0628.ora 

orcl.__db_cache_size=88080384

orcl.__java_pool_size=4194304

orcl.__large_pool_size=8388608

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

orcl.__pga_aggregate_target=209715200

orcl.__sga_target=205520896

orcl.__shared_io_pool_size=0

orcl.__shared_pool_size=96468992

orcl.__streams_pool_size=0

*.aq_tm_processes=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/oradata/orcl/control02.ctl'#Restore Controlfile

*.db_block_size=8192

*.db_domain=''

*.db_name='orcl'

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

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

*.fal_client='ORCL'

*.fal_server='DGLOCAL','DGSH'

*.java_jit_enabled=TRUE

*.job_queue_processes=0

*.log_archive_config='DG_CONFIG=(orcl,dglocal,dgsh)'

*.log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog/'

*.log_archive_dest_2='SERVICE=dglocal LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dglocal'

*.log_archive_dest_3='SERVICE=dgsh LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dgsh'

*.log_archive_dest_state_1='ENABLE'

*.log_archive_dest_state_2='ENABLE'

*.log_archive_dest_state_3='ENABLE'

*.memory_target=414187520

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.standby_file_management='AUTO'

*.undo_tablespace='UNDOTBS1'