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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

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

703


What are the different sql server versions you have worked on? : sql server DBA

627


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1635


What are the different ways you can create databases in sql server? : sql server DBA

687


How would you go about verifying the network name that the local_listener is currently using?

2840






What is a correlated sub-query? : sql server DBA

667


what is ora 24313?what is the procedure to exclude that error?

2197


how can you record information about current session?

582


In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2043


how can you implement fine-grained auditing?

687


What is fill factor? : sql server DBA

739


how can you get actual data change values from previous transactions in oracle?

698


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1734


What are the different types of upgrades that can be performed in sql server? : sql server DBA

787


how can you enable flashback feature?

626