Home » RDBMS Server » Server Administration » Regards Controlfiles
Regards Controlfiles [message #237026] Fri, 11 May 2007 12:00 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member

Hello sir


Already we have 2 controlfiles ,we want to add one more controfile in our database for saftey purpose ,i need ur valuable suggestion and advice because this i will do for our real time database server, i need help for manual method.


oracle version: 9.2.0.7.0
OS : REDHAT LINUX

-Thanx
Re: Regards Controlfiles [message #237031 is a reply to message #237026] Fri, 11 May 2007 12:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Bad idea for a real time db.
Are you sure 2 is not enough (of course on different disks)?

Regards
Michel
Re: Regards Controlfiles [message #237054 is a reply to message #237031] Fri, 11 May 2007 13:59 Go to previous messageGo to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
hello sir


yes ofcourse we have only 2 controlfiles thats why ,we want to add one more ,plz gimme the method to add the control files

Thanx.

Re: Regards Controlfiles [message #237058 is a reply to message #237054] Fri, 11 May 2007 14:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- shutdown the db
- copy one of the control files to another place
- add this new location to the control_files list in init.ora
- startup the db

Regards
Michel
Re: Regards Controlfiles [message #237059 is a reply to message #237054] Fri, 11 May 2007 14:15 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
take a look at this thread

But be carefull. I would first try it at some play-database
Re: Regards Controlfiles [message #237063 is a reply to message #237059] Fri, 11 May 2007 14:29 Go to previous message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member


Really thank u sir,i did everything looks fine
Previous Topic: Bash file in Linux
Next Topic: pct free and pct used ????
Goto Forum:
  


Current Time: Wed Dec 07 10:55:27 CST 2016

Total time taken to generate the page: 0.14743 seconds