Contact US

Comments

Post a Comment

Please do not enter any spam link in comment Section suggestions are Always Appreciated. Thanks.. !

Popular posts from this blog

Oracle Block Corruption - Detection and Resolution

Oracle Block Corruption - Detection and Resolution Any kind of corruption in database can  lead to stand still operation of the organization and can cause sever impact to organisation. In this blog , We are going to discuss about Block Corruption of the oracle database. Block Corruption :  Oracle Block Corruption occurs due inconsistent block Header ,Footer ,Checksum or Structure. Depending on the kind of insistency ,We can divide corruption into Physical and Logical corruption. Physical Corruption is due to Bad header, header or footer mismatch ,Invalid Block checksum & misplaced block. Usually this kind of the block corruption are due to external reason and difficult to resolve by oracle utilities alone.  Logical Corruption is due to corrupt or invalid Block structure when block checksum is valid. This kind of the Corruption can be resolved by the Oracle Utilities. Detection of Block Corruption Whenever a corrupt block is read Oracle reports an error in the alert l...
Read more

Manual Creation and Drop of Pluggable Database - Oracle 12c & 19c

Image
Manual Creation and Drop of Pluggable Database - Oracle 12c & 19c With latest Oracle database version 12c onwards, Database creation and drop time have has been reduced significantly. In this blog, We will show how pluggable database can be created with in few mins.  Manual Pluggable database creation: Check the existing and Seed pluggable database using below query: sql> SET SERVEROUTPUT ON sql>C OLUMN "RESTRICTED" FORMAT A10 sql> select v.name, v.open_mode, nvl(v.restricted, 'n/a') "RESTRICTED", d.status   from v$PDBs v inner join dba_pdbs d using (GUID) order by v.create_scn; sql> NAME                            OPEN_MODE   RESTRICTED STATUS ------------------------------ ---------- ---------- ------------- PDB$SEED                  ...
Read more

How to clone Pluggable Database from one container to different Container Database

Image
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...
Read more