How to create a PDB in Oracle (pluggable database)

To create a Pluggable Database (PDB) in Oracle, you will need to first create a Container Database (CDB). A CDB is a special type of Oracle database that can host one or more PDBs within it. Here's a simplified example of the steps involved in setting up a PDB:

1. Create a new Container Database (CDB) using the CREATE DATABASE command. For example:

CREATE DATABASE cdb1
 ADMIN USER admin IDENTIFIED BY password
 DEFAULT TABLESPACE users
 DATAFILE '/u01/app/oracle/oradata/cdb1/system01.dbf' SIZE 50M REUSE
 SYSAUX DATAFILE '/u01/app/oracle/oradata/cdb1/sysaux01.dbf' SIZE 50M REUSE
 DEFAULT TEMPORARY TABLESPACE temp UNDO TABLESPACE undotbs1
 LOGFILE GROUP 1 '/u01/app/oracle/oradata/cdb1/redo01.log' SIZE 50M, '/u01/app/oracle/oradata/cdb1/redo02.log' SIZE 50M, '/u01/app/oracle/oradata/cdb1/redo03.log' SIZE 50M;

2. Once the CDB has been created, you can create a new PDB within it using the CREATE PLUGGABLE DATABASE command. For example:

CREATE PLUGGABLE DATABASE pdb1
 ADMIN USER admin IDENTIFIED BY password
 DEFAULT TABLESPACE users DATAFILE '/u01/app/oracle/oradata/pdb1/system01.dbf' SIZE 50M REUSE
 SYSAUX DATAFILE '/u01/app/oracle/oradata/pdb1/sysaux01.dbf' SIZE 50M REUSE
 DEFAULT TEMPORARY TABLESPACE temp UNDO TABLESPACE undotbs1 LOGFILE GROUP 1 '/u01/app/oracle/oradata/pdb1/redo01.log' SIZE 50M, '/u01/app/oracle/oradata/pdb1/redo02.log' SIZE 50M, '/u01/app/oracle/oradata/pdb1/redo03.log' SIZE 50M;

3. Once the PDB has been created, you can connect to it using the CONNECT command.For example:

CONNECT admin@pdb1

That's a simplified example of how to set up a PDB in Oracle. Keep in mind that there are many additional options and parameters that you can use when creating a CDB or PDB, and you may need to adjust these commands to fit your specific needs.

Comments

Post a Comment

Popular posts from this blog

Auditing user logon and logoff in Oracle

To track when a user logs on or off Oracle, enable auditing and audit CONNECT in your database.  Then you can query DBA_AUDIT_TRAIL to find logon and logoff info. alter session SET NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS'; select username, action,action_name,timestamp,logoff_time from dba_audit_trail where action_name = 'LOGON' and username = '&user'; Here are some more helpful links: http://itechshare.blogspot.com/2010/06/oracle-how-to-track-logon-logout-in.html http://itechshare.blogspot.com/2010/06/oracle-why-dbaaudittrail-shows-more.html
Read more

Use rsync on Unix to backup your archive logs

Rsync is a useful Unix tool for keeping directories in synch between two server.  I use it to copy Oracle archive logs from a production server to a test server. This command runs on my test server from the oracle user's crontab every 5 minutes.  It copies the files via SSH.  New files from the source directory are copied to the test backup directory.  If a file is deleted from the source directory, it is NOT removed from the target directory.  I have it setup this way because I want to control that manually.  I have a separate cronjob that purges archive log files over 3 days old. rsync -rave "ssh -l oracle" sourceServer:/u06/oradata/PROD/arch  /u06/oradata/prodArchBkp Rsync also preserves the timestamp of the source file in the target directory. You can also use rsync to delete files in the target directory that do not exist in the source directory. rsync -rave "ssh -l oracle" --delete sourceServer:/u06/oradata/PROD/arch  ...
Read more

RMAN Restore vs. Recovery - what's the difference?

RESTORE is used to restore the datafiles from a backup. You can restore up to the time of the backup or a point before using SET UNTIL . You would lose any changes made to the database after the backup by performing only a RESTORE. RECOVER is used to roll the database forward after a RESTORE by applying the redo logs. In essence, RECOVER = RESTORE + redo logs. The following example assumes you have lost your control files and datafiles, but still have your redo logs. $ rman target / nocatalog RMAN> startup nomount; RMAN> restore controlfile from '/oback/controlfile'; RMAN> alter database mount; RMAN> restore database; RMAN> recover database; RMAN> alter database open resetlogs;
Read more