Answer Posted / suman

we are restore the control file from cold/hot backup
after that
$sqlplus / 'as sysdba'
>startup nomount
>recover database using backup controlfile until cancel;
>alter database mount;
>alter database open resetlogs;

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2413

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

998

---

Why would you call update statistics? : sql server DBA

994

---

What are the commands used in dcl? : sql server DBA

1076

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2438

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

996

---

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

2474

---

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

2254

---

what functionality does oracle provide to secure sensitive information?

1000

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1908

---

What is a correlated sub-query? : sql server DBA

1092

---

What is transparent data encryption? : sql server DBA

1199

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1979

---

Where would you look for errors from the database engine?

2858

---

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

1189

---