Joords Oracle DBA blog

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

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

Use Resource Management best practices to guarantee and limit resources for each database and PDB.

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.

A quick reminder for me how to use Oracle SQL Q-quote.

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