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 […]
All posts by Jagruti Jasleniya
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 […]
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 […]
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 […]
Transparent Application Fail-over in Oracle RAC
Transparent Application Failover (TAF) is a feature of the Java Database Connectivity (JDBC) Oracle Call Interface (OCI) driver. It enables the application to automatically reconnect to a database, if the database instance to which the connection is made fails. This is true regardless of how the connection was lost. When an Instance shut down unexpectedly […]
Grid Plug and Play [GPNP] Profile in Oracle RAC
Grid Plug and Play [GPNP] Profile : It is small xml file located in $GRID_HOME/gpnp/<hostname>/profiles/peer under the name profile.xml. It is used to establish the correct global personality of a node. Each node maintains a local copy of the GPnP Profile and is maintanied by the GPnP Deamon (GPnPD) . [root@rac1 peer]# cat profile.xml <?xml version=”1.0″ encoding=”UTF-8″?> […]
Oracle RAC Dynamic Remastering
In Oracle RAC , Each and every data block is mastered by an Instance. That Instance is called Resource Master for that data block. Master Instance keeps track of the status of the data block like which instance is holding instance for this block , in which state it is being held etc.This Information is […]
SCAN listener in Oracle RAC
What is SCAN in Oracle RAC? Single Client Access Name (SCAN) is an Oracle Real Application Clusters (Oracle RAC) feature that provides a single name for clients to access Oracle Databases running in a cluster. And we can say that SCAN is a cluster alias for database. The benefit is that SCAN-NAME you provide for […]