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

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

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

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

Hot Backup with RMAN in Oracle

We are going to have look on the backup of Oracle, Which is common in DBA’s life. HOT Backup is the most common way to have a backup. Let’s have look on the steps of Oracle’s HOT Backup. Check the archive status SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            […]

Read More

Cold Backup with Rman in Oracle

Today we are going to have look on Cold Backup. Being DBA we are aware of the importance of Backup in Oracle. Different kind of backup has a different kind of uses. Let’s have look on Cold Backup. Steps for Cold Backup SQL> create table cold_back(name varchar(100)); Table created. SQL> insert into cold_back values(‘********* DATA INSERTED […]

Read More

RMAN Recovery From Missing All Control File

Today we are going to have look on the steps which are used by “DBA” for RMAN Recovery From Missing All Control File. SQL> select dbid from v$database; DBID ———- 847839442 RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default […]

Read More

RMAN Backup With Archivelog

This post is  about how to take RMAN Backup With Archivelog RMAN> run { allocate channel c1 type disk; backup database; backup(archivelog all); } RMAN> backup archivelog all delete input; Note: This will backup all archivelog file and delete those from a target location. If we physically delete some archivelog file before backup then we have […]

Read More

Catalog Database in RMAN

Purpose of Catalog Database A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. A virtual private catalog is a set of synonyms and views that enable user access to a subset of a base recovery catalog. Catalog Database can be two types Base recovery catalog Virtual […]

Read More