resetlogs时没有重新备份,现在数据库打不开了

ALLSTARS_ORACLE

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/data/ora9/oradata/ora9i/system01.dbf'

各位大虾,有没有方法打开啊?

SQL> startup mount
ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
SQL> recover database until time
ORA-00285: TIME not given as a string constant


SQL> recover database until time '2005-04-29:16:30:12'
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/data/ora9/oradata/ora9i/system01.dbf'


SQL> select * from dual;

ADDR           INDX    INST_ID D
-------- ---------- ---------- -
0A7A4138          0          1 X

SQL> recover database until time '2005-04-29:16:20:30'
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/data/ora9/oradata/ora9i/system01.dbf'


SQL> recover database until time '2005-04-29:12:17:57'
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/data/ora9/oradata/ora9i/system01.dbf'


SQL> recover database until time '2005-04-29:12:17:57'
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/data/ora9/oradata/ora9i/system01.dbf'


SQL> recover database until cancel
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/data/ora9/oradata/ora9i/system01.dbf'


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/data/ora9/oradata/ora9i/system01.dbf'


SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/data/ora9/oradata/ora9i/system01.dbf'


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/data/ora9/oradata/ora9i/system01.dbf'


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery


SQL> recover database
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/data/ora9/oradata/ora9i/system01.dbf'


SQL> alter database open
  2  ;
alter database open
*
ERROR at line 1:
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/data/ora9/oradata/ora9i/system01.dbf'
使用道具 举报

是这样的,数据库在出错前已经被我用alter database open reselogs恢复过一次,但恢复之后我忘了重新备份

然后我再做下一次实验时,把resetlog前的备份复制过去,然后再打开,就出现上面的现象了


不会吧,难道要重装?