Composite Partitioning in Oracle

In this article we will see examples of various types of composite partitions 1.RANGE-HASH composite partitioning : 2.LIST-HASH composite partitioned table 3.LIST-RANGE Partitioned table : 4.LIST-LIST partitioned table 5.RANGE-LIST Partitioned table : 6.RANGE-RANGE Partitioned table : Thank you for giving your valuable time to read the above information. If you want to be updated with […]

Read More

Types of Table Partitions in Oracle

In this article we will see types of partitions available in Oracle. Range Partitioning : Range Partitioning works with range of column values. It sets lower boundaries and upper boundaries to the partition. It is widely used with DATE data types. Lets create one range partition to understand it better.It is generally used with DATE […]

Read More

Index Partitioning

In previous article we saw what is partitioning in oracle and the benefits its brings . http://oracle-help.com/oracle-database/oracle-partitioning/         In this article we will see Index partitioning. Indexes are the essential part of any SELECT and DML operations which we run on the database. So , when we tune the table we must consider […]

Read More

Oracle Partitioning

As a DBA we must have heard about Partitioned tables or Partitioned index in our tenure or may be we have used it at some extent.Here in this post we will see what is Partitioning and what benefits it brings. The first question that arises is What is Partitioning ? Partitioning means dividing your large […]

Read More

Recovery Scenario of Database

Here we will simulate recovery scenario of database.First we will create crash situation and then we will try to recover from that. Check backup is available for your database Now connect your pluggable database Create one tablespace in pluggable database . Create one user and grant quota on this tablespace to that user. Now lets […]

Read More

Creating a Backup Schedule

Being a DBA it is your key responsibility to set a proper backup strategy. Today we will see how we can schedule backup : Step 1 : Create script to take backup , Here I have created linux shell script Check above backup script , I have used quite a few RMAN parameters to make […]

Read More

Set TIME and DATE Format in RMAN

To simulate , I took fresh RMAN backup using following command. Step 2 : Check backup using list backup command . Let’s add some parameter to set time format in RMAN. Add following parameter in your .bash_profile which resides in home directory of oracle user. Now , run .bash_profile file to give effect Now , […]

Read More

Restore Encrypted Backup

Here we will see how we can password based encrypted backup. I am taking a fresh backup using password based encryption. To know more about password based encryption of RMAN go through following article http://oracle-help.com/backup-and-recovery/password-based-encryption-in-rman-backup/ Step 1 : Take encrypted backup using following command in RMAN Note : I gave “orarmanbkp” password for encryption. Check […]

Read More

Recover Password File

Password file in the Oracle database is must to login remotely for sysdba privileges. Oracle creates password file automatically while creating database using DBCA by asking us what password to set for sys and system users. Here we will see how we can recover from the situation when we lost our password file. It can […]

Read More