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

 Shutdown the databaseCopy one of the existing control file to new locationEdit Config ora file by adding new control file. nameRestart the database.
  • Interview Candidate
  • 1
  • 1623

Showing Answers 1 - 1 of 1 Answers

nitanjandial

  • Jan 30th, 2007
 

+Before to insert new control files,we should verify the existing control files location+these are the ways to find it=======================================================1.show parameter control_files2.select value from v$parameter where name='control_files'=======================================================+Both the above query return the name n location of the existing control fileif our oracle server supports spfile parameter file then follows the following steps================================alter system set control_files='name1_n_location_of_controlfiles','name2_n_location_of_controlfiles' scope=spfile;================================create the existing controlfile copy in new location what u have mentioned the value in parameter name of control_files through OS copy commandOnce u done above steps then bounce the database.TO verify ur change is applicable,just run the below statement again===========================1.show parameter control_files2.select value from v$parameter where name='control_files'===========================I hope the output of these statement should come what u give ur value in controlfile parameter nameIf u have any issue pls let me knowthanks n regardsNitan Jandial

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions