Re: SMON process et al are not letting go of datafiles when I place them offline

When a database is opened, all datafiles defined in the instance's controlfile are opened, regardless if the datafile is online, offline, corrupt, whatever. To make your datafile backup, why not just shut the instance down which would then close the datafiles?

Matt Heiman wrote:

> I have been running into a problem lately. For one reason or another
> (possibly to make a datafile backup so that I can later rename the datafile
> name in oracle), I wish to place a tablespace offline and do something to
> the datafiles but I get an access error. On my openvms system, I will check
> to see who still has access to the datafiles and I will notice that most of
> the time SMON (sometimes another standard oracle process) still has the
> datafile open for access. I was under the impression that placing a
> tablespace offline would cause the oracle processes to relinquish control
> over the datafiles. Am I not correct in assuming this and if I am not
> correct, why would these processes still want or need access to the
> datafile. Is there a better way bring the tablespace offline so that I can
> get access to the datafiles?
>
> Matt Heiman
> boo_at_deltanet.com
Received on Sat Jun 13 1998 - 00:00:00 CDT