The SYSBACKUP is a new privilege introduced in the Oracle Database 12c release that allows a user to perform any backup or recovery operations.
It is heartily suggested to create a new user with the SYSBACKUP privilege granted and perform daily backup activities with that new user, instead of using directly the SYSBACKUP user created by default during the database installation: the SYSBACKUP user should even remain locked.
Before proceeding I will need to create (more...)
Few days ago I was wondering how many RENAME clause are available on Oracle Database. I have summarized them here:
- Renaming redolog members;
- Renaming tablespaces;
- Renaming datafiles of a single offline tablespace;
- Renaming constraints;
- Renaming schema objects (tables, views, sequences, private synonyms, indexes, triggers);
- Renaming table columns;
- Renaming table and index partitions (subpartitions);
- Restoring and Renaming table from the Recycle Bin;
- Changing the domain in a global database name for a CDB;
- Renaming a PDB;
One of the most useful enhancement Oracle has introduced within the release 12c in RMAN is the possibility to execute more SQL statements.
Of course RMAN is primarily used for backup and recovery operations, but sometimes I need to run SQL commands: so in 11g or lower I have to open another terminal/tab or quit the current RMAN session and start a new one with sqlplus.
In Oracle Database 12c instead most of the sql (more...)
I want to see what useful information are returned by few RMAN commands such as report schema
or list backup
when using the default RMAN configuration and getting some backups.
When connected to the ROOT container issuing the RMAN report schema
command is quite simple identify how many pluggable databases are plugged into the container database and, above all, the relationship with their datafiles and locations.
In my case the container database, named CDB001, contains (more...)
I'm going to test some useful recovery scenarios for the Oracle Database 12c release.
An interesting option introduced with this release is the possibility to restore even a single table, without impacting other objects, tablespace or database when that table is no more in the recycle bin.
The current release I'm using is Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit based on a Linux platform.
Let's start with an (more...)
I've just finished to setup at home an Oracle Real Application Clusters virtual environment formed by two nodes.
I would like to monitor and eventually execute some commands from another machine where I've installed the latest (at the moment of this post of course) available Enterprise Manager Cloud Console 12c that is Oracle Enterprise Manager Cloud Control 12c Release 3 Plug-in Update 1 (22.214.171.124) which contains the original 12c Release 3 (12. (more...)
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...)
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...)