Recover the database !Urgent
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Recover the database !Urgent

  1. #1
    Join Date
    Mar 2002
    Posts
    6
    How to recover the database? The server got crashed. But we are able to recover the data files, control files and the archive files. Now we have to recover the database with all the transactions happened till the time the server got crashed. Suggest please. It's urgent!!!

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Is your database in archivelog mode. If yes, then apply these commands.


    startup nomount


    recover database database using backup controlfile until cancel

    alter database open

    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Mar 2002
    Posts
    6
    Hi,
    Thanks.

    our database has crashed. We have the logical backup of our database as on yesterday. We don't have the back up of today's transactions. We have the Archive file. We want to retrive the today's transaction datas from the archive file.
    How to retrive the data from archive file???

    Arun

  4. #4
    Join Date
    Mar 2002
    Posts
    6
    Hi Kishore,
    Our server has got crashed. Now we have installed the NT server and all that. We have physical copy of the datafiles, control files and archive files. The database was in archive mode only. We have yesterday's logical backup. Withthat we have started recovering the database in another system. The process is going on. But this recovery won't give the transactions what ever we have entered today. Is it possible to recover it. Please explain in detail.

    Thanks and regards,
    Arun.

    Originally posted by Kishore
    Is your database in archivelog mode. If yes, then apply these commands.


    startup nomount


    recover database database using backup controlfile until cancel

    alter database open


  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What was the crash error you see in the alert_SID.log? Do you have the physical backup of the datafiles and archive files?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Mar 2002
    Posts
    6
    Originally posted by sambavan
    What was the crash error you see in the alert_SID.log? Do you have the physical backup of the datafiles and archive files?

    Sam
    We don't have the physical backup of the datafiles and archive files. But we have the physical copy of those files which we have copied from the server now.

    Arun.

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    When you say physical copy from the server, were they from the server that crashed? Before you proceed, what are the error messages on the alert.log

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Mar 2002
    Posts
    6
    We are not checked that. But we have the physical copy of the data files, control files and archive files.

    Now we want to move the database to new server.
    we have created the database, user and tablespace.

    How to recover the database from old datafile and control files????


    Arun



    Originally posted by sambavan
    When you say physical copy from the server, were they from the server that crashed? Before you proceed, what are the error messages on the alert.log

    Sam

  9. #9
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    When you said, physical files copy. Is it a OS copy ? that means, you took backup on OS level and now want to move to new place. In that case, you cannot rollforward to the position of crash. You may be able to recover till the backup position.

    Please clarify on what you did.
    Thanks
    Kishore Kumar

  10. #10
    Join Date
    Mar 2002
    Posts
    6
    We have the logical backup as on yesterday 22.00.
    and we have all the physical (OS) data files, control files and archive files.

    we imported the data from export backup. So as of now we have the data upto yesterday 22.00.
    How to recover the data entered after yesterday 22.00 to today 16.00 (System Crash time).
    We have the archive files from yesterday 18.30.

    Arun.


    Originally posted by Kishore
    When you said, physical files copy. Is it a OS copy ? that means, you took backup on OS level and now want to move to new place. In that case, you cannot rollforward to the position of crash. You may be able to recover till the backup position.

    Please clarify on what you did.

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