ORA-01122: problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01122: problem

  1. #1
    Join Date
    Feb 2007
    Posts
    1

    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

  2. #2
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    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
  •  



Click Here to Expand Forum to Full Width