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
9633 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 is ora 24313?what is the procedure to exclude that error?

0 Answers

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

3 Answers

Which autogrowth database setting is good? : sql server DBA

0 Answers

Oracle 11g new features?

2 Answers

Explain the concept of the DUAL table.

3 Answers

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers

Explain the difference between a data block, an extent and a segment.

2 Answers

what is ora 600?

1 Answers

Explain CREATE DATABASE syntax?

2 Answers

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers

Explain how you would restore a database using RMAN to Point in Time?

1 Answers

Explain an ORA-01555

2 Answers

For more DB Administration Interview Questions Click Here