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

Report message to a moderator

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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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.

Report message to a moderator

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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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: 286
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

Report message to a moderator

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

Report message to a moderator

Previous Topic: Bash file in Linux
Next Topic: pct free and pct used ????
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 04 05:54:58 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.