cannot shutdown - file 1 has online backup set?
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>