Answer / 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.

Answer / harshad khuspe

Stop medial recovery. Take RMAN backup of that datafile and SCP to target database. Recover that datafile.

deleted of control file how will u recover control file?

4 Answers   CTS,

---

Can we take incremental backups in datapump?

1 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

How can you rebuild an index?

6 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  

---