Re: problems with shutdown immediate

yls177 wrote:
>
> when i did a shutdown immediate;
>
> i got the following
> ORA-01149: cannot shutdown - file 1 has online backup set
> ORA-01110: data file 1: '/oracle/SID/sapdata7/system_1/system.data1'
>
> afterwhich, i did
> select * from v$backup and that there are 109 ACTIVE backups to go.
>
> a shutdown abort will be disaster, right

Just run

v9,
alter database end backup;

v8,
you need to loop through each file name and issue alter database datafile '...' end backup  (or do the same for each tablespace)

then you can shutdown immediate

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"