RECOVER DATAFILE WITHOUT PRIOR BACKUP

Recover datafile without prior backup

Condition:

Database should be in archivelog mode,

All archive logs are needed from the lost datafile created.

Step 1:

Sql>shu immediate;

Step 2:

Physically delete any one non critical datafile from the database,

(but the condition you need all archivelogs files from that particular datafile created  to recover)

give delete only  dnt give the ctrl+shift+delete in that.

Sql>startup

Database stopped at mount stage with above error.

We need to open the database because of the other user work  on the database,thats y we make that lost datafile offline mode,and open the database.

Step 3:

Sql>alter database datafile 9 offline;

Sql>alter database open;

Check the status of the datafile;

Sql>select * from v$datafile;

Sql>select  file#,status from v$datafile;

Step 4:

Now we need to recover the lost datafile 9, for that create the one datafile

Sql>alter database create datafile ‘e:\oracle\product\10.2.0\oradata\agile2\rman1.dbf’;

Datafile create in the same name.

Step 5:Recover datafile without backup

Connect rman

C:\rman target /

Rman>recover datafile 9;

Recovery completed

Step 6:change the datafile into online mode

Sql>alter  database  datafile  9 online;

  

step 7: check the database datafile 9 will present

Sql> select name from v$datafile;