Error when performing Rman recovery
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:13ora-01103:database name ' powerdes ' in control file was not ' Pdunq ' RMAN&G T Exit
Solution:
sql> create pfile= '/oracle/pfile.12 ' from SPFile; File created. Sql> exitdisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit productionwith the Partiti Oning, OLAP, Data Mining and Real Application testing Options[[email protected] ~]$ vim/oracle/pfile.12*.db_name= ' Powerde S ' #这里原来是pdunq, convert it to powerdes, then save and exit [[email protected] ~]$ rlwrap sqlplus/as sysdbasql*plus:release 11.2.0.1.0 Product Ion on Wed Feb 3 21:39:56 2016Copyright (c) 1982, Oracle. All rights reserved. Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit productionwith The partitioning, OLAP, Data Mining and Real Application testing optionssql>sql> create SPFile from pfile= '/oracle/pfile.12 '; File created. Sql> Startup Nomountoracle instance started. Total System Global area 1453092864 bytesfixed size 2213416 bytesvariable size 855640536 bytesdatabase buffers 587202 560 Bytesredo Buffers 8036352 bytessql>
Then re-Rman quit login to perform the alter operation, you can alter the database mount.
[[email protected] ~]$ rlwrap rman target/recovery manager:release 11.2.0.1.0-production on Wed Feb 3 21:40:55 20 16Copyright (c) 1982, and/or, Oracle, and its affiliates. All rights reserved.connected to target database:powerdes (not mounted) rman> restore Controlfile to '/home/oradata/pow Erdes/control01.ctl ' from '/oracle/c-3391761643-20160203-01 '; Starting restore at 03-feb-16using target database control file instead of recovery catalogallocated channel:ora_disk_1ch Annel ora_disk_1:sid=20 device Type=diskchannel ora_disk_1:restoring control FileChannel ora_disk_1:restore complete, E Lapsed time:00:00:03finished restore at 03-feb-16rman> restore Controlfile to '/oracle/app/oracle/flash_recovery_ Area/powerdes/control02.ctl ' from '/oracle/c-3391761643-20160203-01 '; Starting restore at 03-feb-16using Channel Ora_disk_1channel ora_disk_1:restoring control FileChannel ora_disk_1:restor e Complete, elapsed time:00:00:03finished restore at 03-feb-16rman> alter DatabasE mount;database mountedreleased channel:ora_disk_1rman>
Rman Recovery error: ora-01103:database name ' powerdes ' in control file was not ' Pdunq '