Database Solutions

Backup & Recovery of Pluggable and Container database in 12c & 19C With Oracle 12C onwards ,Oracle have come up with concept of multitenant database and with that there are multiple question with respect to taking backup & recovery of Container and Pluggable database .  Below the major three backup & recpvery scenario : 1) Backup & Recovery of container and pluggable database. 2) Backup  & Recovery of container(root) database. 3) Backup & Recovery of the Pluggable database 4) Backup & Recovery individual tablespace and datafiles in Pluggable database 1) Backup & Recovery of container and pluggable database. Backup:  $ rman target=/ RMAN> BACKUP DATABASE PLUS ARCHIVELOG; sample output ============= input datafile file number=00001 name=/u01/app/oracle/oradata/cdb1/system01.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/cdb1/undotbs01.dbf input datafile file number=00006 name=/u01/app/oracle/oradata/cdb1/users01.dbf...

How to Unplug and Plug PDB(Pluggable DB) multiple Options- Copy , Nocopy & Move Oracle offers to unplug a PDB from one CDB and then plug into a different CDB. This will be another additional feature of PDB to give the highest availability and scalability the database systems may need in a cloud infrastructure environment.  In this blog, We will unplug a PDB(Pluggable DB) from one container database and Plug them into another container database using all three option. We have two Container database CDB1 and CDB2. CDB1 is having one PDB(Pluggable database) PDB1. 1) Unplug Pluggable database PDB1  from CBD1 Container database. . oraenv [enter cdb1 at the prompt] sqlplus / as sysdba alter pluggable database pdb1 close immediate; Unplug the closed PDB and then specify the path and name of the XML file: alter pluggable database pdb1 unplug into '/u01/app/oracle/oradata/pdb1.xml'; Drop the closed PDB and keep the data files: drop pluggable database pdb1 keep datafiles; Verify the...

Clone Pluggable database within same Container Database Cloning and Refresh are day-to-day activity which DBA perform on regular basic. In today blog , We will discuss about Cloning of the pluggable database with in the same Container database. 1) Run Below command to check and verify existing pluggable database: SQL> set echo on SQL> SET LINESIZE 200 SQL> SET PAGESIZE 10000 SQL> SET SERVEROUTPUT ON SQL> COLUMN "DB DETAILS" FORMAT A100 SQL> SELECT 'DB_NAME: '||sys_context('userenv','db_name')||'/ CDB?:'||(select cdb from v$database)||'/ AUTH_ID:' ||sys_context('userenv','authenticated_identity')||'/ USER: '||sys_context('userenv','current_user') ||'/ CONTAINER:'||nvl(sys_Context('userenv','con_Name'),'NON-CDB') "DB DETAILS" FROM DUAL; DB DETAILS -------------------------------------------------------------------------------------------...

How to clone Pluggable Database from one container to different Container Database Cloning and Refresh are day-to-day activity which DBA perform on regular basic. In today blog , We will discuss about Cloning of the pluggable database from one container database to different container database. Oracle offers to unplug a PDB from one CDB and then plug into a different CDB. This will be another additional feature of PDB to give the highest availability and scalability the database systems may need in a cloud infrastructure environment.  1)We have two container database cseeddb(Source Container DB) and ctestdb1 (target container DB). NOTE: We have created container DB ctestdb1 and it does not have any PDB(Pluggable DB). 2)Verify you are in the correct container database root namespace(CDB). NOTE: We are on first container (cseeddb) database where we have clonedb pluggable database which we will move in to another empty container ctestdb1. SQL> set echo on SQL> SET LINESIZE 20...