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

Question Posted / 999ysuman

2 Answers
6192 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

If CPU is very slow What can u do to speed up?

1 Answers

What type of index should you use on a fact table?

1 Answers

What are the different types of indexes available in sql server? : sql server DBA

0 Answers

Explain an ORA-01555

2 Answers

How can you gather statistics on a table?

3 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,

Explain the concept of the DUAL table.

3 Answers

What is dbcc? : sql server DBA

0 Answers

who owns the operating system files created by the utl_file package?

0 Answers Oracle,

how can you enable flashback feature?

0 Answers Oracle,

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers

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

4 Answers

For more DB Administration Interview Questions Click Here