I made a full, consistent database backup with the following procedure:
Later I made a restore procedure of the backup with the
But after that tha restore procedure finished when I gave the
alter database open comand
I received the following error:
ORA-01113 file 1 needs media recovery
ORA-01110 data file 1 : 'D:\ORACLE\ORADATA\ZIR\SYSTEM01.DBF'
that is exactlly the system tablespace.
When I gave the
command the problem was solved, but I don't understand why do I have to start media recovery for a consistent backup.
The database is 220.127.116.11.0 Enterprise Edition, on Windows 2000 Professional and it operates in NOARCHIVELOG.