Recover from a loss of the SYSTEM tablespace on the original location

Recovery is an important process for any kind of organization.   if the database can not recover properly   That is the worst condition of any DBA‘s professional because it causes unlivable loss of an organization.  We have many kinds of solutions to restore the database according to the loss of database. We are going to have […]

Read More

Recover from a loss of a temporary tablespace

This article is about a recovery of temporary tablespace. As we know that Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory (see SORT_AREA_SIZE initialization parameter), space will be allocated in […]

Read More

Recover from a loss of a read-only tablespace

Being an Oracle DBA we are aware that there are many types of backups are available for Oracle database maintenance in the same way we have multiple ways to restore our database. One question raises here that why do we need have a different kind of ways to backup and recovery in Oracle database? Answer of this question […]

Read More

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