ORA-01103 error parsing 1, Environment Introduction: this is a test library, I Will parameter files, control files, data files all deleted after doing data recovery, but I restored the control file and parameter file back, but the database but how can not open, report ORA-01103: database name 'wwl' in control file is not 'dummy' error my database name is: WWL www.2cto.com 2. Execution Process: Restore parameter file: RMAN> setDBID = 5520179 executing command: set dbid rman> restorespfile from autobackup; Starting restore at 23-MAY-12using target database control file insteadof recovery catalogallocated channel: ORA_DISK_1ch Annel ORA_DISK_1: sid = 39 devtype = DISK channel ORA_DISK_1: looking for autobackupon day: 20120523 channel ORA_DISK_1: autobackup found: c-5520179-20120523-04channel ORA_DISK_1: SPFILE restore fromautobackup completeFinished restore at 23-MAY-12 restore RMAN> 3. restore control file RMAN> restorecontrolfile from autobackup; Starting restore at 23-MAY-12using channel ORA_DISK_1 channel ORA_DISK_1: looking for aut Obackupon day: 20120523 channel ORA_DISK_1: autobackup found: c-5520179-20120523-04channel ORA_DISK_1: control file restorefrom autobackup completeoutput filename =/DBSoft/product/10.2.0/db_1/dbs/cntrlWWL. dbfFinished restore at 23-MAY-12 RMAN> 4. error message: RMAN> SQL 'alterdatabase mount'; SQL statement: alter database mountRMAN-00571: ========================================================== ============================== RMAN-00569: === ============ Error messagestack follows ========================= RMAN-00571: ========================================================== ============================== RMAN-03009: failure of SQL command ondefault channel at 05/23/2012 18: 51: 31RMAN-11003: failure during parse/executionof SQL statement: alter database mountORA-01103: database name 'wwl' in controlfile is not 'dummy' RMAN> alterdatabase mount; using target database control fil E insteadof recovery catalogRMAN-00571: ========================================================== ============================== RMAN-00569: ================ error messagestack follows ======================== RMAN-00571: ========================================================== ============================== RMAN-03002: failure of alter db command at05/23/2012 18: 39: 47ORA-01103: database name 'wwl' in controlfile is not 'dummy' SQL> alterdatabase mount; www.2cto.com Lter database mount ERROR at line 1: ORA-01103: database name 'wwl' in controlfile is not 'dummy' note: the problem is that my recovered control file is correct, no DUMMY database has been deployed on this machine. Only one instance is WWL. Query instance information. The instance information is displayed correctly. It is WWL. SQL> selectinstance_name, status from v $ instance; INSTANCE_NAME STATUS ---------------------- wwl started SQL> alterdatabase mount; ---- by the way, the mount database; alter database mount * ERROR at line 1: ORA-01103: database name 'wwl' in controlfile is not 'dummy' strange thing happened. Now I log on to RMAM again to connect to the DUMMY database: the problem is, I'm sure I don't have this database, what to do... [Oracle @ wwldb dbs] $ rman target/Recovery Manager: Release 10.2.0.1.0-Production on Wed May 23 19:01:09 2012 Copyright (c) 1982,200 5, Oracle. all rights reserved. connected to target database: DUMMY (notmounted) RMAN> exit www.2cto.com we just restored the parameter file and control file, or restart the database to see if there is any problem. SQL> shutdownimmediateORA-01507: database not mounted ORACLE instance shut down. SQL> startupmount; ORACLE instance started. total System Global Area 285212672 bytesFixed Size 1218968 bytesVariable Size 79693416 bytesDatabase Buffers 197132288 bytesRedo Buffers 7168000 bytesDatabase mounted. www.2cto.com. [Oracle @ wwldb dbs] $ rman target/Recovery Manager: Release 10.2.0.1.0-Production on Wed May 23 19:04:15 2012 Copyright (c) 1982,200 5, Oracle. all rights reserved. connected to target database: WWL, rman can recognize it, not the DUMMY database. Author Wu weilong