DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: How to apply archive log files to cold backup?

  1. #1
    Join Date
    Mar 2007
    Posts
    21

    How to apply archive log files to cold backup?

    Hi All,

    My database operates in ARCHIVELOG mode. I took Cold backup (datafiles, control files and redo log files) at Monday night. On Tuesday, My system had media failure, I lost all files but all archive log files from last cold backup still remain.
    How can I recover database until time of failure from Cold backup and archive log files?
    How to apply archive log files to cold backup?

    Thanks in advance,
    Sinh

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    1 - restore backup
    2 - recover database

  3. #3
    Join Date
    Mar 2007
    Posts
    21
    May you give me more deatails checklist to do it, please?

    Thanks,

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Please let me elaborate Dave's process which is just fine.

    1.0 Restore Cold Backup

    2.0 Recover Database
    2.1 sqlplus /nolog
    2.2 conn sys as sysdba
    2.3 startup mount
    2.4 recover database using backup controlfile until cancel;
    2.5 Apply your logs
    2.6 CANCEL
    2.7 alter database open resetlogs;
    2.8 shutdown
    2.9 startup
    2.10 Send a Thank you note to Dave
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    HTML Code:
    ^^^
    2.10 Send a Thank you note to Dave
    Small things like this makes this forum lively :-).
    Rgds
    Parag

  6. #6
    Join Date
    Oct 2006
    Posts
    175
    And a bigger thank you note to PAVB to have been so elaborate.

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