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

Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris

1 Answers

How do you tell what your machine name is and what is its IP address?

4 Answers

What is checkpoint?

3 Answers Accenture,

What purpose does the model database server? : 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

what is ora 600?

1 Answers

How would you go about verifying the network name that the local_listener is currently using?