one datafile is lost in standy side how can you recover that??
- 2 Answers
- 2905 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 to restore files with rman?
What are statistics, under what circumstances they go out of date, how do you update them?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
. 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?
What is replication? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
Why would you use sql agent? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what are the types of connection load-balancing?
What the different components in replication and what is their use? : sql server DBA
What types of replication are supported in sql server? : 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
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
