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 »Onur ARDAHANLI
SQL Apply Filtering on Logical Standby Database
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 »Delete Archive logs Automatically on Standby
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 »How To Convert Physical Standby Database to Logical Standby Database
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 »Logical Standby Database in Oracle
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 »ORA-48141: error creating directory during ADR initialization
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 »ORA-16664: unable to receive the result from a database
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-674024af6c44f776457603/] …
Read More »RFS[18]: Assigned to RFS process
The following errors were seen in the ALERTLOG file of the STANDBY Database if the PRODUCTION Database suddenly shuts down. (STANDBYDB) Mon Dec 21 17:53:29 …
Read More »ORA-16198: LGWR received timedout error from KSR
Redo Transport to the standby has stopped after the ORA-16198 error. ERROR ORA-16198: LGWR received timedout error from KSR LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect …
Read More »Oracle Snapshot Standby Database
You can find the below informations about Snapshot Standby Database in this article. What is Oracle Snapshot Standby Database? Convert Physical Standby to Snapshot Standby …
Read More »