one datafile is lost in standy side how can you recover that??
- 2 Answers
- 2875 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 is the use of recording information about current session?
How can you control the amount of free space in your index pages? : sql server DBA
how can you implement fine-grained auditing?
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
Can you redefine a table online?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
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.
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
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is replication? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
what functionality does oracle provide to secure sensitive information?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
