Interested to Buy Any Domain ? << Click Here >> for more details...
one datafile is lost in standy side how can you recover that??
- 2 Answers
- 3867 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil.t
Yes we can recover the database but we will lose uncommitted transactions since log file is not available.
From 2005 onwards we use option called:
CREATE DATABASE database_name for ATTACH option.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what do you understand by fine-grained auditing?
Why would you use sql agent? : sql server DBA
what functionality does oracle provide to secure sensitive information?
How would you go about verifying the network name that the local_listener is currently using?
What is transparent data encryption? : sql server DBA
What purpose does the model database server? : sql server DBA
how can you record information about current session?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the diffrence between core dba and apps dba?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
