{"id":16172,"date":"2020-05-26T12:36:17","date_gmt":"2020-05-26T12:36:17","guid":{"rendered":"https:\/\/ittutorial.org\/?p=16172"},"modified":"2020-05-26T14:24:29","modified_gmt":"2020-05-26T14:24:29","slug":"pluggable_database_hot_clone_refresh_manual","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/pluggable_database_hot_clone_refresh_manual\/","title":{"rendered":"PLUGGABLE DATABASE HOT CLONE REFRESH MANUAL"},"content":{"rendered":"

Author \u00a0\u00a0\u00a0 : Cihan Gedik<\/p>\n

Email \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : cihangedik@gmail.com<\/a><\/p>\n

Linkedin\u00a0 : https:\/\/www.linkedin.com\/in\/cihan-gedik-13b55065\/<\/a><\/p>\n

Group \u00a0\u00a0\u00a0\u00a0 : https:\/\/www.linkedin.com\/groups\/13792740\/<\/a><\/p>\n

 <\/p>\n

PLUGGABLE DATABASE HOT CLONE REFRESH MANUAL<\/h3>\n\n\n\n
\n
Compatible Versions<\/strong><\/span><\/em><\/h5>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Oracle Database 12.1.x and Later<\/p>\n

 <\/p>\n\n\n\n
\n
Requirements<\/i><\/span><\/strong><\/h5>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

One Source PDB in CDB<\/p>\n

One Empty CDB for Target<\/p>\n

 <\/p>\n

In this post ;<\/p>\n

Database Version : 19C<\/p>\n

PDB01 is my source pluggable database in CDB01<\/p>\n

PDB01_HOT_MAN is my target clone pluggable database in CDB02<\/p>\n\n\n\n
\n
Solution<\/i><\/span><\/strong><\/h5>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

For this LAB Please create below requirements<\/p>\n

Create PDB01 in CDB01 and insert some data<\/p>\n

Create Empty CDB02 Database<\/p>\n

#### Create CDB01<\/span><\/strong><\/p>\n

$ORACLE_HOME\/bin\/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname CDB01 -sid CDB02 -createAsContainerDatabase true -numberofPDBs 0 -useLocalUndoForPDBS true -responseFile NO_VALUE -totalMemory 1800 -sysPassword welcome1 -systemPassword welcome1 -pdbAdminPassword welcome1 -enableArchive true -recoveryAreaDestination \/u01\/app\/oracle\/databases\/recovery_area\/CDB01 -recoveryAreaSize 1500 -datafileDestination \/u01\/app\/oracle\/databases\/datafiles\/CDB01<\/pre>\n
#### Create PDB01 and Insert Some Data<\/span><\/strong><\/p>\n
create pluggable database PDB01 admin user adminpdb01 identified by welcome1 roles=(CONNECT) CREATE_FILE_DEST='\/u01\/app\/oracle\/databases\/datafiles\/PDB01';\r\n\r\nalter pluggable database PDB01 open;<\/pre>\n
#### Generate Data via Toad<\/span><\/strong><\/p>\n
Create some tables as you wish and use toad to insert data<\/p>\n
Toad > Administrator > Import Data > Generate Data<\/p>\n
sqlplus as sysdba\r\n\r\nconnect sys@PDB01 as sysdba\r\n\r\nEnter password:<\/pre>\n
### Grant Create PDB Privilege to the user which you will use.. I used system in lab<\/span><\/strong><\/p>\n
grant create pluggable database to system;\r\n\r\nGrant succeeded.\r\n\r\nNote : Until this point you should have PDB01 in CDB01 Database with some data populated into tables<\/span>\r\n\r\nsqlplus system\/welcome1 as sysdba\r\n\r\nalter session set container=PDB01;\r\n\r\nselect count(*) from scott.DEPT;\r\n\r\n\r\nCOUNT(*)\r\n\r\n----------\r\n\r\n12000\r\n\r\n\r\n\r\nselect count(*) from scott.emp;\r\n\r\nCOUNT(*)\r\n\r\n----------\r\n\r\n12000<\/pre>\n
#### Create CDB02 with no PDB<\/strong><\/span><\/p>\n
$ORACLE_HOME\/bin\/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname CDB02 -sid CDB02 -createAsContainerDatabase true -numberofPDBs 0 -useLocalUndoForPDBS true -responseFile NO_VALUE -totalMemory 1800 -sysPassword welcome1 -systemPassword welcome1 -pdbAdminPassword welcome1 -enableArchive true -recoveryAreaDestination \/u01\/app\/oracle\/databases\/recovery_area\/CDB02 -recoveryAreaSize 1500 -datafileDestination \/u01\/app\/oracle\/databases\/datafiles\/CDB02<\/p>\n
 <\/p>\n
sqlplus system\/welcome1 as sysdba\r\n\r\nselect instance_name from v$instance;\r\n\r\n\r\nINSTANCE_NAME\r\n\r\n----------------\r\n\r\nCDB02<\/pre>\n
 <\/p>\n
Create DB Link<\/span><\/strong><\/h3>\n
Syntax :<\/span> create pluggable database <NEW PDB NAME> from <SOURCEPDBNAMETOCLONE>@<DBLINKONTARGETTOSOURCE> refresh mode manual;\r\n\r\nalter session set db_create_file_dest='\/u01\/app\/oracle\/databases\/datafiles\/CDB02\/PDB01_HOT_MAN';\r\n\r\ncreate pluggable database PDB01_HOT_MAN from PDB01@PDB_SOURCE_FOR_HOT_CLONE refresh mode manual;\r\n\r\nPluggable database created.\r\n\r\n\r\nSQL>show pdbs\r\n\r\nCON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OPEN MODE\u00a0 RESTRICTED\r\n--------- ------------------------------ ---------- ----------\r\n2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ ONLY\u00a0 NO\r\n3 PDB01_HOT_MAN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MOUNTED\r\n\r\n\r\nalter pluggable database PDB01_HOT_MAN open read only;\r\nalter session set container=PDB01_HOT_MAN;\r\n\r\n\r\nSession altered.\r\n\r\nSQL> show con_name\r\n\r\nCON_NAME\r\n------------------------------\r\nPDB01_HOT_MAN\r\n\r\ncol owner format a7\r\ncol object_name format a15\r\nselect owner,object_name from dba_objects where owner='SCOTT';SQL> SQL>\r\n\r\n\r\nOWNER\u00a0\u00a0 OBJECT_NAME\r\n\r\n------- ---------------\r\n\r\nSCOTT\u00a0\u00a0 DEPT\r\n\r\nSCOTT\u00a0\u00a0 EMP\r\n\r\nSCOTT\u00a0\u00a0 EMP_BACKUP\r\n\r\nSCOTT\u00a0\u00a0 DEPT_BACKUP\r\n\r\n\r\n<\/pre>\n
#### AFTER CLONE COUNT SIZE ###NOTE THAT HOT CLONE PDB STILL READ ONLY<\/span><\/strong><\/p>\n
 <\/p>\n
select count(*) from scott.DEPT;\r\n\r\nCOUNT(*)\r\n\r\n----------\r\n\r\n12000\r\n\r\n\r\nselect count(*) from scott.emp;\r\n\r\nCOUNT(*)\r\n\r\n----------\r\n\r\n12000<\/pre>\n
 <\/p>\n
### Insert New Rows into PDB01 in CDB01 Source<\/span><\/strong><\/p>\n
 <\/p>\n
######WE WILL REFRESH PDB01_HOT_MAN and Check new 2000 Rows Updated ?<\/strong><\/span><\/p>\n
sqlplus system\/welcome1 as sysdba\r\nselect instance_name from v$instance;\r\n\r\n\r\nINSTANCE_NAME\r\n----------------\r\nCDB02\r\n\r\n\r\nSQL> show pdbs\r\n\r\nCON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OPEN MODE\u00a0 RESTRICTED\r\n\r\n------ ------------------------------ ---------- ----------\r\n\r\n2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ ONLY\u00a0 NO\r\n3 PDB01_HOT_MAN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0READ ONLY\u00a0 NO\r\n\r\n\r\nalter pluggable database PDB01_HOT_MAN close;\r\nalter pluggable database PDB01_HOT_MAN refresh;\r\nalter pluggable database PDB01_HOT_MAN open read only;\r\nalter session set container=PDB01_HOT_MAN;\r\n\r\n\r\nselect count(*) from scott.DEPT;\r\n\r\n\r\nCOUNT(*)\r\n----------\r\n14000\r\n\r\n\r\n\r\nselect count(*) from scott.DEPT;\r\n\r\n\r\nCOUNT(*)\r\n----------\r\n14000\r\n\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Author \u00a0\u00a0\u00a0 : Cihan Gedik Email \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : cihangedik@gmail.com Linkedin\u00a0 : https:\/\/www.linkedin.com\/in\/cihan-gedik-13b55065\/ Group \u00a0\u00a0\u00a0\u00a0 : https:\/\/www.linkedin.com\/groups\/13792740\/   PLUGGABLE DATABASE HOT CLONE REFRESH MANUAL Compatible Versions Oracle Database 12.1.x and Later   Requirements One Source PDB in CDB One Empty CDB for Target   In this post ; Database Version : 19C PDB01 is my source …<\/p>\n","protected":false},"author":32,"featured_media":16181,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1994,2110],"tags":[11548,454,2672,480,11543,2671,959,2674,11547,11542,1120,1131,1153,2092,2112,1266,2114,1327,1345,2673,11544,11545,11549,11546],"class_list":["post-16172","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","category-oracle-dba-scripts","tag-create-pluggable","tag-database","tag-database-tutorial","tag-dba-danismanlik","tag-hotclone","tag-it-tutorial","tag-linux","tag-linux-tutorial","tag-manual","tag-multitenant","tag-oracle","tag-oracle-12c","tag-oracle-19c","tag-oracle-19c-error-codes","tag-oracle-dba-scripts","tag-oracle-egitim","tag-oracle-monitoring-scripts","tag-oracle-rman","tag-oracle-support","tag-oracle-tutorial","tag-pdb","tag-pluggable","tag-pluggable-database","tag-refresh"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/2020-05-26_15-44-51.jpg","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=16172"}],"version-history":[{"count":15,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16172\/revisions"}],"predecessor-version":[{"id":16189,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16172\/revisions\/16189"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/16181"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=16172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}