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
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
what are the benefits of flashback feature?
What the different types of replication and why are they used? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how can you communicate with operating system files from oracle?
what are the types of connection load-balancing?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
what is ora 24313?what is the procedure to exclude that error?
What are the operating modes in which database mirroring runs? : sql server DBA
how can you implement fine-grained auditing?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what functionality does oracle provide to secure sensitive information?