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

Question Posted / 999ysuman

2 Answers
6358 Views
HP, I also Faced
E-Mail Answers

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

Name two files used for network connection to a database.

5 Answers

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers CSC, Logica CMG,

Explain materialized views and how they are used.

0 Answers

What is dbcc? : sql server DBA

0 Answers

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

Can you redefine a table online?

0 Answers Oracle,

What happens on checkpoint? : sql server DBA

0 Answers

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers TCS, Wipro,

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

0 Answers

What is fill factor? : sql server DBA

0 Answers

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here