Whether the ARCHIVE Logs are transferred to Standby can be seen from the ALERT LOGs as follows. [crayon-662b5c683db97233289654/] After the archives are created, sometimes writing …
Read More »ORACLE
What is Oracle SQL Plus and SQL Plus Usage
This article contains information about Oracle SQL Plus tool. What is Oracle SQL Plus? SQL Plus is a tool for managing the database management system …
Read More »How To Track Failed Logon Attempts using Oracle Unified Auditing
If you enable the unified audit feature announced with 12c, all audit records will be in the UNIFIED_AUDIT_TRAIL table. Logon failure records will not be …
Read More »How To Check and Change Redo Log Switch Frequency
If you want to learn What the Redo Log is, you should read the article named “Oracle Redo Log And Archive Log”. I will tell …
Read More »SYSAUX Tablespace Usage
What is the SYSAUX Tablespace and What is it used for? In Oracle databases, SYSAUX tablespace is an auxiliary storage space for SYSTEM tablespace. Most …
Read More »What is Oracle Data Guard redo apply
What is Redo Apply? Redo Apply performs the task of creating a block-by-block copy of the Primary database. The operations are as follows; The RFS …
Read More »Blank screen issue When You Run Runinstaller for Oracle 19c Installation
When runinstaller for Oracle 19c database installation is run in Linux environments, a blank screen appears due to problems with fonts. The same problem occurs …
Read More »How To Install Oracle Database in Docker
This article provides information about how to install oracle database in docker and oracle usage in docker. For detailed information about Docker before installation, please …
Read More »Principle of Least Privilege in Oracle Databases
The principle of least privilege (POLP) is an important concept in computer security, is to restrict users’ privileges to the minimum level they need to …
Read More »Automatic GAP Resolution
I will explan Automatic GAP Resolution in Oracle Data Guard in this article. You may want to read below articles two understand Oracle Data Guard …
Read More »