Shulou(Shulou.com)05/31 Report--

Rman how to restore spfile, I believe that many inexperienced people do not know what to do, so this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Experimental preparation

OGG (DBID=3068169019)

Spfile:/u01/app/oracle/fast_recovery_area/OGG/backupset/2018_03_26/o1_mf_ncsnf_TAG20180326T162759_fckd47yp_.bkp

We have two situations.

1. Do not know DBID, know backup path

two。 Know DBID

(1)。 Simulated deletion of 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)。 Start the database error report

SYS@ogg > startup force

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file'/ u01qapplash oracle.product11.2.0anddbhomeowners 1anddbsandinitogg.ora'

For the first case

1. Do not know DBID, know backup path

[oracle@ogg-80 ~] $rman target /

RMAN > startup nomount;-Boot to mount

Startup failed: ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file'/ u01qapplash oracle.product11.2.0anddbhomeowners 1anddbsandinitogg.ora'

Starting Oracle instance without parameter file for retrieval of spfile

Oracle instance started

Total System Global Area 1068937216 bytes

Fixed Size 2260088 bytes

Variable Size 281019272 bytes

Database Buffers 780140544 bytes

Redo Buffers 5517312 bytes

RMAN > restore spfile to'/ u01AccleUniverse products RMAN > oracle.ora'ora' from'/ u01ActionApplicationorAcleSome fastattach recoveryandOG backupsets2018 03' 26CsnfTAG20180326T162759fckd47ypype.bkp'

Starting restore at 26-MAR-18

Using channel ORA_DISK_1

Channel ORA_DISK_1: restoring spfile from AUTOBACKUP / u01/app/oracle/fast_recovery_area/OGG/backupset/2018_03_26/o1_mf_ncsnf_TAG20180326T162759_fckd47yp_.bkp

Channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete

Finished restore at 26-MAR-18

For the second case

two。 Know DBID

[oracle@ogg-80 ~] $rman target /

RMAN > set dbid=3068169019

Executing command: SET DBID

RMAN > startup nomount

Startup failed: ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file'/ u01qapplash oracle.product11.2.0anddbhomeowners 1anddbsandinitogg.ora'

Starting Oracle instance without parameter file for retrieval of spfile

Oracle instance started

Total System Global Area 1068937216 bytes

Fixed Size 2260088 bytes

Variable Size 281019272 bytes

Database Buffers 780140544 bytes

Redo Buffers 5517312 bytes

Method 1: use automatic backup

RMAN > restore spfile from autobackup

Automatic backup will report an error here, because we do not set up automatic backup.

Method 2: use manual backup

RMAN > restore spfile to'/ u01AccleUniverse products RMAN > oracle.ora'ora' from'/ u01ActionApplicationorAcleSome fastattach recoveryandOG backupsets2018 03' 26CsnfTAG20180326T162759fckd47ypype.bkp'

After reading the above, have you mastered how rman restores spfile? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.