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 find the SGA Size

7 Answers   Baidu, Reliance,

---

What is meant by redo log buffer ?

3 Answers  

---

What is meant by Redo Log file mirrorring ? How it can be achieved?

1 Answers  

---

How can you find the size of a database?

5 Answers   Baidu, HCL,

---

What is meant by free extent ?

2 Answers  

---

What Does DBWR do?

2 Answers   Honeywell,

---

What is the function of checkpoint(CKPT)?

4 Answers  

---

What is User Process?

1 Answers  

---

• What is oracle Architecture?

3 Answers  

---

What are disadvanteges of having raw devices ?

1 Answers  

---

What is a Multi-threaded Server Configuration?

1 Answers  

---

How will you create multiple rollback segments in a database ?

1 Answers  

---