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

How Select Statement Works

When Oracle receives a sql query, it requires to run some pre tasks before actually being able to really run the query.Combination of these tasks is called parsing. During parsing the below operations used to perform. Database validate the syntax of the statement whether the query is valid or not.For example, the following statement fails […]

Read More

Use of Basic RMAN commands

RMAN : RMAN is an Oracle Database client and every DBA’s favorite tool for backup and recovery of the database. We have many RMAN related posts which can help you in all scenarios . However, today we will see a basic RMAN commands that will show what RMAN offers you. This post is mainly for […]

Read More

Upgrade Oracle DBA 11g or 12c to 12c R2 (1Z0-074)

Hi Readers Finally, I’ve successfully passed 1Z0-074, Upgrade Oracle DBA 11g or 12c to 12c R2. It was almost more than 3 months that I’ve been preparing for this. The Exam contains 75 questions related to Oracle Database 12cR2 New Features. To earn this certification you need to get 63% marks. This was the result of […]

Read More

Password Based Encryption in RMAN Backup

In this article we will see password based encryption. Step 1 : Connect to RMAN Step 2 : Set encryption algorithm Step 3 : Here I am taking backup of one tablespace in ORCLPDB pluggable database We can see an error is thrown here , unable to encrypt backup , wallet is not open Explanation […]

Read More