Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

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.

1665


How would you go about verifying the network name that the local_listener is currently using?

3161


what are the types of connection load-balancing?

940


which background process invoke at the time of upgradation tell me???

2664


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1989


how can you find out if a table can be redefined?

964


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1191


what is asm?

997


What are the steps you will take to improve performance of a poor performing query?

2794


Can you redefine a table online?

1061


Where do you find the default index fill factor and how to change it? : sql server DBA

1025


how can you process messages in order asynchronously?

931


how can a session indicate its interest in receiving alerts?

982


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.

2113


what is the use of ocr?

967