Database Startup Problem .- Offline backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Database Startup Problem .- Offline backup

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    environment - oracle 8.1.7
    os - windows NT
    database mode - Noarchivelog mode

    i was testing backup and recovery so i had a setup in one machine made. so i took a offline backup of all the datafiles, logfiles, redologs ,control files.

    I deleted one tablespace with including contnets option.

    Then i went to the OS level and deleted the datafile.

    Then restored the whole offline backup in order to get the database in sync.

    when i started the database i got this error message.

    ORA-00338: log 1 of thread 1 is more recent than controlfile
    ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\ORACLE\REDO03.LOG'

    Advise. what is to be done.

    Thanks in advance
    Pravin
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Did you restore all backup files including redo logs and control files. It seems that you didn't restore redo log files.

    Sanjay

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I think you are using the wrong control file. Did you restore the right control file?


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