rman怎么恢复spfile

rman怎么恢复spfile，相信很多没有经验的人对此束免费主机域名手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。实验准备OGG (DBID=3068169019)spfile：/u01/app/oracle/fast_recovery_area/OGG/backupset/2018_03_26/o1_mf_ncsnf_TAG20180326T162759_fckd47yp_.bkp
我们分两种情况1.不知道DBID，知道备份路径2.知道DBID（1）.模拟删除spfile
[oracle@ogg-80 dbs]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs
[oracle@ogg-80 dbs]$ mv spfileogg.ora spfileogg.ora.bak （2）.启动数据库报错
SYS@ogg> startup force;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initogg.ora’
针对第一种情况1.不知道DBID，知道备份路径[oracle@ogg-80 ~]$ rman target /RMAN> startup nomount; ——免费主机域名启动到mountstartup failed: ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initogg.ora’starting Oracle instance without parameter file for retrieval of spfileOracle instance startedTotal System Global Area1068937216 bytesFixed Size2260088 bytesVariable Size281019272 bytesDatabase Buffers780140544 bytesRedo Buffers5517312 bytesRMAN> restore spfile to ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileogg.ora’ from ‘/u01/app/oracle/fast_recovery_area/OGG/backupset/2018_03_26/o1_mf_ncsnf_TAG20180326T162759_fckd47yp_.bkp’;Starting restore at 26-MAR-18using channel ORA_DISK_1channel ORA_DISK_1: restoring spfile from AUTOBACKUP /u01/app/oracle/fast_recovery_area/OGG/backupset/2018_03_26/o1_mf_ncsnf_TAG20180326T162759_fckd47yp_.bkpchannel ORA_DISK_1: SPFILE restore from AUTOBACKUP completeFinished restore at 26-MAR-18
针对第二种情况2.知道DBID
[oracle@ogg-80 ~]$ rman target /RMAN> set dbid=3068169019
executing command: SET DBIDRMAN> startup nomount;startup failed: ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initogg.ora’starting Oracle instance without parameter file for retrieval of spfileOracle instance startedTotal System Global Area1068937216 bytesFixed Size2260088 bytesVariable Size281019272 bytesDatabase Buffers780140544 bytesRedo Buffers5517312 bytes方法一：利用自动备份RMAN> restorespfile from autobackup;
自动备份这里会报错，因为我们没有设置自动备份方法二：利用手动备份RMAN> restore spfile to ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileogg.ora’ from ‘/u01/app/oracle/fast_recovery_area/OGG/backupset/2018_03_26/o1_mf_ncsnf_TAG20180326T162759_fckd47yp_.bkp’;看完上述内容，你们掌握rman怎么恢复spfile的方法了吗？如果还想学到更多技能或想了解更多相关内容，欢迎关注云技术行业资讯频道，感谢各位的阅读！

相关推荐: 微服务架构有哪些特征

这篇文章主要介绍“微服务架构有哪些特征”，在日常操作中，相信很多人在微服务架构有哪些特征问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”免费主机域名微服务架构有哪些特征”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！架构特征如下…