Interested to Buy Any Domain ? << Click Here >> for more details...
one datafile is lost in standy side how can you recover that??
- 2 Answers
- 3949 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
how can a session indicate its interest in receiving alerts?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Query processing is slow(eg select query)how will u solve that
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain materialized views and how they are used.
which background process invoke at the time of upgradation tell me???
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how can you process messages in order asynchronously?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What would you do with an "in-doubt" distributed transaction?
what is ora 24313?what is the procedure to exclude that error?
How to start SQL Server in minimal configuration mode?
What are the operating modes in which database mirroring runs? : sql server DBA
What happens on checkpoint? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
