Alter tablespace end backup
722837Nov 20 2009 — edited Nov 23 2009Hey guys,
Just a small query:
I have a 9i database whose hot backup is taken every day, now when one of the tbspc is in backup mode,my server crashes (Windows)...and when the server is put up again, my db is in mount stage (as the tbspz is still in backup mode)...now when i query v$backup, it shows me that the file belonging to that tbsps is in ACTIVE mode, so ideally what I do is Id o "alter tbspz name end backup", which takes my tbsps out of backup mode and changes my datafile status to NOT ACTIVE...this is somethng i know and have seen....but I also came to know that when db is in mount and the file status is ACTIVE and i do "recover datafile no;"...it recovers my file and changes my datafile status to NOT ACTIVE...any idea as to why and how this happens??
Regards,
Ajinkya