Re: problems with shutdown immediate

From: Tim Kearsley <tim.kearsley_at_milton-keynes.gov.uk>
Date: 9 May 2003 02:14:37 -0700
Message-ID: <725736ef.0305090114.248b5de4@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 Received on Fri May 09 2003 - 04:14:37 CDT