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...


ORA-16802: downgrading log transport mode from SYNC disallowed



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

QSM-01060: illegal subquery in the HAVING clause

1 Answers  


ORA-02159: installed DLM does not support releasable locking mode

1 Answers  


PLS-00715: attribute or method by name 'string' does not exist

1 Answers  


PLS-00130: Pragma string expects 1st argument to be a procedure/function/package/cursor

1 Answers  


ORA-32816: foreign queue string is referenced by a subscriber or schedule

1 Answers  


ORA-22915: cannot ALTER a nested table's storage table to ADD/MODIFY columns

1 Answers  


PLS-00245: Formals used in the 'parameters' clause must appear exactly once

1 Answers  


PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

1 Answers  


PCC-00076: DISPLAY type must be SIGN LEADING SEPARATE

1 Answers  


RMAN-03017: recursion detected in stored script string

1 Answers  


TNS-02524: Authentication: privilege check failed

1 Answers  


PLS-00994: Cursor Variables cannot be declared as part of a package

1 Answers   CTS,


Categories