tim.kearsley_at_milton-keynes.gov.uk (Tim Kearsley) wrote in message news:<725736ef.0305090114.248b5de4_at_posting.google.com>...
> yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0305081850.566657d0_at_posting.google.com>...
> > 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
>
> Hi,
>
> I think first of all you need to ask yourself (and answer hopefully!)
> WHY data files are in BACKUP mode. Has an online backup been aborted
> (presumably so)?
>
> Having satisfied yourself what the situation is and whether your data
> is secure, in order to shutdown you need to take the datafiles which
> are in backup mode out of backup mode. This is done at the tablespace
> level:
>
> ALTER <tablespace> END BACKUP;
>
> You can determine which datafiles belong to which tablespace from the
> DBA_DATA_FILES view.
>
> Once all datafiles are out of BACKUP mode you can shutdown the
> database.
>
> Regards,
>
> Tim Kearsley
> Database Manager
> Milton Keynes Council
thanks, guys.. why this happened, is because, my unix backup scripts
failed, causing the backups to fail. and i am still puzzled why the
datafiles are still in backup mode?
Received on Sat May 10 2003 - 03:27:29 CDT
