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

9769869

执行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>