0 Replies Latest reply on Aug 3, 2020 1:34 PM by rugbyRCT

    switchover to standby and error =

    rugbyRCT

      hello gurus,

       

         I have a problem with a switchover to 'standby';

      My version database is  Release 11.2.0.3.0

      The database standby is now primary, but the database was primary is not started gain in startup mount.

      see my instruction below :::

       

      regards

      JP

      >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

      dgmgrl /

      All is correct...

      show configuration verbose;

      Configuration - DRSolution_DBUXXX66

        Protection Mode: MaxAvailability

        Databases:

          DBUXXX66_fr0_aXXXdb_02 - Primary database

          DBUXXX66_fr0_aXXXdb_01 - Physical standby database

        Properties:

          FastStartFailoverThreshold      = '15'

          OperationTimeout                = '30'

          FastStartFailoverLagLimit       = '30'

          CommunicationTimeout            = '180'

          FastStartFailoverAutoReinstate  = 'TRUE'

          FastStartFailoverPmyShutdown    = 'TRUE'

          BystandersFollowRoleChange      = 'ALL'

      Fast-Start Failover: DISABLED

      Configuration Status:

      SUCCESS

       

      Therefore i execute ::::

      switchover to 'DBXXX66_fr0_XXXXdb_01';

      Performing switchover NOW, please wait...

      New primary database "DBXXX66_fr0_XXXXdb_01" is opening...

      Operation requires shutdown of instance "DBXXX66" on database "DBXXX66_fr0_xxxdb_02"

      Shutting down instance "DBXXX66"...

      ORACLE instance shut down.

      Operation requires startup of instance "DBXXX66" on database "DBXXX66_fr0_xxxdb_02"

      Starting instance "DBXXX66"...

      Unable to connect to database

      ORA-12545: Connect failed because target host or object does not exist

       

      Failed.

      Warning: You are no longer connected to ORACLE.

       

      >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

      show configuration verbose;

      Configuration - DRSolution_DBXXX66

        Protection Mode: MaxAvailability

        Databases:

          DBXXX66_fr0_xxxxdb_01 - Primary database

            Error: ORA-16810: multiple errors or warnings detected for the database

          DBXXX66_fr0_xxxxdb_02 - Physical standby database

            Error: ORA-01034: ORACLE not available