SQL> alter database recover until cancel using backup controlfile;
alter database recover until cancel using backup controlfile
*
ERROR 位于第 1 行:
ORA-00279: 更改 4149519 (在 07/03/2003 12:05:03 生成) 对于线程 1 是必需的
ORA-00289: 建议: C:\ORACLE\ORADATA\ARCHIVE\ARC00079.001
ORA-00280: 更改 4149519 对于线程 1 是按序列 # 79 进行的


SQL> alter database recover until cancel using backup controlfile;
alter database recover until cancel using backup controlfile
*
ERROR 位于第 1 行:
ORA-01153: 激活了不兼容的介质恢复

recover database using backup controlfile  until cancel  ?

有归档吗？

有，肯定有

o

datafile：datafile，control file一个礼拜前的备份
archive：到昨天为止的
想恢复到前天
放入各自目录
startup mount;
alter database recover until cancel using backup controlfile;
报错,
从第二次alter database recover until cancel using backup controlfile; 都报ORA-01153: 激活了不兼容的介质恢复

然后shutdown abort;startup mount还是一样

不要如你所使用的恢复

SQL> startup mount
ORACLE instance started.

Total System Global Area   42833948 bytes
Fixed Size                    75804 bytes
Variable Size               9125888 bytes
Database Buffers           33554432 bytes
Redo Buffers                  77824 bytes
Database mounted.
SQL> alter database recover until cancel using backup controlfile;
alter database recover until cancel using backup controlfile
*
ERROR at line 1:
ORA-00279: change 41195150 generated at 07/10/2003 13:20:11 needed for thread 1
ORA-00289: suggestion : E:\ORACLE\ORADATA\BILLY\ARCHIVE\BILLYT001S01393.ARC
ORA-00280: change 41195150 for thread 1 is in sequence #1393


SQL> recover database  using backup controlfile  until cancel;
ORA-00275: media recovery has already been started


SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.



SQL> startup mount
ORACLE instance started.

Total System Global Area   42833948 bytes
Fixed Size                    75804 bytes
Variable Size               9125888 bytes
Database Buffers           33554432 bytes
Redo Buffers                  77824 bytes
Database mounted.
SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
         1          1       1393    1048576          1 NO  CURRENT               41194919 08-JUL-03
         2          1       1391    1048576          1 YES INACTIVE              41194795 08-JUL-03
         3          1       1392    1048576          1 YES INACTIVE              41194823 08-JUL-03

SQL> select * from v$logfile;

    GROUP# STATUS
---------- -------
MEMBER
----------------------------------------------------------------------------------------------------
         1
E:\ORACLE\ORADATA\BILLY\REDO01.LOG

         3
E:\ORACLE\ORADATA\BILLY\REDO03.LOG

         2
E:\ORACLE\ORADATA\BILLY\REDO02.LOG


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 41195150 generated at 07/10/2003 13:20:11 needed for thread 1
ORA-00289: suggestion : E:\ORACLE\ORADATA\BILLY\ARCHIVE\BILLYT001S01393.ARC
ORA-00280: change 41195150 for thread 1 is in sequence #1393


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
'E:\ORACLE\ORADATA\BILLY\REDO01.LOG'
Log applied.
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL>  alter database open resetlogs;

Database altered.

SQL>

ORA-01153 an incompatible media recovery is active

Cause: Attempt to start an incompatible media recovery or open resetlogs during media recovery. Media recovery sessions are incompatible if they attempt to recover the same datafile. Incomplete media recovery or open resetlogs is incompatible with any media recovery.

Action: Complete or cancel the other media recovery session.

等会再试一下