Originally posted by Raminder It will cause a log switch to occur.
Since oracle records the log switch in control file, it does change the control file.
A backup of control file will be in order.
But still it didn't change the structural of the database therefore i don't think we need to backup of the control file.
If what you're saying is true then is that mean we have to backup the control file everytime Oracle does a log switch??
Please correct me if I'm wrong. Thanks
Originally posted by ocpwannabe depends on what you mean by "have". if u dont backup the controlfile and the structure of the db didnt change, you can recover through all your archived redo logs with another backup controlfile.
I think I should use the word "should" instead of "have" !! Agree??
Can i perform a complete recovery when a tablespace is accidentally drop? or i have to perform an incomplete recovery using backup control file to restore the tablespace? (since the existing control file does not contain information on the tablespace that was droped.)