Oracle Database Tutorial: ORA-01103 error Parsing

1Environment Introduction:

This is a test library. After deleting all the parameter files, control files, and data files, we can restore the data.

I restored both the control file and parameter file, but the database could not be opened.ORA-01103: database name 'wwl' in control file is not 'dummy'Error

My database name is: WWL

2, Execution process:

Restore the parameter file:

RMAN & gt; setDBID = 5520179

Executing command: SET DBID

RMAN> restorespfile from autobackup;

Starting restore at 23-MAY-12

Using target database control file insteadof recovery catalog

Allocated channel: ORA_DISK_1

Channel 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-04

Channel ORA_DISK_1: SPFILE restore fromautobackup complete

Finished restore at 23-MAY-12

RMAN>

 

3, Recovery Control File

RMAN> restorecontrolfile from autobackup;

 

Starting restore at 23-MAY-12

Using channel ORA_DISK_1

 

Channel ORA_DISK_1: looking for autobackupon day: 20120523

Channel ORA_DISK_1: autobackup found: c-5520179-20120523-04

Channel ORA_DISK_1: control file restorefrom autobackup complete

Output filename =/DBSoft/product/10.2.0/db_1/dbs/cntrlWWL. dbf

Finished restore at 23-MAY-12

 

RMAN>

 

4, Error message:

RMAN> SQL 'alterdatabase mount ';

SQL statement: alter database mount

RMAN-00571: ========================================================== ==============================

RMAN-00569: ==================== error messagestack follows ======================

RMAN-00571: ========================================================== ==============================

RMAN-03009: failure of SQL command ondefault channel at 18:51:31

RMAN-11003: failure during parse/executionof SQL statement: alter database mount

ORA-01103: database name 'wwl' in controlfile is not 'dummy'

 

RMAN> alterdatabase mount;

Using target database control file insteadof recovery catalog

RMAN-00571: ========================================================== ==============================

RMAN-00569: ==================== error messagestack follows ======================

RMAN-00571: ========================================================== ==============================

RMAN-03002: failure of alter db command at05/23/2012 18:39:47

ORA-01103: database name 'wwl' in controlfile is not 'dummy'

 

SQL> alterdatabase mount;

Alter database mount

 

ERROR at line 1:

ORA-01103: database name 'wwl' in controlfile is not 'dummy'

 

Note: The problem is that the recovered control file is correct and has not been deployed on this machine.DUMMYOnly one instance isWWL.

 

Query instance information. The instance information is displayed correctly. YesWWL.

SQL> selectinstance_name, status from v $ instance;

 

INSTANCE_NAME STATUS

----------------------------

WWL STARTED

 

SQL> alterdatabase mount;----By the wayMount database;

Alter database mount

*

ERROR at line 1:

ORA-01103: database name 'wwl' in controlfile is not 'dummy'

 

Something strange happened. Now log on againRMAMActually, the connection isDUMMYLibrary:

The problem is, I'm sure I don't have this library. What should I 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

We just restored the parameter file and control file, or restarted the database to see if there were any problems.

SQL> shutdownimmediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startupmount;

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 1218968 bytes

Variable Size 79693416 bytes

Database Buffers 197132288 bytes

Redo Buffers 7168000 bytes

Database mounted.

Login again is normal.

[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 (DBID = 5520179, not open)

One of my brothers is AIX, Linux, WindowsThe results are as follows: WindowsNo need to restart the database, RmanYou can recognize it, but not DUMMYDatabase.

B. Run the command once every hour.

Interval => 'trunc (sysdate, 'hh') + 100'

C. Execution in one hour

Interval => 'sysdate + 123'

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12