b7dba
asked on
shutdown not possible
SQL> shutdown immediate
ORA-01149: cannot shutdown - file 1 has online backup set
ORA-01110: data file 1: '/u01/app/oracle/oradata/o rcl11/syst em01.dbf'
SQL>
ORA-01149: cannot shutdown - file 1 has online backup set
ORA-01110: data file 1: '/u01/app/oracle/oradata/o
SQL>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
Pls check the below scenairo and the solution....
SQL> alter tablespace system begin backup;
Tablespace altered.
SQL> shut immediate;
ORA-01149: cannot shutdown - file 1 has online backup set
ORA-01110: data file 1: '+DATA1/testdb/datafile/sy stem.347.7 78438247'
SQL> select * from V$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 ACTIVE 179059 22-MAR-12
2 NOT ACTIVE 0
3 NOT ACTIVE 0
4 NOT ACTIVE 0
SQL> select distinct ('alter tablespace ' || a.name || ' end backup ; ') "Tablespace in Backup mode" from V$tablespace a, V$datafile b , V$backup c where b.file# = c.file# and
b.ts# = a.ts# and c.status = 'ACTIVE';
Tablespace in Backup mode
-------------------------- ---------- ---------- ---------- ------
alter tablespace SYSTEM end backup ;
SQL> alter tablespace SYSTEM end backup ;
Tablespace altered.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
Pls check the below scenairo and the solution....
SQL> alter tablespace system begin backup;
Tablespace altered.
SQL> shut immediate;
ORA-01149: cannot shutdown - file 1 has online backup set
ORA-01110: data file 1: '+DATA1/testdb/datafile/sy
SQL> select * from V$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 ACTIVE 179059 22-MAR-12
2 NOT ACTIVE 0
3 NOT ACTIVE 0
4 NOT ACTIVE 0
SQL> select distinct ('alter tablespace ' || a.name || ' end backup ; ') "Tablespace in Backup mode" from V$tablespace a, V$datafile b , V$backup c where b.file# = c.file# and
b.ts# = a.ts# and c.status = 'ACTIVE';
Tablespace in Backup mode
--------------------------
alter tablespace SYSTEM end backup ;
SQL> alter tablespace SYSTEM end backup ;
Tablespace altered.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
manzoor_dba, please don't post duplicate information, the scenario which you have illustrated had already explained in simple words in my comment already,
fyi.. just refer
http:#a37746362
fyi.. just refer
http:#a37746362
http://ora-01149.ora-code.com/