Recover table in oracle 12c

Oracle 12.2 came with a new feature , we can simply recover a single table in a database. In below example we will see how we can restore a table of pluggable database. Step 1 : Connect to RMAN Step 2 : Use following command to recover table I.E. here I have table TEST which […]

Read More

Oracle 12c and its new things

I wrote many posts about all new features of Oracle 12c , how multi-tenant architecture works and all. In this post, we will see how oracle’s internal mechanisms have changed with multi-tenant architecture for its existing technologies. Let us start with Oracle Xstream : In Oracle Xtream, capturing changes from the database must always be […]

Read More

Installing Oracle Golden Gate

In previous articles, we have seen basic things we should know before getting started with Oracle Golden Gate All Goldengate In this article, we will see the system requirement for Oracle golden gate and will install oracle golden gate. Supported Operating System for Oracle GoldenGate 12c Linux x86-64: In Linux, Linux 5 and 6 are […]

Read More

Column Mapping and Transformation in Oracle Golden Gate

In general, any replication tool replicates data in similar objects. We need an identical copy of the source and target if we want to do replication. Column Mapping  Oracle Golden Gate is a strong tool which provides the capability to map columns between two dissimilarly structured database table. This feature can be implemented in Golden Gate […]

Read More

PDB Creation with Various methods

In the next 2-3 posts we are going to see all the methods used to create Pluggable Database There are following methods available to create Pluggable Database : Clone a regular PDB Create remote pdb using dblink Create a regular pdb to an application PDB Unplug and Plug a non-CDB Unplug and plug a regular […]

Read More

Create Pluggable Database using dblink

We can create a pluggable database using dblink from a remote location. Step 1: Check container database SQL> select name,open_mode,cdb from v$database; NAME OPEN_MODE CDB ——— ——————– — UPDB READ WRITE YES SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- ———- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 […]

Read More

Managing Tablespace in Multi-Tenant Environment Part – II

In the previous article, we have seen System tablespace and Users tablespace. Managing Tablespace in Multi-Tenant Environment Part – I In this article we will see Temporary tablespace and Undo tablespace : Temporary Tablespace : Every CDB$ROOT can have one default temporary tablespace or tablespace group. Pluggable databases must have their own temporary tablespace to […]

Read More

Configure and use the local UNDO mode

In Oracle 12c Release 1 Undo tablespace was always Shared across PDBs. Rollback segment of each pdb was written in Undo tablespace which was created under the Container Root database. Oracle 12.2 comes with a new Feature that allows Local Undo creation and Shared undo creation. Local Undo tablespace to PDB helps us in the […]

Read More

Export from pdb and import into non-cdb

In a previous post, we have seen how we import backup from non-cdb to pdb. Export from pdb and import into pdb In this post, we will see how we can import backup taken from the pluggable database and restore it to the non-cdb database. Step 1 : Connect to pluggable database : SQL> alter […]

Read More

Export from pdb and import into pdb

In this post, we will see how we can take an export from one pdb and import into another pdb. Step 1: Connect to pdb from where you want to take export : SQL> alter session set container = orclpdb; Session altered. SQL> SQL> SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- […]

Read More