Recovery of a Missing Datafile that has no backups (database is open).

Datafile Lost due to OS level delete:
=====================================
Recovery of a Missing Datafile that has no backups (database is open).
If a non system datafile that was not backed up since the last backup is missing,
recovery can be performed if all archived logs since the creation
of the missing datafile exist.
Pre requisites: All relevant archived logs.
1. alter datafile offline immediate;
2. alter database create datafile ‘fully_qualified_file_name’;
3. alter database datafile ‘fully_qualified_file_name’ online;

If the create datafile command needs to be executed to place the datafile on a
location different than the original use:
alter database create datafile ‘fully_qualified_file_name’ as ‘fully_qualified_file_name’;

Advertisements

About shanojkumar

* Has 12 years of experience in Planning, Implementing, Managing and Monitoring the Oracle Databases as an (Oracle 10g & 11g OCP) Certified Oracle Database Administrator.
This entry was posted in Oracle and tagged , , , . Bookmark the permalink.

3 Responses to Recovery of a Missing Datafile that has no backups (database is open).

  1. govardhan says:

    Hi Shanoj,

    Myself Govardhan,I read all your posts it looks good,thank you for sharing.
    did you have any chance to provide training on oracle DBA course?

    Thank you.

    • shanojkumar says:

      Thanks Govardhan for your feedback.
      As of now I am not conducting any training, but you can write to me your doubts on Oracle Database Administration
      and I will try to help you ..

      regards,
      Shanoj

  2. Ashwin says:

    Fantastic work Shanoj . . These are really helpful for budding DBA aspirants . Keep it Up !! cheers

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s