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

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

4 Answers

how to restore files with rman?

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

Which autogrowth database setting is good? : sql server DBA

0 Answers

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers

what do you understand by fine-grained auditing?

0 Answers Oracle,

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers

How can we know the exact updation date of a particular database?

2 Answers Satyam,

Give two examples of referential integrity constraints.

2 Answers

what is the use of home directory???

1 Answers HP,

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers

For more DB Administration Interview Questions Click Here