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
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can you create a user-defined lock?
what is a user-defined lock?
what are the types of connection load-balancing?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
when does an alert gets signaled?
what is the use of ocr?
What is fill factor? : sql server DBA
Where would you look for errors from the database engine?
how can you get actual data change values from previous transactions in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is dbcc? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are statistics, under what circumstances they go out of date, how do you update them?