Learn Oracle Administration best practices, configurations, and expert tips for smooth database management. Optimize performance and security today!
While turning on Flashback in the Oracle Database, sometimes we may encounter the error : 'ORA-38706: Cannot turn on FLASHBACK DATABASE logging'. Today we will discuss how to resolve this.…
Today in this article, we will discuss about how to create and drop restore point in Oracle Database. Lets go through it in detail. First of all, we need to…
SRL stands for Standby Redo Log. Today in this article we will learn about how to resolve Insufficient SRLs reported by DGMGRL. If you are having different number of SRLs…
Today in this article, we will see how to check Hidden Parameter in Oracle. Let's go through this: Query 1: Issue the below command to find all the hidden parameters…
Today in this article, we will see how to find bind variables for a sql in Oracle database. Let's go through the steps. Bind variables in Oracle are used for…
In this article, we will discuss today how to check free space in ASM Disk Group. Let's go through the steps : Step 1: Check Free Space in ASM Disk…
In this post, we'll cover everything you need to know about how to enable archive log mode in Oracle RAC. Let's open our 2-node Oracle RAC(node1 and node2) VirtualBox and…
In this post, we'll cover everything you need to know about how to disable archive log mode in Oracle RAC. Let's open our 2-node Oracle RAC(node1 and node2) VirtualBox and…
This post will cover everything you need to know about how to find master node in Oracle RAC. Let's open VirtualBox and get started! The node where Cluster Processes gets…
Today in this article, we will learn about how to resolve ORA-19504 : failed to create file. Lets go through this: Error : DEST_ID DEST_NAME STATUS DB_UNIQUE_NAME ERROR---------- ------------------------------ ---------…