Switchback to the original location of the previously corrupted/damaged datafile

In this article, we are going to have look on How to switch back to the original location of the previously corrupted/damaged/lost/canceled datafile.

As you can see the datafile of USERS tablespace is currently located in the flash recovery area. And there is no USERS datafile on the location where other datafiles are.

First […]

Read More

Recover a corrupted/damaged NON-SYSTEM datafile switching to an image copy when database in ARCHIVELOG mode

This article is about recovery of corrupted/damaged/lost/canceled NONSYSTEM datafile switching to an image copy when database in ARCHIVELOG mode. We must have an image copy of my datafiles: The following command is use to take copy.

Now let’s simulate a lost datafile of a NONSYSTEM tablespace

The RMAN report command is no more able […]

Read More

How to recover a corrupted/damaged NON SYSTEM datafile when database in ARCHIVELOG mode

We are going to have a session on recovery about corrupted/damaged/lost/canceled NONSYSTEM datafile (except system & sysaux).  Before proceeding to be sure to have a complete backup of your test database and be sure your database is in ARCHIVELOG mode.

And it’s in ARCHIVELOG mode

Connecting through RMAN I can receive information about […]

Read More

Backup a database in non-archivelog mode without recovery catalog

This article is about the backup of an Oracle database. As DBA we are well known about the types of backup.  Mainly we have two kind of backups in Oracle database first one is physical and another one is logical.  Each type of backups is important in Oracle database’s life maintenance. It depends on projects and client’s requirements that what kind of […]

Read More

Restore a NON-ARCHIVELOG database using a backup controlfile

Being a DBA we must have knowledge on all kind of situation come across database’s life maintenance. We all are aware that CDR  (Controlfile, Datafile, Redologfile) plays a most important role in Oracle database. With the help of backup, we can restore the database . In this article, we are going to learn about the recovery from controlfile in noarchivelog mode. […]

Read More

Restore a NOARCHIVELOG database using current control file

We are going to have a look at recovery in Oracle database.  it’s time to cause a fault in the database so we need to recover it. The scenario is the following: what does it happen and how can I recover a database in NOARCHIVELOG mode when a disk failure occurs and I lost my current […]

Read More

Restore the spfile while using the FRA & not using Recovery Catalog

Today we are going to learn about recovery with rman for loss of spfile. As we know that RMAN can be used either with or without a recovery catalog. A recovery catalog is a schema stored in a database that tracks backups and stores scripts for use in RMAN backup and recovery situations. Generally, a skillful DBA […]

Read More

PDBs Backup (How to identify which PDBs a backup set belong to)

Introduction:- In this article, we are going to have look on PDBs backup.  Normally we have learnt about a different kind of backup available in  Oracle. In cloud computing, we have backups in PDBs. In RMAN we have a script to know about the backup history. Now we can get the information of PDB(backup).  n large scale industries have […]

Read More

Monitoring RMAN Backup with QBR tools

The Quest Backup Reporter is a windows client application. It can connect too many databases at a time and reports directly from oracle data dictionary views and RMAN catalog. It does not make any modification to either database as well as RMAN configuration. It is just a read only reporting tools. Quest Backup Reporter tools […]

Read More