Thursday, January 21, 2016

Multitenant Snapshot Copy using ZFSSA [Thin Database Cloning]

Starting with Oracle 12.1.0.1 it was also possible using snapshot clones with pluggable databases within the multitenant database architecture. It was limited to file systems that support sparseness and ACFS. With the first patch set 12.1.0.2 it’s possible to use direct NFS as well for snapshot copies.

Multitenant thin cloning can be managed on Oracle storage like ASM:ACFS and ZFSSA. Special thought here is not to use the clonedbparameter. This will force to use the thin cloning on database level instead the snap and clone technics inside the ZFSSA. For ZFSSA the snapshot copy command needs a key store keystore with the password of the ZFSSA server to communicate. The communication from the Database site is done with the executable ZFSSAADM which will be delivered with the Oracle software tree of the RDBMS. See my blog Using on ZFSSA:ZFSSAADM - Copy On Write (COW) on ZFS Storage Appliance (ZFSSA)

In this blog I will demonstrate and describes the steps to enable thin provisioning and instantaneous cloning features of Oracle Database 12c when it is deployed on Oracle ZFS Storage Appliance.

Thin Cloning of PDBs is a Snap with Oracle Storage

Preparations
  • Patch 18769809: MNTOPTS IN ORADISM NEEDS TO BE CORRECTED
  • Create an environment with ZFS Storage Appliance simulaton. 
  • Oracle Database environment 12c and Direct NFS. 
  • An operational multitenant CDB01 database.  
    • Important "Don’t use the init parameter CloneDB 

Tuesday, January 19, 2016

Forwarding SSH X-11 and magic cookies

On environments where Oracle or Grid accounts are access by sudo.
Then SSH X-11 forwarding and magic cookies are lost.

Here a simple trick that can be used tho solve this.

First login with your account and then execute:
xauth list

Friday, September 18, 2015

Multitenant : PDB Cloning [remote and Non-CDB] 12c (12.1.0.2)

Multitenant : PDB Clone a Remote PDB or Non-CDB in Oracle Database

From Oracle 12.1.0.1 was it possible to de cloning of PDB's in a local Container database. Since version 12.1.0.2 Oracle has extended this functionality to remote PDB cloning. Cloning between two separted on-premises Oracle databases 12c non-CDBs as PDBs to an on-premises Oracle Database 12c container database. This method works also on Oracle Database 12c DBaaS database - Oracle Database Cloud Service (DBCS). An 12c RDBMS migration from On-Premise to Premise and back.

Monday, June 29, 2015

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.



Monday, June 15, 2015

Using on ZFSSA:ZFSSAADM - Copy On Write (COW) on ZFS Storage Appliance (ZFSSA)

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