RMAN-08137 on Primary Database although Archive Destination

This article is about RMAN-08137. We are going to learn how do we can solve this issue. Let’s have look at the steps to solve this issue. RMAN does not delete ArchiveLogs on Primary Database when the State of the Archive Destination to the Standby Database is set to ‘defer’. When trying to delete ArchiveLogs, this Error is […]

Read More

Plug Single Instance PDB to RAC CDB

In this article we will Plug Single Instance PDB to RAC CDB. Single Instance CDB Name Single Instance PDB Name RAC Instance CDB RAC Instance Name RAC Node  globdb pdb1 CDB1 RAC1 Node1 RAC2 Node2 Step 1 : Check status of Globdb and CDB1

Step 2 : Check details of globdb :

Step […]

Read More

ACFS file system Mount and Dismount Operation

Before we shut down ASM instance it is important to dismount acfs file system , Once it is dismounted all open references to Oracle ASM files are removed . If ACFS file system is active and ASM instance is forcibly shut down , acfs file system will be placed in offline error state.If any file […]

Read More

Creating ADVM volume and ACFS File System

To see overview of ACFS file System , Oracle ASM Cluster File System Step 1 : Basic thing to use ACFS file system is compatible.rdbms, compatible.advm parameter should be set to 11.2 or higher.

I got error while updating compatible.advm parameter , to set compatible.advm to 11.2 we need to first start acfsload with […]

Read More

Oracle ASM Dynamic Volume Manager and ASM Cluster File System

ASM is a preferred storage for all database files – Datafiles, Controlfiles , Redo log files, Archive Logs, RMAN backups ,Flashback Logs etc. And Oracle ACFS is the preferred file manager for non-database files. It is optimized for general purpose files.Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a multi-platform, scalable file system, and […]

Read More

Log Shipping in Oracle

In this article we will learn DR creation with log shipping : Prerequisites : Source Database should be in Archive log mode . Enable Archive Log Mode In Oracle RAC Details : Database Name Source DB IP DR DB IP mgr 192.168.1.10 192.168.1.181 Step 1 : To create log shipping DR server force logging and […]

Read More

Archivelog in Oracle Database

Today we are going to learn about the most important element of Oracle Database which come’s much important after it’s backbone.Being Oracle DBA we must aware of Archive logs.Now we are going to have look at the technical definition of archive log. An archived redo log file is a copy of one of the filled members of a […]

Read More

Oracle Dataguard

Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Dataguard maintains these standby as exact copy of primary database. So if […]

Read More

Spfile and Pfile in Oracle

Today we are going to have look on the topic of “PFile and SPFile”. This is the most important element of the Oracle database. Being Oracle DBA we must aware about “PFile and SPFile”. This file plays an important role in  Oracle database. Let’s have look at the technical definition of “PFile and SPFile”. It will be […]

Read More

Services in Oracle RAC

Based on the number of instances participating in your Oracle RAC Cluster and complexity and objectives of your application’s environment we need to choose optimal workload management. And there variety of considerations based on that. We can use following features of Oracle RAC to manage workload : Oracle Services Database Resource Manager Oracle Rac High […]

Read More