Joords Oracle DBA blog

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 .

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 fi...

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.

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 Create Diskgroups Load ACFS Drivers Create Filesystem for ACFS Volume Device Mount ACFS Filesystem ASMCA validation of ACFS Filesystem Automatic startup ACFS Mount Device Oracle ACFS Mount Registry

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.