Oracle初始化参数的恢复几种来源

原创飞天云和恩墨 2021-10-02

705

1.查看spfile.ora内容
strings spfilePROD.ora --将文件中的可打印字符串显示出来(可将二进制文件中的字符串显示出来)
2.Rman恢复spfile
Rman>startup nomout --当没有初始化文件时，Rman能以DUMMY实例启动，用于恢复spfile文件
Rman>restore spfile from '/u01/app/oracle/fast_recovery_area/PRODCDB/autobackup/2020_03_06/o1_mf_s_1034358071_h646oqky_.bkp';
3.创建参数文件
create pfile from memory; --instance还处于open状态
create pfile from spfile;
create spfile from pfile;
--查看alert_PRODCDB.log告警日志,直接利用非默认值创建静态初始化参数
Using parameter settings in server-side spfile /u01/app/oracle/product/12.2.0/dbhome_1/dbs/spfilePRODCDB.ora
System parameters with non-default values:
processes = 500
nls_language = "AMERICAN"
nls_territory = "AMERICA"
memory_target = 1584M
control_files = "/u01/app/oracle/oradata/PRODCDB/control01.ctl"
control_files = "/u01/app/oracle/oradata/PRODCDB/control02.ctl"
db_block_size = 8192
compatible = "12.2.0"
log_archive_dest_1 = "location=/u01/app/oracle/arch/"
db_recovery_file_dest = "/u01/app/oracle/fast_recovery_area/"
db_recovery_file_dest_size= 4G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = "oracle.com"
dispatchers = "(PROTOCOL=TCP) (SERVICE=PRODCDBXDB)"
local_listener = "LISTENER_PRODCDB"
audit_file_dest = "/u01/app/oracle/admin/PRODCDB/adump"
audit_trail = "DB"
db_name = "PRODCDB"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
enable_pluggable_database= TRUE