Practice 5 Creating a PDB by Cloning from Local and Remote PDBs

Ahmed Baraka
A free video tutorial from Ahmed Baraka
Snr. Database Administrator
4.5 instructor rating • 8 courses • 5,082 students

Lecture description

In this practice you will perform the following:

  • Create a PDB by cloning a local PDB
  • Create a PDB by cloning a remote PDB

Learn more from the full course

Oracle 12c Multitenant Architecture Administration

Learn how to build and manage an Oracle 12c Multitenant Architecture database.

10:18:37 of on-demand video • Updated April 2021

  • Describe the Oracle 12c multitenant architecture
  • Create multitenant container database
  • Create a pluggable database using different methods
  • Create and manage common and local user accounts
  • Manage PDB lockdown profiles
  • Perform backup and recovery
  • Perform PITR and flashback
  • Use the Resource Manager in a container database
  • Use Data Pump utility with PDBs
  • Manage the applications and application containers
English [Auto] Hi guys in this practice you will create two prediabetes you will create the first one by cloning a local PDP and you will create the second one by cloning a remote PDB as it was before starting the practice. Consider taking a snapshot of the virtual appliance in the fifth section of this practice. You will create a PDB by cloning a local PDP cloning a local PDP requires the archive log mode to be enabled and if you remember when we created this CD database we did in selecting the archiving option in the DBC a utility. Therefore we should enable the archive Look mode in the CD be the procedure to enable the archive lock mode in the CD is typically the same as the procedure that you follow when you enable it in an LCD that is first you're looking as just D-B to the CD. Then you get to the destination of the archive read to look files shut down the database mounted set the archive look more on and finally open that database. You will perform this procedure in this subsection or the practice log into the CD SSTV in sequela plus Sishen verify that the CD is not running. In the archive Look mode the database is running and no archive. Look most make sure the archived destination parameters are not pointing to any location. Set the archive destination to the fast recovery area. Follow this up steps. Step Number 6 to enable the archive look at the archived redo file has been created. Having the local undo property enabled is highly recommended because it allows cloning that PDP online find that the CVB has the local undo property enabled. You are ready now to create a new PDP by cloning a local PDP in the following steps you will create a PDB named as PDP 3 by your cloning PDB to verify that the if is unable. This is not mandatory. You just check out if the if is unable or not just because it is enabled you don't need to specify the destination or the New PDP data files. If it is disabled you should set the data to see where the PDB data files will be created. Though if it is set in our CD be instance give you to the PDP using the command you to pluggable databases from. It is as simple as that. This simple single statement will create a new pluggable container as you see the new PDB was created in less than 25 seconds without multi-tenancy option. That was nearly impossible in Oracle database after creating the PDB. You must open it in read write it even if you create the PDB. For read only operation. Open it first and read the right amount then switch it to read only mode. Let's have a look at the list of the data files created for the New PDP as you see and you subdirectory was created under the CDB directory which hosts all the data files of the New PDP the subdirectory name is the same name as that you ID of the PDB in this section of the practice. You will create a new PDB by cloning a remote PDB to do that. You must create a database link pointing to the source -- container it could also point to the source PDB itself. In case you do have another CD be so simply you will create a database link that is pointed to the local CVB instance create a database link to CVB one database just the database link create a new PDB by cloning PDB before using the command create pluggable database from where the database link that you created in the previous ISTEP you cloned a PDB online from another container that exists in a different instance. This is in my opinion a really very awesome feature in Oracle that will see our two multitenant database again. You have to open the new PTB in read the rightmost just connecting to the new PDB using the easy connect method. The connection to the PDB was successful as you saw in this practice creating a PDB from cloning a local or remote PDB is quite easy. With Oracle it will see our two multitenant. This could be very handy to make a clone of a production database without having to shut down the source database. Still an oracle will see up to there not a lot of other methods for copying and moving the piece. You will learn about them and then coming back. This is. Thanks for watching. See you in the next practice.