Blog Posts

Create Oracle Control file manually

June 30, 2023

When to create control files ? Create control files in situations when : 1. You have lost all your control files. 2. When you want to rename your database name (db_name); Note :although we can use utility called DBNEWID to change the DBNAME. DBNEWID can be used to change : — Only the DBID of…
Oracle Database files to be excluded in Anti-virus or any third party tools scan

June 18, 2023

Oracle Database Files to Exclude from Antivirus and Third-Party Scans Oracle Database Files to Exclude from Antivirus and Third-Party Scans Properly managing antivirus and third-party scans is critical for maintaining the stability and performance of your Oracle Database. Failing to exclude essential database files from scans can lead to file locks, I/O exceptions, and even…
QUERY TO FIND ARCHIVE GAP BETWEEN PRIMARY AND STANDBY in ORACLE Database

May 14, 2023

Finding Archive gap between PRIMARY and STANDBY A Physical Standby database syncs with Primary by continuous apply of archive logs from a Primary Database. When the logs are missing on standby is less than 10-15 numbers, We can simple ship the logs which are missing in the standby database from primary database by…
Working with Oracle Database Flashback Recovery

May 4, 2022

Configuring Flashback Recovery in Oracle Database Flashback Database is a powerful feature in Oracle that allows you to rewind your database to a previous state without requiring traditional point-in-time recovery. Starting from Oracle 11g R2, enabling Flashback Database no longer requires a database restart. For earlier versions, a database bounce is needed for these…
Audit Failed Logon Attempts in Oracle Database

November 27, 2021

Audit Failed Logon Attempts in Oracle Database. Failed logon attempts can cause account locks, resulting in disruptions for users and increased workload for DBAs. Identifying the source of failed logon attempts is crucial for troubleshooting and preventing further issues. Oracle’s audit functionality provides an efficient way to track and log these attempts. Background…