ORA-16706: no resource guard is available
Cause: Resource guard was not available to service the request.
Action: Contact Oracle Support Services.
ORA-16707: the value of the property string is invalid, valid values are string
Cause: An invalid property value was entered while broker management of the database was disabled.
Action: Reset the property to a valid value.
ORA-16708: the state supplied to broker is invalid
Cause: The state name specified was invalid for the database.
Action: Check the state name and reissue the request.
ORA-16709: standby archived log location settings conflict with database recovery area
Cause: The StandbyArchiveLocation or AlternateLocation property was set to USE_DB_RECOVERY_FILE_DEST, but the initialization parameter DB_RECOVERY_FILE_DEST did not specify a valid destination.
Action: Use a value other than USE_DB_RECOVERY_FILE_DEST for StandbyArchiveLocation or AlternateLocation, or set up a valid database recovery area by setting DB_RECOVERY_FILE_DEST to a valid destination.
ORA-16713: the Data Guard broker command timed out
Cause: The Data Guard broker timed out the command.
Action: Verify that the command is valid for the database and then retry the command.
ORA-16714: the value of property string is inconsistent with the database setting
Cause: The value of the specified configuration property was inconsistent with database in-memory settings or server parameter file settings. This may be caused by changing an initialization parameter that corresponds to a configuration property.
Action: Query the InconsistentProperties property on the database to determine the which properties are set inconsistently. Reset the properties to make them with the database settings.
ORA-16715: redo transport-related property string of standby database "string" is inconsistent
Cause: The value of the specified redo transport-related configuration property of the given standby database was inconsistent with the primary database redo transport service setting. This may be caused by changing an initialization parameter that corresponds to a configuration property.
Action: Query the InconsistentLogXptProps property on the primary database to determine which redo transport properties are set inconsistently Reset the properties on the standby database to make them consistent with the primary database redo transport settings.
ORA-16716: clearing parameter LOG_ARCHIVE_DEST failed
Cause: An attempt to clear the LOG_ARCHIVE_DEST parameter failed.
Action: Contact Oracle Support Services.
ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed
Cause: An attempt to clear the LOG_ARCHIVE_DUPLEX_DEST parameter failed.
Action: Contact Oracle Support Services.
ORA-16718: failed to locate database
Cause: The Data Guard broker was unable to locate the database in the broker configuration.
Action: Add the database to the broker configuration and then reissue the command.
ORA-16719: unable to query V$ARCHIVE_DEST fixed view
Cause: The broker failed to query the V$ARCHIVE_DEST fixed view."
Action: Test and clear the problem using SQL*Plus.
ORA-16720: no LOG_ARCHIVE_DEST_n initialization parameters available
Cause: All LOG_ARCHIVE_DEST_n initialization parameters were in use.
Action: Clear one or more LOG_ARCHIVE_DEST_n initialization parameters so that broker can use them to setup the primary database redo transport.
ORA-16721: unable to set LOG_ARCHIVE_DEST_n initialization parameters
Cause: The broker was unable to set one or more LOG_ARCHIVE_DEST_n initialization parameters.
Action: Check the Data Guard broker log and Oracle alert logs for more details.
ORA-16722: unable to set LOG_ARCHIVE_DEST_STATE_n initialization parameters
Cause: The broker was unable to set one or more LOG_ARCHIVE_DEST_STATE_n initialization parameters.
Action: Check the Data Guard broker log and Oracle alert logs for more details.
ORA-16723: setting AlternateLocation property conflicts with the redo transport setting
Cause: The standby database was not using standby redo logs, and the redo transport service to the standby database is set to a nonzero value for the ReopenSecs property and a value of zero for the MaxFailure property. In this case, the redo transport service will attempt to send redo data to the standby database indefinitely and never switch to the alternate destination.
Action: Any one of the following actions will solve the problem:
- add standby redo logs to the standby database.
- set ReopenSecs property to zero.
- set MaxFailure property to a nonzero value. After performing one of the above actions, reset the standby database AlternateLocation property.
ORA-16727: cannot close database
Cause: The Data Guard broker could not close the database.
Action: Terminate any active sessions connected to the database and then reissue the request.
ORA-16728: consistency check for property string found string error
Cause: The consistency check for the specified property failed due to the error shown.
Action: Check the error message and clear the error.
ORA-16729: validation of value for property string found string error
Cause: The property value validation failed due to the error shown.
Action: Check the error message and clear the error.
ORA-16730: error executing DBMS_LOGSTDBY.SKIP_TXN procedure
Cause: Logical standby database package may not be installed.
Action: Install logical standby database packages and reissue the request.
ORA-16731: error executing DBMS_LOGSTDBY.UNSKIP_TXN procedure
Cause: Logical standby database package may not be installed.
Action: Install logical standby database packages and reissue the request.
ORA-16732: error executing DBMS_LOGSTDBY.SKIP procedure
Cause: Logical standby database package may not be installed.
Action: Install logical standby database packages and reissue the request.
ORA-16733: error executing DBMS_LOGSTDBY.UNSKIP procedure
Cause: Logical standby database package may not be installed.
Action: Install logical standby database packages and reissue the request.
ORA-16734: error executing DBMS_LOGSTDBY.SKIP_ERROR procedure
Cause: Logical standby database package may not be installed.
Action: Install logical standby database packages and reissue the request.
ORA-16735: error executing DBMS_LOGSTDBY.UNSKIP_ERROR procedure
Cause: Logical standby database package may not be installed.
Action: Install logical standby database packages and reissue the request.
ORA-16736: unable to find the destination entry of standby database "string" in V$ARCHIVE_DEST
Cause: Either the standby destination was manually changed or deleted outside of Data Guard broker, or no entry was available for the Data Guard broker to use.
Action: Clean up the destination setting, remove the unused settings, and reset the redo transport service.
ORA-16737: the redo transport service for standby database "string" has an error
Cause: A communication problem with the standby database caused the redo transport to fail.
Action: Query the LogXptStatus property to see the error message. Check the Data Guard broker log and Oracle alert log for more details.
ORA-16738: redo transport service for database "string" is not running
Cause: The redo transport service for the specified standby database was not running.
Action: Check the Data Guard broker log and/or the alert log for more details. If necessary, start the redo transport service for the standby database.
ORA-16739: redo transport service for standby database "string" is running
Cause: The redo transport service for the standby database was running.
Action: Check the Data Guard broker log for more details. If necessary, stop the redo transport service for the standby database.
ORA-16740: redo transport service for standby database "string" incorrectly set to ALTERNATE
Cause: The redo transport service to the standby database was set to ALTERNATE when no other destination was set to alternate to this destination.
Action: Reenable the standby database or the entire configuration to allow the configuration property settings to be propagated to the initialization parameters.
ORA-16741: the destination parameter of standby database "string" has incorrect syntax
Cause: The destination defined in the server parameter file of the primary database had incorrect syntax and Data Guard broker failed to update the destination when redo transport services were enabled.
Action: Fix the syntax error in the primary database server parameter file or remove the entry from the server parameter file. Also, check the values of the redo transport-related properties for the specified standby database.
ORA-16742: the standby database "string" has exhausted its quota
Cause: The standby database exhausted its quota for storing archived redo logs.
Action: Remove some archived redo logs from the standby database or increase its quota.
ORA-16743: cannot determine status of redo transport service for standby database "string"
Cause: The status of redo transport to the specified standby database could not be determined.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16744: the DG_CONFIG list of LOG_ARCHIVE_CONFIG parameter is full
Cause: The DG_CONFIG list of the LOG_ARCHIVE_CONFIG attribute was full and the Data Guard broker was not able to add a new DB_UNIQUE_NAME to the list.
Action: Remove some unused entries in the DG_CONFIG list, then reenable the database.
ORA-16745: unable to add DB_UNIQUE_NAME "string" into the DG_CONFIG list because it is full
Cause: The DG_CONFIG list of the LOG_ARCHIVE_CONFIG attribute was full and the Data Guard broker was not able to add the specified DB_UNIQUE_NAME to the list.
Action: Remove some unused entries in the DG_CONFIG list, then reenable the database.
ORA-16746: Data Guard broker cannot mount the database
Cause: The Data Guard broker failed to mount the database."
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16747: logical standby database guard could not be turned on
Cause: The Data Guard broker could not turn on the logical standby database guard.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16748: Data Guard broker cannot open the primary database
Cause: The Data Guard broker failed to open the primary database" the database.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16749: switchover to logical standby database failed
Cause: The Data Guard broker failed to switch a logical standby database over to a primary database.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16750: failed to activate logical standby database
Cause: The Data Guard broker failed to activate a logical standby database.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16751: failed to switchover to physical standby database
Cause: The Data Guard broker failed to switch a physical standby database over to a primary database.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16753: Data Guard broker cannot open standby database
Cause: The Data Guard broker failed to open the standby database.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16754: failed to activate physical standby database
Cause: The Data Guard broker failed to activate the physical standby database.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16755: failed to set initialization parameter
Cause: The Data Guard broker failed to set an initialization parameter using either the ALTER SYSTEM SET or ALTER SYSTEM RESET command.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16757: unable to get this property's value
Cause: The Data Guard broker failed to get the value for the specified property, possibly because the specified property's value is not available for the current database role.
Action: If the specified property's value is not available for the database's current role, please specify this property for a database for which it is available. Otherwise, check the Data Guard broker log for more details.
ORA-16758: the specified apply instance is not running
Cause: The Data Guard broker could not start apply services on the specified instance because that instance was not running.
Action: Start the instance and then retry the command.
ORA-16759: cannot start SQL Apply with initial SCN
Cause: The Data Guard broker failed to start SQL Apply with an initial SCN.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16760: cannot start SQL Apply
Cause: The Data Guard broker failed to start SQL Apply.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16761: cannot stop SQL Apply
Cause: The Data Guard broker failed to stop SQL Apply.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16762: invalid database state
Cause: Database was not in the intended state.
Action: Determine the reason why the database is not running in the intended state and reissue the command.
ORA-16763: redo transport service for a standby database is running
Cause: The redo transport service for a standby database was running.
Action: Query the StatusReport property of the primary database for more details. If necessary, stop the redo transport service for the database.
ORA-16764: redo transport service to a standby database is not running
Cause: The redo transport service to a standby database was not running.
Action: Query the StatusReport property of the primary database for more details. If necessary, start the redo transport service.
ORA-16765: Redo Apply is running
Cause: Redo Apply was running when it should have been stopped.
Action: If necessary, stop Redo Apply.
ORA-16766: Redo Apply is stopped
Cause: Redo Apply was stopped when it should have been running.
Action: If necessary, start Redo Apply.
ORA-16767: SQL Apply is running
Cause: SQL Apply was running when it should have been stopped."
Action: If necessary, stop SQL Apply.
ORA-16768: SQL Apply is stopped
Cause: SQL Apply was stopped when it should have been running."
Action: If necessary, start SQL Apply.
ORA-16769: the physical standby database is open read-only
Cause: All instances in the physical standby database were put into a read-only state instead of APPLY-OFF.
Action: Issue the EDIT DATABASE SET STATE command to set the database to the APPLY-OFF state.
ORA-16770: Redo Apply not started since physical standby database is opening
Cause: Redo Apply services could not be started on the physical standby database because it was being opened. The Data Guard broker will start Redo Apply services once the physical standby database has been opened.
Action: No action required.
ORA-16771: failover to a physical standby database failed
Cause: The Data Guard broker encountered errors when converting a physical standby database to a primary database.
Action: Check the Data Guard broker log and the Oracle alert log for more details about the error.
ORA-16772: switchover to a standby database failed
Cause: The Data Guard broker encountered errors when switching over to the specified standby database.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16773: cannot start Redo Apply
Cause: The Data Guard broker failed to start Redo Apply.
Action: Check the Data Guard broker log and Oracle alert log for more details. If the database is already open, the broker will not be able to start Redo Apply if the COMPATIBLE initialization parameter is set to a value less than 11.0.
ORA-16774: cannot stop Redo Apply
Cause: The Data Guard broker failed to stop Redo Apply.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16775: target standby database in broker operation has potential data loss
Cause: The target standby database specified for the broker operation did not have all the redo data from the primary database.
Action: Confirm that the redo transport service on the primary database is functioning correctly by checking its status using the StatusReport monitorable property. Reissue the broker command once all redo data is available on the target standby database.
ORA-16776: health check of the redo transport service failed
Cause: The Data Guard broker could not complete the health check for the redo transport service.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16777: unable to find the destination entry of a standby database in V$ARCHIVE_DEST
Cause: Either a destination was manually deleted or no entry was available for Data Guard.
Action: Check the Data Guard broker log and the Oracle alert log for more details. The redo transport service may need to be reset.
ORA-16778: redo transport error for one or more databases
Cause: The redo transport service was unable to send redo data to one or more standby databases.
Action: Check the Data Guard broker log and Oracle alert log for more details. Query the LogXptStatus property to see the errors.
ORA-16779: the destination parameter of a database is set incorrectly
Cause: The destination was defined in the LOG_ARCHIVE_DEST_n server parameter file with incorrect syntax. The Data Guard broker failed to update the destination when the redo transport was turned on.
Action: Check the Data Guard broker log to see which database has the problem. Fix the syntax error in the server parameter file or remove the entry from the server parameter file. Check if the syntax of the redo transport-related properties are correct.
ORA-16780: a database has exhausted its archived redo log storage quota
Cause: A database has exhausted its quota for storing archived redo logs.
Action: Check the Data Guard broker log to see which database has the problem. Remove some archived logs at the standby database or increase its quota.
ORA-16781: cannot determine status of redo transport service for standby database
Cause: The status of redo transport to the specified standby database could not be determined.
Action: Check the Data Guard broker log and Oracle alert log for more details.
ORA-16782: instance not open for read and write access
Cause: The database was mounted on an instance but not opened for read and write access.
Action: Check the StatusReport property for more details and, if possible, open the instance manually.
ORA-16783: instance string not open for read and write access
Cause: The database was mounted on an instance but not opened for read and write access.
Action: Check the StatusReport property for more details and, if possible open the instance manually.
ORA-16784: database name specified by Dependency property is incorrect
Cause: The database name, that should be the value of the DB_UNIQUE_NAME initialization parameter, specified in the Dependency property was incorrect.
Action: Reset the Dependency property to the correct name of the database.
ORA-16785: the database is in NOARCHIVELOG mode
Cause: The database was in NOARCHIVELOG mode when it was either a primary database or when it was a standby database that was being switched over to be a primary database.
Action: Set the database to ARCHIVELOG mode by issuing the ALTER DATABASE ARCHIVELOG command.
ORA-16786: unable to access Data Guard broker metadata
Cause: The Data Guard broker configuration files did not exist or for some other reason the Data Guard broker configuration metadata could not be accessed.
Action: Check the Data Guard broker log for more details.
ORA-16788: unable to set one or more database configuration property values
Cause: This situation occurred when the broker attempted to set database configurable property values into the database by issuing ALTER SYSTEM or ALTER DATABASE commands. Typical causes of this error are:
- The values of redo transport-related properties contain syntax syntax errors.
- The value of the LogArchiveTrace property was out of range.
Action: Check the Data Guard broker log to see which property has the problem and set the property to the correct value.
ORA-16789: standby redo logs not configured
Cause: Standby redo logs were not configured for the database.
Action: Standby redo logs are required when the redo transport mode is set to SYNC or ASYNC. Check the Data Guard documentation to see how to create standby redo logs.
ORA-16790: the value of the configurable property is invalid
Cause: An invalid property value was entered.
Action: Reset the property to a correct value.
ORA-16791: unable to check the existence of the standby redo logs
Cause: The database may not be mounted, or the query of the V$STANDBY_LOG fixed view failed.
Action: Ensure the database is mounted and query the V$STANDBY_LOG fixed view to see if the problem has been corrected, and retry the operation.
ORA-16792: configurable property value is inconsistent with database setting
Cause: The values of one or more configurable properties were inconsistent with database in-memory settings or server parameter file settings. This may happen by directly altering initialization parameters instead of editing configurable property values using Data Guard broker.
Action: Query the InconsistentProperties property on the database or check the Data Guard broker log to find which properties are set inconsistently. Reset these properties to make them consistent with the database settings. Alternatively, enable the database or the entire configuration to allow the configurable property settings to be propagated to the initialization parameters.
ORA-16793: logical standby database guard is off
Cause: The logical standby database guard was turned off.
Action: Issue the ALTER DATABASE GUARD ALL command to turn the guard on and verify that Data Guard health check error or warning is cleared.
ORA-16794: database guard is on for primary database
Cause: The database guard was turned on for the primary database.
Action: Issue the ALTER DATABASE GUARD NONE command to turn off the guard and verify that Data Guard health check error or warning is cleared.
ORA-16795: the standby database needs to be re-created
Cause: A switchover or failover operation caused this database to require re-creation. The database was marked for re-creation because it was not a viable standby database for the new primary database. Until this error status is resolved for this database, information about this database and the broker configuration to which it belongs is unavailable to a broker client that is connected to this database. Therefore, all commands directed by that client to this database cannot be completed.
Action: Re-create (or flash back) the standby database. Connect to the primary database in the broker configuration and reenable broker management of that database. Once enabled, it is possible to connect to that standby database and manage it with the broker. Alternatively, many client commands that cannot be completed at the standby database when in this error state can be completed successfully when issued to the primary database. In this case, simply reconnect to the primary database and retry the command.
ORA-16796: one or more properties could not be imported from the database
Cause: The broker was unable to import property values for the database being added to the broker configuration. This error indicates:
- The Oracle Net service name specified in DGMGRL CREATE CONFIGURATION or ADD DATABASE command was not one that provides access to the database being added.
- There were no instances running for the database being added.
Action: Remove the database from the configuration using the REMOVE CONFIGURATION or REMOVE DATABASE command. Make sure that the database to be added has at least one instance running and that the Oracle Net service name provides access to the running instance. Also check the broker log file for additional information. Then, reissue the CREATE CONFIGURATION or ADD DATABASE command.
ORA-16797: database is not using a server parameter file
Cause: The database was not using a server parameter file or the broker was unable to access the server parameter file.
Action: Issue the CREATE SPFILE='..' FROM PFILE='...'" command to create a server parameter file and then restart the database to use it.
ORA-16798: unable to complete terminal recovery on the standby database
Cause: Terminal recovery on the standby database failed during the failover operation.
Action: Check the Data Guard broker log and the Oracle alert logs to see more details on the reason for the failure.
ORA-16799: Redo Apply is not running
Cause: Either the Data Guard broker metadata indicates that Redo Apply was turned off, or the recovery process, MRP0, was not running. As a result, Redo Apply-related properties could not be set.
Action: Turn on Redo Apply through Data Guard broker and reissue the command to set a Redo Apply-related property.
ORA-16800: redo transport service for a standby database incorrectly set to ALTERNATE
Cause: The redo transport service for a standby database was set to ALTERNATE when no other destination is set to alternate to this destination.
Action: Reenable the standby database or the entire configuration to allow the configuration property settings to be propagated to the initialization parameters.
ORA-16801: redo transport-related property is inconsistent with database setting
Cause: The values of one or more redo transport-related configuration properties were inconsistent with database in-memory settings or server parameter file settings. This may happen by directly altering initialization parameters instead of editing configurable property values using Data Guard broker.
Action: Query the InconsistentLogXptProps property on the primary database or check the Data Guard broker log to find which properties are set inconsistently. Reset these properties to make them consistent with the database settings. Alternatively, enable the database or the entire configuration to allow the configurable property settings to be propagated to the initialization parameters.
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: unable to query a database table or fixed view
Cause: Failed to query a database table or fixed view. The database may not be opened or mounted.
Action: Check the Data Guard broker log for more details.
ORA-16804: one or more configuration properties in metadata have invalid values
Cause: Data Guard broker health check detected that one or more configuration properties in the broker configuration had invalid values. The property values were changed while broker management of the database was disabled.
Action: Check Data Guard broker log for more details on which properties have invalid values and reset them through the Data Guard broker.
ORA-16805: change of LogXptMode property violates overall protection mode
Cause: The broker disallowed the attempt to change the LogXptMode configurable property for the standby database because, if allowed, the overall protection mode for the configuration would have been violated.
Action: If the LogXptMode configuration property must be changed for the specified standby database, first downgrade the overall protection mode for the broker configuration. After that operation has completed, the LogXptMode configuration property for the standby database can be changed.
ORA-16806: supplemental logging is not turned on
Cause: Supplemental logging was not turned on while there was a logical standby database in the configuration. This could happen either on the primary database or on the logical standby database that was being switched over to be the primary database.
Action: Check the Data Guard broker log for more details. Issue the ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS to add supplemental logging.
ORA-16807: unable to change database protection mode
Cause: An attempt to issue the ALTER DATABASE SET STANDBY TO MAXIMIZE {PROTECTION | AVAILABILITY | PERFORMANCE} failed.
Action: Check the Data Guard broker log and the Oracle log for more information.
No hay comentarios:
Publicar un comentario