Recovering from removed/deleted datafile

In this post will discuss on how to recover from the scenario where someone somehow deleted any datafile. But before proceeding make sure you have a backup of the database, and the archive logs from the backup till date. So to recover from that scenario we must create that scenario.

For creating scenarios follow this:

• Make sure you’ve a Permanent Tablespace which is not that important (In Test Env). If you don’t want to use any existing tablespace then create a new tablespace to take it to this scenario.

SYS@DBACODE > CREATE TABLESPACE USERS DATAFILE '/oracle_11204/oracle/oradata/dbacode/datafile/users01.dbf' SIZE 60M;

Tablespace created.

Create a Linux / Unix Mount Point

In this post we will see how to create a Mount Point in Linux. For this post I'll be using Oracle Linux 6.4 on Virtual Box. This tutorial can be used for any UNIX, but before doing to actually on Live Machine, first use it in Test Machine and if everything is fine do it on Live Machine.

If you are using Linux on VMWare, the step to add storage will be somewhat different but rest of it will be same.

Follow below steps in order to create a mount point on Linux –

• Add new SATA disk(s) in Virtual Machine.
  Select the Machine where the Linux is installed (In this case dbrhel)
  Machine Setting -> Storage -> Controller:SATA -> Add Disk
  Provide the required details.