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

Question Posted / 999ysuman

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

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

2 Answers CSC,

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers

Explain about your sql server dba experience? : sql server DBA

0 Answers

what are the differences of where and if in SAS?

0 Answers

what is meant by gateway

1 Answers IBM,

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers

what is incremental checkpoint?

1 Answers CTS,

what r the types of backup?

5 Answers CSC,

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers

what are the performance views in an oracle rac environment?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here