Home » RDBMS Server » Backup & Recovery » Control file &Media failure
Control file &Media failure [message #199750] Thu, 26 October 2006 02:11 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
In a scenatrio,where i lost control file due to media failure.What will be the impact on DB .Will oracle server bring down the DB automatically ?Where the future writes on the control file go during shutdonw ?
Re: Control file &Media failure [message #199753 is a reply to message #199750] Thu, 26 October 2006 02:15 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Due to media failure ur database goes down.
and ur must be valid control file bkp ( if you have) or you need to create New Control file to mount ur database. and open.

missing or corrupted of control file database will not be able to "mount". Control file must be available for mount stage in database.

hope this helps.
Re: Control file &Media failure [message #199755 is a reply to message #199750] Thu, 26 October 2006 02:20 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Suppose,i have a backup control file taken 1 days back(after that there is not physical change in database) ,will i be able to use that Control file after restore it
Re: Control file &Media failure [message #199757 is a reply to message #199755] Thu, 26 October 2006 02:26 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

May be Yes or No.

if Yes when no change made in ur database.

or No. If changes made in database.


Depand on ur media failure how many control file affected due to media failure if one of more.

You all file must ( controlfile or datafile ) be sync for open ur database.

[Updated on: Thu, 26 October 2006 02:28]

Report message to a moderator

Re: Control file &Media failure [message #199771 is a reply to message #199750] Thu, 26 October 2006 03:14 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Suppose i am using old control file,and ther was no there was no change in phy structure of database ....how that works ?

Control file will hav currect SCN no:, Current online redo info etc...so how can a old control file be in sync .
Thanks for your quick response .
Re: Control file &Media failure [message #199779 is a reply to message #199771] Thu, 26 October 2006 03:27 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Create New control file with current database structure.
Previous Topic: Oracle Backup Wizard
Next Topic: Recovery scenario-Please help
Goto Forum:
  


Current Time: Fri Dec 09 11:41:47 CST 2016

Total time taken to generate the page: 0.09417 seconds