-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|