backup and recovery topic

[NDT]

Hi guys,
Do we have to backup the control file when we perform:

alter system archive log all

I personally don't think this would change the structure of the database so I don't think we have to do a backup of the control file. What do you think guys??
thanks

[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.

[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.

[NDT]

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

[NDT]

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??

[ocpwannabe]

Originally posted by NDT
But still it didn't change the structural of the database therefore i don't think we need to backup of the control file.
[/B]

agreed. like u say, using this logic you would have to backup the cf everytime a logswitch happened. this is unnecessary, imho.

[D Maverick]

Guys,

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.)

Thanks

The Maverick