If a database created as Physical Standby is converted to a Logical Standby database while the Broker configuration is enabled, you may receive an error …
Read More »
If a database created as Physical Standby is converted to a Logical Standby database while the Broker configuration is enabled, you may receive an error …
Read More »Sometimes, we may not want to reflect the operations performed on the Primary database to the Logical Standby database. It can be ensured that DML …
Read More »To delete archive logs automatically on standby you should set LOG_AUTO_DEL_RETENTION_TARGET parameter. The Foreign Archive Logs in Logical Standby Database is automatically deleted by SQL …
Read More »Below are some of the basic hygiene techniques and concepts we should keep in mind to get the maximum performance out of our query . …
Read More »Logical Standby Database does not support replication of all data types, tables, commands and PL / SQL Packages. Therefore, before converting a Physical Standby database …
Read More »What is a logical standby database? Apart from Physical and Snapshot Standby Database, it is another type of Standby Database. It is an active database …
Read More »After the STANDBY Database is installed and the necessary configurations were made, when INSTANCEs wanted to be START, one of the INSTANCEs opened and the …
Read More »The index scans are the table access paths used by the oracle optimizer to generate the best execution plan. There are different types of scans …
Read More »We will explain Oracle PDB Automatic Startup in 12c in this article. STEP 1 :- Check The List Of PDBS . Here In My case …
Read More »When querying the status of the configuration from broker, errors like below were seen. Warning: ORA-16664: unable to receive the result from a database [crayon-686e722646c8c282461936/] …
Read More »