image

When to use SET DBID in RMAN

We should use the command SET DBID in RMAN under the following circumstances. You are not connected to a recovery catalog and want to restore the control file or server parameter file (SPFILE) You are connected to a recovery catalog want to restore the control file, but the database name is not unique in the … continue reading

image

Recover Oracle database from a corrupt or missing control file

This article will detail about the recovery of oracle database due to loss or corrupt of control file under two senario 1. Corrupt or Missing of Control File 2.  All control files are corrupt or missing If you don’t know the location of the control file as well as multiplexing of the control file click … continue reading

image

Deleting the Archive Log in Using RMAN in oracle

run { allocate channel for delete type disk; change archivelog until time ‘SYSDATE-7′ delete; release channel; } OR BACKUP ARCHIVELOG UNTIL TIME ‘SYSDATE-7′; DELETE COPY OF ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-14′; OR allocate channel for delete type disk; change archivelog until time ‘SYSDATE-7′ delete; release channel;      

image

Recovering Oracle Database from the loss of spfile

NOTE : ALWAYS MAKE SURE YOU HAVE YOUR LATEST FULL BACKUP Lets first give a short look how to take the full backup $RMAN target / RMAN> BACKUP DATABASE plus ARCHIVELOG; Lets move towards the topic. Here i will show you how to recover the oracle database from the loss of the spfile. I will … continue reading

image

Checking the Availability of the Backup in ORACLE

The first step in any recovery procedure is to confirm the availability of the complete set of backup. By complete set I mean all the files required for the recovery. This is called the Redundancy Set. The set of files needed to recover an Oracle database from the failure of any of its files – … continue reading

image

Recovering From Missing Data Files in Oracle

This article will brief you  with HOW TO RECOVER a missing datafile using a RMAN disk based backup.. Since every tables are the logical notation of the data in real every record resides in the data file. Now what happens if the data file is corrupt is missing. PLEASE MAKE SURE YOU HAVE VALID BACKUP … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube