Urgent!! DB Recovery problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Urgent!! DB Recovery problem

  1. #1
    Join Date
    Mar 2001
    Posts
    286
    I am in the progress to clone a database from host A to host B. I copied all hot-backuped datafiles, backed-up controlfiles, init.ora, password file and recent archived log files to host B.

    From my past experience, as long as I restore all the files to the same loacation as at host A, I should be able to mount and open the database. (This is on Solaris8 Oracle816.)

    Now, after mount, I tried to "alter datbase open resetlogs;", it
    said:

    file 1 needs media recovery

    Then I applied ALL archived log from host A. Then, it still ask for more archived logs. But there is no more archive logs to apply! I am not able to open the database.

    Why?

  2. #2
    Join Date
    Mar 2001
    Posts
    286
    .

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Did you recover with backup controlfile? If so, you just have to cancel your recover once all the logs have been applied. See http://metalink.oracle.com/metalink/...T&p_id=69468.1 for details.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Did you clone when the Host A database is running. O.K. After applying all the archive logs. Simply open the Database. It should open. As you might have used to create the database using backup control file. It does not know the last archive log file it created. So open the database it should open.

    Thanks
    Kishore Kumar

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Query from V$LOG to find out the log sequence number which was not archived, and submit the redo log file when Oracle asks for during the recovery.

    Then open the database with resetlog.

  6. #6
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Opps!! I forgot about that. You should apply the Log which is not archived before openining.

    Thanks for correcting me Tamil.
    Thanks
    Kishore Kumar

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