Interested to Buy Any Domain ? << Click Here >> for more details...
one datafile is lost in standy side how can you recover that??
- 2 Answers
- 3865 Views
- I also Faced
- E-Mail Answers
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
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what is the use of ocr?
Can you redefine a table online?
. 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?
how can you implement fine-grained auditing?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what is a user-defined lock?
What is replication? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is fill factor? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you get actual data change values from previous transactions in oracle?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What the different types of replication and why are they used? : sql server DBA
