Shrikant Pande

• Aug 25th, 2005

 

1. Edit init.ora file set control_files parameter with multiple location 
2. shutdown immediate 
3. copy control file to multiple locations & confirm from init.ora contol_files parameter 
4. start the database. 
5. run this query for changes confirmation - select name from v$controlfile;

bijan Mohapatra

• Nov 5th, 2006

 

Edit itit.ora file after shutdown the data base, set path for another control file in the parameter setting. then copy the control file to the desired location where the path is setting, then start the database.