Facing problem: ORA-011033: ORACLE initialization or
shutdown in progress
SQL> connect sys/manager as sysdba
Connected.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145750508 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'C:\ORADATA\PRODUCT_DAT1.DBF'
shutdown immediate; -- if you have trouble with that, run shutdown abort;
startup mount;
alter database datafile 6 offline;
alter database open;
Further if u get this problem:
While making a datafile offline, got below error.
SQL> ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline;
ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline
*
ERROR at line 1:
ORA-01145: offline immediate disallowed unless media recovery enabled
SQL> connect sys/manager as sysdba
Connected.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145750508 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'C:\ORADATA\PRODUCT_DAT1.DBF'
Solution 1:
shutdown immediate; -- if you have trouble with that, run shutdown abort;
startup mount;
alter database datafile 6 offline;
alter database open;
Further if u get this problem:
While making a datafile offline, got below error.
SQL> ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline;
ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline
*
ERROR at line 1:
ORA-01145: offline immediate disallowed unless media recovery enabled
Solution 2:
To make a datafile offline, archive mode need to be enabled.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oracle/app/oracle/product/12.1.0.2/dbhome_1/dbs/arch
Oldest online log sequence 84
Current log sequence 85
Below are steps for enabling archive mode:
shutdown immediate;
startup mount
alter database archivelog;
alter database open;
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/app/oracle/product/12.1.0.2/dbhome_1/dbs/arch
Oldest online log sequence 84
Next log sequence to archive 85
Current log sequence 85
SQL>
Now try to make the datafile offline.
SQL> ALTER database datafile '/export/home/oracle/user02.dbf' offline;
Database altered.