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 […]
Monthly Archives: April 2018
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 [oracle@rac2 ~]$ srvctl status database -d globdb Instance globdb is running […]
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 […]
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. [oracle@rac1 ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 21 23:22:52 2018 Copyright (c) 1982, 2013, Oracle. […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]