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

Question Posted / 999ysuman

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

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers

How do you open a cluster administrator? : sql server DBA

0 Answers

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

2 Answers HP,

how can a session indicate its interest in receiving alerts?

0 Answers Oracle,

Explain the use of table functions.

1 Answers

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers

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