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

one datafile is lost in standy side how can you recover that??

Question Posted / 999ysuman

Answers were Sorted based on User's Feedback



one datafile is lost in standy side how can you recover that??..

Answer / anil.t

Yes we can recover the database but we will lose uncommitted transactions since log file is not available.

From 2005 onwards we use option called:
CREATE DATABASE database_name for ATTACH option.

Is This Answer Correct ?    0 Yes 0 No

one datafile is lost in standy side how can you recover that??..

Answer / harshad khuspe

Stop medial recovery. Take RMAN backup of that datafile and SCP to target database. Recover that datafile.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

what is rebuild index??

2 Answers   IBM, Sapient,

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

what is asm?

0 Answers   Oracle,

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  




How would you force a log switch?

4 Answers  

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

how can you initialize log miner?

0 Answers   Oracle,

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

How would you go about generating an EXPLAIN plan?

2 Answers  

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

For more DB Administration Interview Questions Click Here
Categories