Skip to Main Content

Oracle Database Discussions

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!

Primary Database Can not be opened?

548150Jul 12 2008 — edited Aug 13 2008
After setting up the physical standby database and configuring the Configuration, Fast_start failover and Observer, every things are OK. But after shutting down the primary database without first stopping the observer, the primary can not be opened(can only be mounted) an more. The fast_start failover cannot be disabled.
What should I do to repair it?
SQL> startup
ORACLE instance started.

Total System Global Area 448790528 bytes
Fixed Size 1219904 bytes
Variable Size 159384256 bytes
Database Buffers 281018368 bytes
Redo Buffers 7168000 bytes
Database mounted.
ORA-16649: database will open after Data Guard broker has evaluated Fast-Start
Failover status
DGMGRL> show configuration

Configuration
Name: sdb10g
Enabled: YES
Protection Mode: MaxAvailability
Fast-Start Failover: ENABLED
Databases:
sdb10g - Primary database
stdby10g - Physical standby database
- Fast-Start Failover target

Current status for "sdb10g":
Warning: ORA-16607: one or more databases have failed


DGMGRL> disable fast_start failover;
Error: ORA-12560: TNS:protocol adapter error

Failed.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2008
Added on Jul 12 2008
1 comment
1,145 views