1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

I lost one datafile i dont have backup how can you recover that???

Question Posted / 999ysuman

Answers were Sorted based on User's Feedback



I lost one datafile i dont have backup how can you recover that???..

Answer / mohapatra.gouranga@gmail.com

Recovery is not possible if no backup.
But inconsistent recovery is possible by following method:
1.shutdown your database
2.take the database in mount state
3. Make the tablespace of lost datafile to off line.
4.alter database create datafile 'old_datafile_path'
as 'new_datafile_path';
5. Made the database online.
6.once new file created do the incomplete recovery. from
any old backup.
7. open the database with resetlogs.

Is This Answer Correct ?    3 Yes 0 No

I lost one datafile i dont have backup how can you recover that???..

Answer / mohapatra.gouranga@gmail.com

Recovery is imposible if no recent backup available with
archive logs. But inconsistent recovery is possible if any
old backup pieace available. Can be followed following
method.
1.shutdown your database
2.take the database in mount state
3. Make the tablespace of lost datafile to off line.
4.alter database create datafile 'old_datafile_path'
as 'new_datafile_path';
5. Made the database online.
6.once new file created do the incomplete recovery. from
any old backup.
7. open the database with resetlogs.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

What is checkpoint?

3 Answers   Accenture,

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

What is fill factor? : sql server DBA

0 Answers  

How many memory layers are in the shared pool?

3 Answers  




What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

When a user process fails, what background process cleans up after it?

1 Answers  

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

what is the use of recording information about current session?

0 Answers   Oracle,

Explain the concept of the DUAL table.

3 Answers  

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories