Answer / anonymous

Have to manually create a new control file.

Answer / ramesh chowdary

I would create a text based backup control file,
stipulating where on disk all the data files where and then
issue the recover command with the using backup control
file clause.

Answer / y. naresh kumar

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE:

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

---

what is grd?

0 Answers   Oracle,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---