ORA-16802: downgrading log transport mode from SYNC disallowed
Answer Posted / 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 View All Answers
IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier
invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity
IMG-02003: 2FF03 - incorrect color histogram feature specification
ORA-07497: sdpri: cannot create trace file 'string'; errno = string.
When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............
ORA-26082: load of overlapping segments on table string.string is not allowed
ORA-26027: unique index string.string partition string initially in unusable state
In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.
NZE-28868: Peer certificate chain check failed.
ORA-26032: index string.string loading aborted after string keys
NZE-28890: Entrust Login Failed
ORA-26029: index string.string partition string initially in unusable state
ORA-26028: index string.string initially in unusable state
ORA-26095: unprocessed stream data exists
IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created