Answer Posted / mudit

No ,Recovery catalog should be place in separated database
for security reason as recommended by oracle.

we can use RMAN without RC,by using Target Database control
file.

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2347

---

What is the default port no on which sql server listens? : sql server DBA

1216

---

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

2458

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1998

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1123

---

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

1048

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2744

---

What is the difference between clustered and non-clustered index? : sql server DBA

1143

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2027

---

how can you create a user-defined lock?

1055

---

how to restore files with rman?

2358

---

who owns the operating system files created by the utl_file package?

1125

---

What is the default fill factor value? : sql server DBA

1184

---

What would you do with an "in-doubt" distributed transaction?

1936

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2093

---