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!

ORA-01666: controlfile is for a standby database - My DB Doesn't OPEN

Cac47Dec 7 2009 — edited Dec 7 2009
dear Gurus,

I've created a Standby, and Configured the Dataguard no issues.

I've start a swtchover into Site 2
After half an Hour without responding I cancle the operation.
Now I'm facing this Situation, My Standby Site still Ok but my Prod Database shows ORA-01666: controlfile is for a standby database
What shall i do?
When I check the Config in the Dataguard Broker everything seems ok for SITE 2

DGMGRL> show site verbose 'CFMP_SITE2';
Site
Name: 'CFMP_SITE2'
Hostname: 'srvsdmwebp02'
Instance name: 'CFMP'
Service Name: 'CFMP_SITE2'
Standby Type: 'physical'
Number Built-in Processes: '2'
Number Generic Processes: '0'
Enabled: 'yes'
Required: 'yes'
Default state: 'STANDBY'
Intended state: 'STANDBY'
PFILE: ''
Number of resources: 1
Resources:
Name: CFMP_SITE2 (default) (verbose name='CFMP_SITE2')
Current status for "CFMP_SITE2":
SUCCESS
DGMGRL>

But in Site 1 it's different
DGMGRL>
DGMGRL> show site verbose 'CFMP_SITE1';
Site
Name: 'CFMP_SITE1'
Hostname: 'srvsdmwebp01'
Instance name: 'CFMP'
Service Name: 'CFMP_RW.world'
Standby Type: 'physical'
Number Built-in Processes: '2'
Number Generic Processes: '0'
Enabled: 'yes'
Required: 'yes'
Default state: 'PRIMARY'
Intended state: 'PRIMARY'
PFILE: ''
Number of resources: 1
Resources:
Name: CFMP_SITE1 (default) (verbose name='CFMP_SITE1')
Current status for "CFMP_SITE1":
Warning: ORA-16609: one or more resources have failed
How shall I proceed ?
Thxs
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2010
Added on Dec 7 2009
13 comments
15,284 views