Answer / ankur aggarwal

shutdown the database
copy the existing control file by using copy command of OS.
paste it another location where you want to create it.
define the path in init.ora file ("control file" Parameter)
startup database.

Answer / azhar ali khan

1)Check number of controlfiles.
SQL>select name from v$controlfile.
Suppose there are two controlfiles,control01.ctl and control02.ctl.Check the path of controlfiles.
SQL>Shut immediate.
Go to the controfile location.
$ls
control01.ctl control02.ctl
$cp control01.ctl control03.ctl
$ls
control01.ctl control02.ctl control03.ctl

Now open parameter file init<sid>.ora .
$vi init<sid>.ora
control_files='/home/..../control01.ctl','/home/.../control02.ctl','/home/...../control03.ctl'

save and quit
SQL>startup
SQL>Now check the name and path of controfiles.

How to implement the multiple control files for an existing database ?

2 Answers  

---

What is hit ratio ?

13 Answers   Indiabulls, RGPV,

---

Can a Tablespace hold objects from different Schemes in Oracle?

0 Answers  

---

Can a View based on another View in Oracle?

0 Answers  

---

What is meant by redo log buffer ?

3 Answers  

---

What is a Rollback segment entry ?

3 Answers   TCS,

---

What is Cursor?

2 Answers   Virtusa,

---

How the log writer writes the data into database

4 Answers   Baidu, Satyam,

---

How can you find the size of a database?

5 Answers   Baidu, HCL,

---

What is advantage of having disk shadowing/ Mirroring ?

1 Answers  

---

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 Answers  

---

What is an Oracle SYSTEM tablespace and when is it Created?

0 Answers  

---