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
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?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what is a user-defined lock?
What are the operating modes in which database mirroring runs? : sql server DBA
how to restore files with rman?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
internal architecture
how can you get actual data change values from previous transactions in oracle?
What is a correlated sub-query? : sql server DBA
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.
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How to start SQL Server in minimal configuration mode?
What are the steps you will take to improve performance of a poor performing query?