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 .

Database cloning with Copy On Write (COW) on ZFS Storage Appliance ( ZFSSA ). The method that I will demonstrate is the method of using the API ZFSSAADM for database cloning for data on ZFSSA. ZFSSAADM is an API which is part of the 12c Oracle software. What we have is the following setup An Oracle database 12c server  With NFS mount point to the ZFS Storage Appliance Operational  Direct NFS for databases Oracle ZFS Storage Appliance Simulator [Server IP 192.168.56.102] Validate my environment and settings Validate if it is a CDB database

As a virtual machine environment user, I regularly create ‘base’ images of machines that I can reuse . So when I need a new machine, I simply create a copy of the virtual disk and add any additional software I need, this save me a lot of time instead creating new virtual environments. In VirtualBox, copying a virtual disk is a bit of a pain. If you copy the disk in Windows Explorer and try and use it in a new VM, VirtualBox will have a display an error shown below.