ORA-16674: standby database type has changed
If a database created as Physical Standby is converted to a Logical Standby database while the Broker configuration is enabled,…
0 Comments
July 8, 2020
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…
July 1, 2020
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…
June 1, 2020
PERFORMANCE TUNING TIPS AND TECHNIQUES
Below are some of the basic hygiene techniques and concepts we should keep in mind to get the maximum performance…
May 25, 2020
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…
May 14, 2020
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.…
April 15, 2020
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…
April 6, 2020
INDEX SCANS IN ORACLE
The index scans are the table access paths used by the oracle optimizer to generate the best execution plan. There…
March 26, 2020
Oracle PDB Automatic Startup in 12C
We will explain Oracle PDB Automatic Startup in 12c in this article. STEP 1 :- Check The List Of PDBS…
March 23, 2020
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…
March 23, 2020
- 1
- 2
- 3
- 4
- …
- 44
- Go to the next page