Rman Recovery error: ora-01103:database name ' powerdes ' in control file was not ' Pdunq '

Source: Internet
Author: User

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 '

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.