How do you recover a datafile that has not been physically been backed up since

How do you recover a datafile that has not been physically
been backed up since its creation and has been deleted.
Provide syntax example.

Question Posted / narmada kumari

4 Answers
9586 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do you recover a datafile that has not been physically been backed up since its creation and ha..

Answer / bharath

Perform below steps

1) alter database datafile < file_id> offline;
2) alter database create datafile <file_id>;
3) recover datafile <file_id>;
4) alter database datafile <file_id> online;

Is This Answer Correct ?

13 Yes

0 No

How do you recover a datafile that has not been physically been backed up since its creation and ha..

Answer / mallesh

To create datafile,we need the current controlfile or buckup controlfile that recognises the new datafile that was added.
we go to mount stage and create new datafile using command
syntax:
>alter database create datafile;
>alter tablespace <tsname> add datafile '<location>' size;
>alter system switch logfile;

Is This Answer Correct ?

4 Yes

3 No

How do you recover a datafile that has not been physically been backed up since its creation and ha..

Answer / shiva

>alter database create datafile < path>;
> alter database recover automatic datafile < path> /<file_id>

Is This Answer Correct ?

1 Yes

0 No

How do you recover a datafile that has not been physically been backed up since its creation and ha..

Answer / nehru

>alter database create datafile 'old path' as 'new path' size
>recover datafile 'datafile id';

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More DB Administration Interview Questions

What are the steps you will take to improve performance of a poor performing query?

0 Answers

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers

when does an alert gets signaled?

0 Answers Oracle,

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers

What the different types of replication and why are they used? : sql server DBA

0 Answers

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers IBM,

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers

Datapump backup steps?

1 Answers

what is the diffrence between core dba and apps dba?

0 Answers Cap Gemini,

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers

For more DB Administration Interview Questions Click Here