| Control file &Media failure [message #199750] |
Thu, 26 October 2006 02:11  |
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 #199755 is a reply to message #199750] |
Thu, 26 October 2006 02:20  |
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 |
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 |
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 .
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
