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
9793 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

how can you communicate with operating system files from oracle?

0 Answers Oracle,

How does Oracle guarantee data integrity of data changes?

1 Answers SoftSol,

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers

what is logical system in sap basis

0 Answers

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers

how can you initialize log miner?

0 Answers Oracle,

Explain CREATE DATABASE syntax?

2 Answers

what is the use of recording information about current session?

0 Answers Oracle,

How would you determine who has added a row to a table?

4 Answers

How would you begin to troubleshoot an ORA-3113 error?

1 Answers

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers Oracle,

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

For more DB Administration Interview Questions Click Here