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:

What does coalescing a tablespace do?

1 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

How can you enable a trace for a session?

1 Answers  

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

---

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

what is meant by gateway

1 Answers   IBM,

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

How would you force a log switch?

4 Answers  

---