Interested to Buy Any Domain ? << Click Here >> for more details...
one datafile is lost in standy side how can you recover that??
- 2 Answers
- 3821 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 you enable flashback feature?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
how can you create a user-defined lock?
Can you redefine a table online?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is logical system in sap basis
what functionality does oracle provide to secure sensitive information?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is a user-defined lock?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
