-
ORA-01122: problem
Dears,
I am new to oracle,
i tried to move oracle from server to server
I did cold backup and after the restore i tried to startup the oracle i have the following:
############################
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 237899760 bytes
Fixed Size 69616 bytes
Variable Size 79478784 bytes
Database Buffers 157286400 bytes
Redo Buffers 1064960 bytes
Database mounted.
ORA-01122: database file 20 failed verification check
ORA-01110: data file 20:
'/oracle8/OW/sun/8.1.6/server/database/datafiles/OW03/systemOW03_1.dbf '
ORA-01207: file is more recent than controlfile - old controlfile
SQL> Disconnected
Database "OW03" warm started
#############################
i checked teh size for teh file i found it on old and new server is 0
How can i solve this problem
please if you advise
Regards
-
The backup was not sufficiently cold :-)
Do
Shutdown immediate
wait the system to get down, then make sure you copy all the data files, control file and redo logs and pfile where appropriate, and you should start