Answer / robertson

HOW TO CREATE BACKUP CONTROL FILE;
In the primary server
sql>alter database backup controlfile to trace;

It gets created in the user_dump_dest path.
sql>show parameter user_dump_dest

HOW TO CREATE STANDBY CONTROL FILE;
In the primary server
sql>alter database backup controlfile
to '/uo1/app/bkpctrl.ctl';

Then ftp the file to the standby controlfile.

Rename the standby controlfile witht the primary file.

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

0 Answers  

---

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

---

How do you use trigger to create mutating state of table

2 Answers   TCS,

---

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers  

---

types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers  

---

What view would you use to determine free space in a tablespace?

0 Answers  

---

What is cardinality?

4 Answers  

---

how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)

1 Answers  

---

Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?

1 Answers  

---

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

0 Answers  

---

Where would you look for errors from the database engine?

2 Answers   Fintellix,

---

Can We Restore a Table that accidantly dropped.

8 Answers   TCS,

---