但如上环境被我搞了一通。
我重建了控制文件
建了时候在DATAFILE 列表中把 丢失的数据库去掉了,结果:
RECOVER DATABASE USING BACKUP CONTROLFILE;
ALTER DATABASE OPEN; 报错如下:
QL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/9.2.0/oraInventory/oradata/szpms/system01.dbf'
当数据现场是是如下情况:
我重建了控制文件
建了时候在DATAFILE 列表中把 丢失的数据库去掉了,结果:
RECOVER DATABASE USING BACKUP CONTROLFILE;
ALTER DATABASE OPEN; 报错如下:
QL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/9.2.0/oraInventory/oradata/szpms/system01.dbf'