ORA-16802: downgrading redo transport mode from SYNC disallowed
Cause: An attempt was made to downgrade the redo transport mode of a standby database from SYNC to ASYNC when the configuration was in Maximum Protection or Maximum Availability mode and the primary database was a RAC database. This was not disallowed even though there may have been other standby databases with redo transport modes set to SYNC to support the protection mode.
Action: Do one of the following if the redo transport mode of the standby must be downgraded:

- Shut down all instances of the primary database and restart one instance with the initialization parameter CLUSTER_DATABASE set to FALSE. Downgrade the redo transport mode of the standby database of interest. Then, shutdown the instance, set the the CLUSTER_DATABASE initialization parameter to TRUE, and restart all primary database instances.

- Downgrade the protection mode to Maximum Performance mode and then, downgrade the redo transport mode of the standby database of interest. Finally, upgrade the protection mode. This will require a restart of all primary database instances if upgrading to Maximum Protection mode. Note that the above only works when there is at least one standby database in the configuration that has its redo transport mode set to SYNC.
ORA-16803
Custom Search


More Oracle errors
NNF-01006Attribute string not available
NID-00604No control files found in database
QSM-00804not enough space for mandatory access structures
ORA-13667Execution ID string does not exist.
ORA-13604The specified parameter string cannot be fetched as a SQL table.
NNL-00220Statistic counter logging is currently disabled
ORA-00493GMON process terminated with error
ORA-07757slemcc: invalid handle
ORA-13904The file has been dropped and recreated during the procedure call.
ORA-53001<TAG> and <TAG_RANGE> tag values are null
ORA-32774more than one file was specified for bigfile tablespace string
ORA-13376invalid type name specified for layer_gtype parameter
PCB-00638This attribute is only valid for internal or external LOB types
OCI-22063reading negative value [string] as unsigned
ORA-47344error updating Rule Set string, string
ORA-35280(SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 ...] [USING aggmap-name] [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 ...]] [FUNCDATA] [FORCEORDER] [PARALLEL #] [{FROM|FROMVAR} fromname [, fromname2 ...]]
ORA-53215cannot access ORDDataSource object with invalid source type
ORA-19596SPFILE already included
PCC-00014Undeclared SQL Identifier "string" at line number in file string
ORA-26696no streams data dictionary for object with number string and version number string from source database string




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
ORA-16802downgrading redo transport mode from SYNC disallowed