In sweet memories of my ever loving brother "kutty thambi " ARUN KUMAR

Saturday, January 30, 2010

Error: ORA-16825: Fast-Start Failover and other errors or warnings detected for the database

ORA-16795:

database resource guard detects that database re-creation is required

ORA-16825:

Fast-Start Failover and other errors or warnings detected for the database

ORA-16817:

unsynchronized Fast-Start Failover configuration

solution:

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:

 
Share/Bookmark