2 Replies Latest reply: Mar 1, 2011 7:16 AM by 842767 RSS

    cannot shutdown - file 1 has online backup set?

    CLUTCH DBA
      Yesterday, I had a request to restart a production database at 4:30 PM.

      I issued "shutdown immediate" and got the error "cannot shutdown - file 1 has online backup set".

      So ran a "shutdown abort" and then a "alter database end backup;".

      I have 2 questions.

      1. Why can't I shutdown with an online backup set?

      2. Did I handle this situation correctly. If not, what is the correct action.

      thanks,

      Oracle Newbie



      C:\scheduled batches>sqlplus "/ as sysdba"

      SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 20 16:34:41 2010

      Copyright (c) 1982, 2007, Oracle. All rights reserved.


      Connected to:
      Oracle Database 11g Release 11.1.0.6.0 - Production


      SQL> shutdown immediate;
      ORA-01149: cannot shutdown - file 1 has online backup set
      ORA-01110: data file 1: 'C:\ORACLE\ORADATA\MWFPROD\SYSTEM01.DBF'
      SQL> shutdown immediate;
      ORA-01149: cannot shutdown - file 1 has online backup set
      ORA-01110: data file 1: 'C:\ORACLE\ORADATA\MWFPROD\SYSTEM01.DBF'
      SQL> shutdown immediate;
      ORA-01149: cannot shutdown - file 1 has online backup set
      ORA-01110: data file 1: 'C:\ORACLE\ORADATA\MWFPROD\SYSTEM01.DBF'
      SQL> shutdown abort;
      ORACLE instance shut down.
      SQL> startup;
      ORACLE instance started.

      Total System Global Area 535662592 bytes
      Fixed Size 1334380 bytes
      Variable Size 356516756 bytes
      Database Buffers 171966464 bytes
      Redo Buffers 5844992 bytes
      Database mounted.
      ORA-10873: file 1 needs end backup before opening a database
      ORA-01110: data file 1: 'C:\ORACLE\ORADATA\MWFPROD\SYSTEM01.DBF'


      SQL> startup;
      ORA-01081: cannot start already-running ORACLE - shut it down first
      SQL> shutdown immediate;
      ORA-01109: database not open


      Database dismounted.
      ORACLE instance shut down.
      SQL> startup;
      ORACLE instance started.

      Total System Global Area 535662592 bytes
      Fixed Size 1334380 bytes
      Variable Size 356516756 bytes
      Database Buffers 171966464 bytes
      Redo Buffers 5844992 bytes
      Database mounted.
      ORA-10873: file 1 needs end backup before opening a database
      ORA-01110: data file 1: 'C:\ORACLE\ORADATA\MWFPROD\SYSTEM01.DBF'


      SQL> alter database end backup;

      Database altered.

      SQL> stutdown immediate;
      SP2-0734: unknown command beginning "stutdown i..." - rest of line ignored.
      SQL> shutdown immediate;
      ORA-01109: database not open


      Database dismounted.
      ORACLE instance shut down.
      SQL> startup;
      ORACLE instance started.

      Total System Global Area 535662592 bytes
      Fixed Size 1334380 bytes
      Variable Size 356516756 bytes
      Database Buffers 171966464 bytes
      Redo Buffers 5844992 bytes
      Database mounted.
      Database opened.
      SQL>