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
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
How would you go about verifying the network name that the local_listener is currently using?
what are the types of connection load-balancing?
which background process invoke at the time of upgradation tell me???
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how can you find out if a table can be redefined?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is asm?
What are the steps you will take to improve performance of a poor performing query?
Can you redefine a table online?
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you process messages in order asynchronously?
how can a session indicate its interest in receiving alerts?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
what is the use of ocr?