Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Standby Database is Idle

Thunder2777Apr 17 2013 — edited Apr 18 2013
HI There

I have configured Data Guard on oracle 10g (10.2.0.4) on Windows 2007 64 bits Server.
Both Primary DB and Standby DB are on same Server.

When I connect to my Primary DB, It is connected Normally as shown below.

Start --> Run --> CMD --> set oracle_sid=prmdb

c:\> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Apr 17 09:48:22 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>

Now Whenever I connect to my Standby DB, It connects to an Idle Instance. When I issue startup command
it displays a Message as shown below.

Start --> Run --> CMD --> set oracle_sid=stldb

c:\> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Apr 17 09:48:22 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size 2065408 bytes
Variable Size 318770176 bytes
Database Buffers 922746880 bytes
Redo Buffers 14708736 bytes
Database mounted.
ORA-16004: backup database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\STLDB\SYSTEM01.DBF'

Then I issue following commands to overcome this

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT
FROM SESSION;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Database altered.

SQL> ALTER DATABASE OPEN;

Database altered.

What is wrong with my Standby DB?
What to do to overcome these messages Permanently?
Why Standby DB is Not connected Normally instead of I have to start it?

Regards
Thunders2777
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 16 2013
Added on Apr 17 2013
10 comments
1,497 views