RMAN New Features Oracle 12c

Nowadays keeping up with time is the core of our job so every now and again it's necessary to go over the new Oracle database release even if there isn't an immediate necessity.

In this post I would like to talk about the RMAN new features in a multitenant environment.

Let's get down this post, shall we ?

According to the Oracle 12c reference manual it is now possible to back up and recover an entire CDB and all PDBs or only the CDB root container and what's more only one or more PDBs within the CDB.

Let's start from the beginning !

1) Backup an entire CDB container and all the PDB included :

RMAN> connect target /
RMAN> backup database;

In case you need it's also possible to do a backup of all archive logs rewriting the previous command :

RMAN> connect target /
RMAN> backup database plus archivelog;

As you can see this command isn't so different from previous backup command release.

NB: Since we are connected to CDB level and what's more the redo plus archived log files are only created at this level, we have been able to backup the archive log. Otherwise it isn't possible when we are connected to PDB level.


2) Backup only PDB :

RMAN> connect target /
RMAN> backup pluggable database pdb11;

It's also possible to backup multiple PDBs within the same command:

RMAN> backup pluggable database pdb10,pdb11;

3) Backup only the root container:

RMAN> backup pluggable database 'CDB$root';

4) Partial backup of a PDB:

RMAN> connect target /
RMAN> backup tablespace users;pdb10;


More or less that's all about the new backup command in Oracle 12c.

Please remember that it's always necessary to go over these commands and what's more verify these in a Test environment.

See you in my next blog !

Byeee !!!

Installing Oracle 12c Rac on VirtualBox - Part 2

Hi there,
following you'll find the second part of "Installing Oracle 12c Rac on VirtualBox".

1) Install the required RPM module :

yum install gcc
yum install kernel-uek-devel
yum search oracle-rdbms-server

2) Create the Oracle and Grid users and groups:

groupadd -g 1500 dba
groupadd -g 1501 oinstall
groupadd -g 1502 asmadmin
groupadd -g 1503 asmdba
groupadd -g 1504 asmoper

useradd  -u 1500 -p oracle -g oinstall -G dba,asmdba oracle
useradd  -u 1501 -p oracle -g oinstall -G dba,asmdba,asmadmin,asmoper grid

NB: According to Oracle reference book I decided to keep divided the Oracle software owner from the Grid software owner.

3) Create the ORACLE_HOME and ORACLE_BASE directory :

mkdir -p /u01/app/12.1.0/grid
mkdir -p /u01/app/grid
mkdir -p /u01/app/oracle
chown -R grid:oinstall /u01
chown oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/

4) Configure operating system kernel parameter :

kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

5) Modify Grid and Oracle resource limit :

File : /etc/security/limits.conf
   
 grid   soft    nproc    2047
 grid   hard   nproc   16384
 grid   soft    nofile    1024
 grid   hard   nofile    65536
 grid   soft    stack    10240
 grid   hard   stack    10240
   
oracle   soft    nproc    2047
oracle   hard   nproc   16384
oracle   soft    nofile    1024
oracle   hard   nofile    65536
oracle   soft    stack    10240
oracle   hard   stack    10240


6) Configuring shared storage: 

Oracle clusterware needs to be able to work a shared storage, so it's necessary to configure the server machine and the linux server too.

Let's start with the virtual machine !

First of all you have to stop the linux server and then using the Oracle Virtual box client do the following:

1) Add a SCSI controller.

2) Create three new VDI disks with a fixed size.

 OcrVoting    6Gb
 ORADATA      6Gb
 ORAFRA       6Gb

3) From the menu FILE of Virtual box program open the Virtual Media Manager utility.

4) Mark all of then as sharable disks.

 All these steps end up creating sharable disks that we are going to use within our cluster which is made up with two linux server.

Let's get the ball rolling, shall we ?

First of all we have to configure new disks within the linux server. There are different tricks to do so. For example we can use UDEV rules or asmlib plus multipath daemon. Both of them turn out to make the disks persistent during a system reboot.

By the way, since this is only a Test environment I won't install and configure the multipath daemon but don't do it in a production environment it's dangerous !!!

To be continued.....

Byeee

Installing Oracle 12c Rac on VirtualBox - Part 1

In 2005 I worked as a DBA Oracle at a public department in Rome. While I was working there an important project was approved and this approval turned out in a new Oracle 10 RAC installation.

Oracle technicians implemented only the production environment made up with 2 Oracle database nodes. 

Since I've always thought that doing stuff is the best way to learn something, I decide to try the installation process out on a test environment.

Let's start to install Oracle 12c RAC on two VirtualBox server. First of all we have to install a new linux server then we can clone it afterwards.

The following are the binary files that are necessary :

1) VirtualBox-4.3.16.exe
2) Oracle Linux 6
3) linuxamd64_12c_database.zip
4) linuxamd64_12_grid.zip

Indeed Oracle 12.1.0.2 is certified with Oracle Linux Server 6.

The installation steps of a Linux server isn't the most important thing of this post, so you won't find all the details about it. 

By the way don't worry because every now and again I'll go over it.

To be continued...

See you soon...

Bye