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
9783 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 will u see whether the dabase is in archive log mode or not?

2 Answers CSC,

What column differentiates the V$ views to the GV$ views and how?

3 Answers

what is difference between user managed backup and rman backup?

1 Answers CTS,

what is asm?

0 Answers Oracle,

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers

deleted of control file how will u recover control file?

4 Answers CTS,

internal architecture

0 Answers CSC,

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers TCS,

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers HSBC,

what is logical system in sap basis

0 Answers

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers

For more DB Administration Interview Questions Click Here