![]() ![]() ![]() These properties can be very helpful when you are trying to diagnose problems in the broker configuration. Monitorable properties allow you to view information related to a configuration member, but you cannot change the values of these properties. LogArchiveFormat = 'db1r_%d_%t_%s_%R.arc' StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST' (INSTANCE_NAME=north_sales1)(SERVER=DEDICATED)))' (CONNECT_DATA=(SERVICE_NAME=North_Sales_) StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) LogFileNameConvert = 'dbs/bt, dbs/t, dbs/ct, dbs/t' If the primary database is an Oracle RAC database, the broker configures redo transport services on all primary instances with the exact same settings.Įxample 4-1 Using the SHOW DATABASE VERBOSE Command to Display Properties DGMGRL> SHOW DATABASE VERBOSE 'North_Sales' ĭGConnectIdentifier = 'North_'ĭbFileNameConvert = 'dbs/bt, dbs/t, dbs/ct, dbs/t' Log files continue to be archived at the primary database. Transmission of redo data to all broker-managed standbys is stopped. When transitioning the primary database to the TRANSPORT-OFF state, the broker turns off redo transport services to all broker-managed standbys by resetting the LOG_ARCHIVE_DEST_STATE_ n initialization parameter. Finally, if the database is open, the broker switches a log for each thread to initiate redo transport services. If necessary, the broker also sets up the data protection mode of the database to match the protection mode recorded in the broker configuration file. (See Managing Redo Transport Services for the list of redo transport-related properties and Advanced Redo Transport Settings for a description of the RedoRoutes property.) Redo transport services setup is done by setting the LOG_ARCHIVE_DEST_ n and LOG_ARCHIVE_DEST_STATE_ n initialization parameters on the primary database, and the LOG_ARCHIVE_CONFIG initialization parameter on all databases (primary or standby) and far sync instances. When transitioning the primary database to the TRANSPORT-ON state, the broker sets up redo transport services using the redo transport-related properties of the configuration members and the RedoRoutes property at the primary database. If this is an Oracle RAC database, there is no instance running SQL Apply until you change the state to APPLY-ON. The logical standby database guard is on. This is the default state for a logical standby database when it is enabled for the first time. This new instance becomes the apply instance. If this instance fails, the broker automatically chooses another open instance. If this is an Oracle RAC database, SQL Apply is running on one instance, the apply instance. SQL Apply is started on the logical standby database when it is opened and the logical standby database guard is on. If this is an Oracle RAC database, there is no instance running Apply Services until you change the database state to APPLY-ON. See Oracle Data Guard Concepts and Administration for more details. This capability is known as real-time query. If a license for the Oracle Active Data Guard option has been purchased, a physical standby database can be open while Redo Apply is active. This is the default state for a physical standby database when it is enabled for the first time. This new instance then becomes the apply instance. If this instance fails, the broker automatically chooses another instance that is either mounted or open read-only. If the standby database is an Oracle RAC database, the broker starts Redo Apply on exactly one standby instance, called the apply instance. Redo Apply is started on a physical standby database. If this is an Oracle RAC database, redo transport services are not running on any instances. Redo transport services are stopped on the primary database. This is the default state for a primary database when it is enabled for the first time. If this is an Oracle RAC database, all instances open in read/write mode will have redo transport services running. Redo transport services are set up to transmit redo data to the standby databases or far sync instances when the primary database is open for read/write access. ![]() Table 4-1 Database States and Descriptions Database Role ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |