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

Question Posted / 999ysuman

2 Answers
2862 Views
I also Faced
E-Mail Answers

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

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers

what is the use of recording information about current session?

0 Answers Oracle,

what is the use of ocr?

0 Answers Oracle,

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

0 Answers

Explain the difference between a data block, an extent and a segment.

2 Answers

what do you understand by fine-grained auditing?

0 Answers Oracle,

Explain an ORA-01555

2 Answers

What authentication modes does sql server support? : sql server DBA

0 Answers

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers Cognizant,

What happens on checkpoint? : sql server DBA

0 Answers

wat is global index and local indes

1 Answers Oracle,

what is the difference between catalog & nocatalog?

3 Answers CSC,

For more DB Administration Interview Questions Click Here