RMAN恢复报错： ORA-01103: database name 'POWERDES' in control file is not 'PDUNQ'

执行rman恢复的时候报错

 

RMAN> alter database mount;


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/03/2016 21:29:13
ORA-01103: database name 'POWERDES' in control file is not 'PDUNQ'


RMAN> exit

 

 

 

解决方案：

 

 

 

SQL> create pfile='/oracle/pfile.12' from spfile;


File created.


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@pldb1 ~]$ vim /oracle/pfile.12
*.db_name='powerdes'  #这里原来是pdunq，将之换成powerdes即可，然后保存退出


[oracle@pldb1 ~]$ rlwrap sqlplus / as sysdba


SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 3 21:39:56 2016


Copyright (c) 1982, 2009, Oracle.  All rights reserved.




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL>
SQL> create spfile from pfile='/oracle/pfile.12';


File created.


SQL> startup nomount
ORACLE instance started.


Total System Global Area 1453092864 bytes
Fixed Size		    2213416 bytes
Variable Size		  855640536 bytes
Database Buffers	  587202560 bytes
Redo Buffers		    8036352 bytes
SQL> 

然后重新rman退出登录执行alter操作搞定，可以alter database mount了

 

[oracle@pldb1 ~]$ rlwrap rman target /


Recovery Manager: Release 11.2.0.1.0 - Production on Wed Feb 3 21:40:55 2016


Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


connected to target database: POWERDES (not mounted)


RMAN> restore controlfile to '/home/oradata/powerdes/control01.ctl' from '/oracle/c-3391761643-20160203-01';


Starting restore at 03-FEB-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK


channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 03-FEB-16


RMAN> restore controlfile to '/oracle/app/oracle/flash_recovery_area/powerdes/control02.ctl' from '/oracle/c-3391761643-20160203-01';


Starting restore at 03-FEB-16
using channel ORA_DISK_1


channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 03-FEB-16


RMAN> alter database mount;


database mounted
released channel: ORA_DISK_1


RMAN>