Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

ORA-16802: downgrading log transport mode from SYNC disallowed

Question Posted / guest


ORA-16802: downgrading log transport mode from SYNC disallowed..

Answer / guest

Cause: An attempt was made to downgrade the log transport
mode of a standby database from SYNC to ASYNC or ARCH when
the configuration was in Maximum Protection or Maximum
Availability mode and the primary database was a RAC
database. This is not allowed, even if there are other
standby databases with log transport modes set to SYNC to
support the data protection mode.

Action: You can do one of the following if you need to
downgrade the log transport mode of the standby: (1) Shut
down all instances of the primary database and restart one
instance with initialization parameter CLUSTER_DATABASE set
to FALSE. Downgrade the log transport mode, shutdown the
instance, and restart all instances with CLUSTER_DATABASE
set to TRUE. (2) Downgrade the protection mode to Maximum
Performance mode first. Then downgrade the log transport
mode, then upgrade the protection mode again (which involves
a shutdown and restart of the primary database). Note that
the above only works when there exists at least one more
standby database in the configuration that has the log
transport mode set to SYNC.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL-02150: Encountered zero length in ANSI dynamic SET statement

1 Answers  

ORA-33447: (ESDREAD16) Discarding compiled code for workspace object because workspace object and workspace object, which were partition-dependent when the code was compiled, are now not partition-dependent.

1 Answers  

EXP-00038: Bad Hash cluster id in clu$

1 Answers  

ORA-27128: unable to determine pagesize

1 Answers  

ORA-01568: cannot set space quota on PUBLIC

1 Answers  

NNL-01007: VERSION SKEW responses received: number

1 Answers  

ORA-22279: cannot perform operation with LOB buffering enabled

1 Answers  

DRG-10702: cannot create or modify preference in another user's schema

1 Answers  

ORA-10621: data block does not belong to the segment

1 Answers  

RMAN-06092: error while looking up backup piece

1 Answers  

QSM-01031: materialized view, string, is stale in TRUSTED integrity mode

1 Answers  

ORA-06736: TLI Driver: server not running

1 Answers  

For more Oracle Errors Interview Questions Click Here
Categories