I wanted to write a post on configuring the RMAN environment using the SHOW
commands in Oracle Database 12c,
but after few commands I decided to investigate about the differences on default RMAN settings between the versions 10g, 11g and 12c.
Here are part of my results: the (more...)
Beside the DBMS_PDB
package you can use Oracle Data Pump
to create a pluggable database from a non-container database: it consists to export the non-CDB and import into an empty and already created pluggable database.
In my case the non-container database I want to transform into a pluggable database is (more...)
In this post I want to describe how to create a PDB by cloning a remote existing pluggable database: at the end of this process you should have a new PDB (in my case PDB103) contained in a target CDB (CDB001) cloned from a source PDB (PDB003) contained in a (more...)
To test this scenario I have recently created using DBCA a non container database named ORCL. CDB001 and CDBTEST are instead two container databases.
[oracle@vsi08devpom ~]$ ps -ef|grep smon
oracle 4081 1 0 Jul15 ? 00:01:30 ora_smon_CDB001
oracle 11394 1 0 10:20 ? 00:00:00 ora_smon_ORCL
oracle 12586 9609 0 10:46 pts/0 00:00:00 (more...)
You have just unplugged a PDB and want to know how to eventually plug it back into the same container.
Let's assume I have a pluggable database named PDB003 and I am just able to unplug it using the following commands:
SQL> alter pluggable database pdb003 close immediate;
Pluggable database (more...)
So you want create a new pluggable database into the CDBTEST container located into vsi08devpom machine (@vsi08devpom in this post) and you want the exact copy of PDB003 pluggable database contained into CDB001 located into my local machine (@localhost in this post).
Why not simply unplug it from my local (more...)
Using the CREATE PLUGGABLE DATABASE ... FROM
command you can clone an existing pluggable database (the source pdb) to create a new pdb (the clone pdb).
The source pdb could be in the current local container or it can be located in a remote container (in a next post): during a (more...)
When you need to modify the open mode of all your PDBs at the same time (look at this post
if you want to change the open mode of only a specific pluggable database) you can use ALTER PLUGGABLE DATABASE
command and the ALL
As usual you have to (more...)
The open mode of the container database imposes limitations on the open mode of PDBs.
example, the root must be open before any PDBs can be open. Therefore, you
might need to change the open mode of the root before changing the open mode of
a PDB. Let's start.
The clauses of the ALTER PLUGGABLE DATABASE
statement that modify the mode of a PDB are:
- OPEN READ WRITE [RESTRICTED] [FORCE]
: it opens the PDB in read/write mode;
- OPEN READ ONLY [RESTRICTED] [FORCE]
: it opens the PDB in read-only mode;
- OPEN UPGRADE [RESTRICTED]
: it (more...)
The new architecture provided by Oracle Database 12c enables an Oracle database to function as a multitenant container database (CDB):
it can include zero, one, or many pluggable databases (PDBs), that is a portable collection of schemas, schema objects and nonschema objects.
A multitenant container database (CDB) is formed by (more...)
Here is a video recorded during the creation of the first database. Go on if you want to see all the screenshots.
So we have already installed the software of the Oracle Database 12c release 1 (have a look at this post
) and now we want to create (more...)
Configuring the HTTPS Port for EM Database Express 12c
If you used dbca to configure your database and enabled to configure also the EM Express you can find the EM Express URL provided by DBCA in the latest GUI screen.
If you forget the URL you can use the following (more...)
So you want to use your Ubuntu distribution and connect to an Oracle database.
Here you can find the steps to install and configure the Oracle Instant Client on Ubuntu 12.04.
First of all you need to go to the following link
and choose the (more...)
Few pictures taken during the Oracle Database 12c presentation in Rome.
In this post I'm going to install only the software of the Oracle Database 12c release 1.
Download from Oracle website and extract it into the home directory of the oracle user.
[oracle@localhost ~]$ pwd
[oracle@localhost ~]$ cd database/
[oracle@localhost database]$ ./runInstaller &
The GUI of the installer is (more...)
So as you should know Oracle Database Server 12c release 1 is finally out there and this is my first post about it.
I've just finished to download some fundamental documents from Oracle website such as "2 Day DBA", "New Features Guide", "Concepts Guide", "Upgrade Guide", "Administrator's Guide" (1360 pages!!! (more...)
Imagine someone has deleted your spfile or you have modified it in depth that you are now unable to even startup your database.
Your only option
is to restore your spfile and this step is easy if you have not forgot to setup your RMAN environment to use the AUTOBACKUP (more...)
When you don't know the date and time to which you want to recover the database, SCN-based incomplete recovery
could be taken into consideration especially if you are able to retrieve a particular SCN.
In this scenario I will perform
a SCN-based incomplete recovery after I have used the Oracle (more...)
Every incomplete recovery is followed by a resetlogs command before opening the database: each time you use a resetlogs command, a new incarnation
of the database is created.
While performing incomplete recovery it should be known the target point at which the recovery process needs to terminate: there are several (more...)