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

Answers were Sorted based on User's Feedback



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

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.

Is This Answer Correct ?    4 Yes 0 No

How to implement the multiple control files for an existing 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.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Architecture Interview Questions

When will be a segment released?

1 Answers  


When Does DBWR write to the database?

6 Answers  


What is the role of PCTFREE parameter is Storage clause ?

2 Answers  


How will you force database to use particular rollback segment?

1 Answers  


What are functions of PMON?

5 Answers  






How will you monitor the space allocation ?

3 Answers  


THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 Answers  


1.Explain the three levels with the help og a diagram.

1 Answers   Baidu,


what is the role of archiever

4 Answers   Baidu, Satyam, TCS,


How will you swap objects into a different table space for an existing database?

2 Answers  


What is a Multi-threaded Server Configuration?

1 Answers  


What is meant by free extent ?

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)