ТЕМА:

SYSTEM01.DBF на _SYSTEM01.DBF, и остановил БД.
Патом востановление файла, создался такой же, 9ГБ.
Проблема не ушла.
RMAN> restore datafile 1;

Starting restore at 16.12.11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\PRODUCT\10G\ORADATA\BASE\SYSTEM01.DBF
channel ORA_DISK_1: restored backup piece 1
piece handle=D:\1\FULL2.BAK tag=TAG20111213T170012
channel ORA_DISK_1: restore complete
Finished restore at 16.12.11

RMAN> alter database open RESETLOGS;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 12/16/2011 13:53:05
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10G\ORADATA\BASE\SYSTEM01.DBF'

RMAN>

Нужна помощь Гуру

Или в тех. поддержу

Ты уж определись кто тебе нужен.

А вообще документацию читать нужно.

ORA-01152: file string was not restored from a sufficiently old backup
Cause: An incomplete recovery session was started, but an insufficient number of
logs were applied to make the database consistent. This file is still in the future of
the last log applied. The most likely cause of this error is forgetting to restore the
file from a backup before doing incomplete recovery.
Action: Either apply more logs until the database is consistent or restore the
database file from an older backup and repeat recovery.


Сделай RECOVER DATABASE.