额,测试服务器已经按1楼的方法起来了,生产的反而起不来,纠结SQL> startup mount ORACLE instance started.Total System Global Area 5161005056 bytes Fixed Size 2237328 bytes Variable Size 2348813424 bytes Database Buffers 2785017856 bytes Redo Buffers 24936448 bytes Database mounted. SQL> alter database open 2 ; alter database open * ERROR at line 1: ORA-01113: file 1 needs media recovery ORA-01110: data file 1: '/opt/oracle/oradata/odscidb/system01.dbf'
select name from v$datafile;
alter database datafile '' offline drop;
alter database open;
ORACLE instance started.Total System Global Area 5161005056 bytes
Fixed Size 2237328 bytes
Variable Size 2348813424 bytes
Database Buffers 2785017856 bytes
Redo Buffers 24936448 bytes
Database mounted.
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/opt/oracle/oradata/odscidb/system01.dbf'