Home » RDBMS Server » Server Administration » pfile and control file query
icon5.gif  pfile and control file query [message #309962] Sun, 30 March 2008 13:39 Go to next message
oraclesavvy
Messages: 9
Registered: May 2007
Junior Member


Hello,

If database is running and suppose pfile and control file dropped accidentally then will database continue to run?

Please answer with explanation.
Re: pfile and control file query [message #309965 is a reply to message #309962] Sun, 30 March 2008 13:56 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
yes until oracle accesses control file on need.
Re: pfile and control file query [message #309966 is a reply to message #309962] Sun, 30 March 2008 13:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
A couple of seconds.

Regards
Michel
Re: pfile and control file query [message #310072 is a reply to message #309962] Mon, 31 March 2008 03:13 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

If pfile missing while operation then no effect on database. It continue it's own work. If controlfile missing while database operation within few seconds abnormally shut down the database.
Re: pfile and control file query [message #310085 is a reply to message #309962] Mon, 31 March 2008 03:59 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Does oracle access control file all the time?

If oracle is idle ie no activity is going on,then also oracle will shutdown?
Re: pfile and control file query [message #310090 is a reply to message #310085] Mon, 31 March 2008 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Oracle is never idle. It always does many things in background.
Yes, control file is often accessed.

Regards
Michel
Re: pfile and control file query [message #310094 is a reply to message #309962] Mon, 31 March 2008 05:00 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Yes, control file is often accessed.


So until it is accessed, the database would run as normal.
Re: pfile and control file query [message #310104 is a reply to message #310094] Mon, 31 March 2008 05:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes.

Until you realize you have no more ground under your feet you can continue to walk. Smile

Regards
Michel
Re: pfile and control file query [message #310112 is a reply to message #310104] Mon, 31 March 2008 05:36 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:

Quote:

Yes, control file is often accessed.


So until it is accessed, the database would run as normal.



Which is also true for the data files, the program binaries, etc..., I presume. When they are gone the database would run as normal until they are accessed. Grin
Re: pfile and control file query [message #310238 is a reply to message #309962] Mon, 31 March 2008 12:20 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:
Which is also true for the data files, the program binaries, etc..., I presume. When they are gone the database would run as normal until they are accessed


but the information of datafiles/binaries are fetched from control files itself.

So its all control files that control the behaviour of database.
Re: pfile and control file query [message #310240 is a reply to message #310238] Mon, 31 March 2008 12:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Data are fetched from/written to datafiles and not control file.

Regards
Michel
Re: pfile and control file query [message #310241 is a reply to message #309962] Mon, 31 March 2008 12:30 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
but wouldn't at the same time data dictionaries are also updated and these dictionaries fetch data about datafiles from control files.



Re: pfile and control file query [message #310244 is a reply to message #310241] Mon, 31 March 2008 12:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No, nothing is fetched from control file during database normal session.
Dictionary is not in control file, it is in data files (SYSTEM tablespace).

Regards
Michel
Re: pfile and control file query [message #310315 is a reply to message #309962] Mon, 31 March 2008 22:45 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
Which is also true for the data files


Quote:
When they are gone the database would run as normal until they are accessed


Even after being accessed database will run as normal except the objects in the datafiles itself.
Previous Topic: After an patch, collect new statistisc?
Next Topic: how to delete tablespace "TEMP" data file normally?
Goto Forum:
  


Current Time: Thu Dec 12 08:30:32 CST 2024