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;  ------启动到mount

startup failed: 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'

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 '/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-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

针对第二种情况

2.知道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 '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initogg.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 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';