当前位置：首页 > news >正文

19c-pfile

news 2025/7/5 3:05:53

经常需要rman恢复测试，创建一个单机pfile，需要时手动修改使用，以20g内存为例

orcl.__data_transfer_cache_size=0
orcl.__db_cache_size=13824425984
orcl.__inmemory_ext_roarea=0
orcl.__inmemory_ext_rwarea=0
orcl.__java_pool_size=0
orcl.__large_pool_size=100663296
orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=5368709120
orcl.__sga_target=16106127360
orcl.__shared_io_pool_size=134217728
orcl.__shared_pool_size=2013265920
orcl.__streams_pool_size=0
orcl.__unified_pga_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_sys_operations=TRUE
*.audit_trail='DB','EXTENDED'
*.compatible='19.0.0'
*.control_file_record_keep_time=14
*.control_files='/data/ORCL/controlfile/o1_mf_mh9dbyb5_.ctl','/fra/ORCL/controlfile/o1_mf_mh9dbybz_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/data'
*.db_create_online_log_dest_1='/data'
*.db_create_online_log_dest_2='/fra'
*.db_name='orcl'
*.deferred_segment_creation=FALSE
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.local_listener=''
*.log_archive_dest_1='LOCATION=/fra/orcl'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_limit=0
*.pga_aggregate_target=5120m
*.processes=2560
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=15360m
*.undo_tablespace='UNDOTBS1'