ORA-16795:
database resource guard detects that database re-creation is requiredORA-16825:
Fast-Start Failover and other errors or warnings detected for the databaseORA-16817:
unsynchronized Fast-Start Failover configurationsolution:
DGMGRL> show database rajesh
Database
Name: rajesh
Role: PRIMARY
Enabled: YES
Intended State: ONLINE
Instance(s):
rajesh
Current status for "rajesh":
Error: ORA-16825: Fast-Start Failover and other errors or warnings detected for the database
DGMGRL> show database jeyanthi
Database
Name: jeyanthi
Role: PHYSICAL STANDBY
Enabled: NO
Intended State: ONLINE
Instance(s):
jeyanthi
Current status for "jeyanthi":
Error: ORA-16661: the standby database needs to be reinstated
DGMGRL> reinstate database jeyanthi;
Reinstating database "jeyanthi", please wait...
Operation requires shutdown of instance "jeyanthi" on database "jeyanthi"
Shutting down instance "jeyanthi"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "jeyanthi" on database "jeyanthi"
Starting instance "jeyanthi"...
ORACLE instance started.
Database mounted.
Continuing to reinstate database "jeyanthi" ...
Reinstatement of database "jeyanthi" succeeded
DGMGRL> show configuration verbose;
Configuration
Name: jeyanthi
Enabled: YES
Protection Mode: MaxAvailability
Fast-Start Failover: ENABLED
Databases:
jeyanthi - Physical standby database
- Fast-Start Failover target
rajesh - Primary database
Fast-Start Failover
Threshold: 30 seconds
Observer: rac3
Current status for "jeyanthi":
Warning: ORA-16607: one or more databases have failed
then,
stop and start the observer.(start from another machine)
DGMGRL> stop observer
Done.
DGMGRL> connect sys/oracle@jeyanthi
Connected.
DGMGRL> start observer
Observer started
DGMGRL> show configuration verbose
Configuration
Name: jeyanthi
Enabled: YES
Protection Mode: MaxAvailability
Fast-Start Failover: ENABLED
Databases:
jeyanthi - Physical standby database
- Fast-Start Failover target
rajesh - Primary database
Fast-Start Failover
Threshold: 30 seconds
Observer: rac2
Current status for "jeyanthi":
SUCCESS
regards,
rajeshkumar g
No comments:
Post a Comment