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

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

what is asm?

0 Answers   Oracle,

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  




What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

how can you create a user-defined lock?

0 Answers   Oracle,

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

For more DB Administration Interview Questions Click Here
Categories