gDBClone script Database Clone/Snapshot Management Script

gDBClone script Database Clone/Snapshot Management Script. A Simple Approach to Managing Test and Development Environments Leveraging ACFS Snapshots on your environment

The diagram below illustrates a typical test and dev environment that can be created and managed with the gDBClone command.

Oracle Cloud File System - Grid Infrastructure ASM features “ACFS”

Licensing policy for ASM Cluster File System (ACFS), now called Oracle Cloud File Systerm, is free to use in combination with any Oracle RDBMS version. De files must have a relation with the RDBMS, including non-Oracle files related to the RDBMS application. See the citation below

Citation from the Oracle documentation:

A restricted use license to use Oracle Cloud File System is included with all editions of the database specifically for storing Oracle Database-related configuration files, including Oracle Database software binaries and homes, Oracle Database software administrative files, and Oracle Database software diagnostic files. Customers wishing to store their own data files, or non-Oracle Database software files including data files, binaries, administrative files, and diagnostic files, in Oracle Cloud File System must separately license Oracle Cloud File System.

This means "Extra charging for “user data” files like RMAN backups, exports and other database related files just makes life more difficult for clients that have committed to running their business on Oracle Clusters."

Oracle Cloud File System Licensing Requirements. This MOS 1322405.1 try to be an attempt to clarify the situation on Oracle CloudFS (0ACFS) Oracle Licence.

HP DataProtector supports Oracle ACFS

Great Oracle ACFS is now supported by HP Dataprotector. See the Platform and integration support matrix link in this blog

Question

Is it possible to backup Oracle ACFS with HP DATAPROTECTOR. Currently we can't see the mount point that we have created on the system with the HP DATAPROTECTOR GUI. We used  Data Protector 6.11  [dd - Jan 12,2011]

Answer from HP Support

It is Supported with Data Protector 6.11 patches: PHSS_41457 / PHSS_41458 / DPLNX_00136 / DPSOL_00430.

HP Information

HP dataProtector 6.11 - Platform and integration support matrix  date: 11Februari 2011.

Oracle Automatic storage management Cluster File System - ACFS

Important is that the storage devices operational, mounted and stamped as ASM device to the machine. Using Management Volume (ACFS) the compatibility level must be at least 11.2. on diskgroup level. See below the created statements from the diskgroups inside the ASM. De disksgroups are created with the compatible.* -> 11.2. The diskgroup that will be used for ACFS is the diskgroup “DG_DISK11G_01”

Steps involved to use ACFS

1. Create Diskgroups
2. Load ACFS Drivers
3. Create Filesystem for ACFS Volume Device
4. Mount ACFS Filesystem
5. ASMCA validation of ACFS Filesystem
6. Automatic startup ACFS Mount Device
7. Oracle ACFS Mount Registry

Using ASM’s Cluster File System (ACFS) & Dynamic Volume Manager (ADVM) on a Single Node

Oracle 11gR2 ASM supports a new type of file called a “volume file” which may be created in its own DISK GROUP or which may share space in another disk group. Volume files are externalised to the Unix operating system by the oracleadvm device driver and appear dynamically as special files in the /dev/asm directory.