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

Question Posted / 999ysuman

2 Answers
3781 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 dcl? : sql server DBA

0 Answers

What is transparent data encryption? : sql server DBA

0 Answers

How do you resize a data file?

2 Answers

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers

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

4 Answers

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers Genpact,

how do see how much space is used and free in a tablespace

2 Answers Genpact,

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers

why we use cursors

1 Answers

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

2 Answers

How to start SQL Server in minimal configuration mode?

1 Answers

wat is global index and local indes

1 Answers Oracle,

For more DB Administration Interview Questions Click Here