one datafile is lost in standy side how can you recover that??
- 2 Answers
- 3076 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 the different types of replication and why are they used? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
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.
what is the use of recording information about current session?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
what is a user-defined lock?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Where do you find the default index fill factor and how to change it? : sql server DBA
How do you open a cluster administrator? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
how can you record information about current session?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
