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:

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

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

2 Answers   TCS,

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

Give the reasoning behind using an index.

2 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

---