C:\documents and settings\administrator>sqlplus /nolog sql> connect system/password as sysdba connected. sql> shutdown normal ora-01109: Database not open has uninstalled the database. The oracle routine has been closed. Sql> startup mount oracle routine has started. total system global area 612368384 bytes fixed size 1250428 bytes variable size 348130180 bytes database buffers 255852544 bytes redo buffers &nbSp; 7135232 bytes Database loading complete. Sql> alter database open 2 ; alter database open * section 1 line error: ORA-01157: Unable to identify/lock data file 6-see DBWR trace file
ORA-01110: Data file 6: ' F:\ORACLE1 '
The database has been unloaded.
The ORACLE routine has been closed.
sql>; startup
sp2-0042: Unknown command "; startup"-The remaining lines are ignored.
Sql> Startup
The ORACLE routine has started.
Total System Global area 373293056 bytes
Fixed Size 1249056 bytes
Variable Size 92274912 bytes
Database buffers 272629760 bytes
Redo buffers 7139328 bytes
Database loading complete.
ORA-01157: Unable to identify/lock data file 6-see DBWR trace file
ORA-01110: Data file 6: ' F:\ORACLE1 '
sql> ALTER DATABASE datafile offline drop;
ALTER DATABASE datafile offline drop
*
Line 1th Error:
ORA-01516: Nonexistent log file, data file or temporary file "19"
Sql> ALTER DATABASE datafile 6 offline drop
2;
The database has changed.
sql> shutdown Normal
ORA-01109: Database not open
The database has been unloaded.
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has started.
Total System Global area 373293056 bytes
Fixed Size 1249056 bytes
Variable Size 92274912 bytes
Database buffers 272629760 bytes
Redo buffers 7139328 bytes
Database loading complete.
ORA-01157: Unable to identify/lock data file 7-see DBWR trace file
ORA-01110: Data file 7: ' F:\ORACLE2 '
sql> ALTER DATABASE datafile 7 offline drop
2;
The database has changed.
sql> shutdown Normal
ORA-01109: Database not open
The database has been unloaded.
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has started.
Total System Global area 373293056 bytes
Fixed Size 1249056 bytes
Variable Size 92274912 bytes
Database buffers 272629760 bytes
Redo buffers 7139328 bytes
Database loading complete.
ORA-01157: Unable to identify/lock data file 8-see DBWR trace file
ORA-01110: Data file 8: ' F:\ORACLE3 '
sql> ALTER DATABASE datafile 8 offline drop
2;
The database has changed.
sql> shutdown Normal
ORA-01109: Database not open
The database has been unloaded.
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has started.
Total System Global area 373293056 bytes
Fixed Size 1249056 bytes
Variable Size 92274912 bytes
Database buffers 272629760 bytes
Redo buffers 7139328 bytes
Database loading complete.
ORA-01157: Unable to identify/Lock data file 9-see DBWR trace file
ORA-01110: Data file 9: ' F:\ORACLE4 '
sql> ALTER DATABASE datafile 9 offline drop;
The database has changed.
sql> shutdown Normal
ORA-01109: Database not open
The database has been unloaded.
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has started.
Total System Global area 373293056 bytes
Fixed size 1249056 bytes
Variable size 92274912 bytes
Database buffers 272629760 bytes
Redo buffers 7139328 bytes
Database mount complete. The
database is already open.
Sql>