how to apply the online redo log files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: how to apply the online redo log files

  1. #1
    Join Date
    Mar 2001
    Posts
    29
    hi guys,
    lets say, i got the backup controlfiles, datafiles, all archived logs up to the time of failure and the lastest online redo logs. I can't bring up the instance again to archive the online redo logs. so, how do i recover the database including the transactions in the online redo files?

    thxthx

  2. #2
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    well..for a start online redo log will be automatically used for recovery when u start the instance.
    ngwh,
    Singapore.

  3. #3
    Join Date
    Mar 2001
    Posts
    29
    in my case, the instance is going to startup by a backup copy which requires to roll forward till the point of failure. is that means i just need to put the online redo log and alter database open once the roll forward process is done?

    thxthx
    dino

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    1. Restore the datafiles.
    2. Startup Mount.
    3. Recover database untill cancel.
    4. It will ask you for the archived redo log files.
    5. Enter the location of the archived redo files.
    6. the entries from the online redo log files will be applied too if available.
    7. If its complete recovery you can open your database, otherwise in case of incomplete recovery you will have to use resetlogs option.

    (I assume that you have a copy of current control file)

    Sanjay

  5. #5
    Join Date
    Mar 2001
    Posts
    29
    here is what i have... finally. just want to share and... correct me if i am wrong.

    case 1.
    - backup control file, backup dbf files, archives and the latest online redo log
    - recover database using backup controlfile until cancel
    - recover up to point of failure
    - need to apply the online redo log manually
    - incomplete recovery and need to open resetlogs

    case 2
    - backup control file, backup dbf files, archives and lost latest online redo log
    - recover database using backup controlfile until cancel
    - recover up to latest archive log
    - incomplete recovery and need to open resetlogs

    case 3
    - latest control file, backup dbf files, archives and lost latest online redo log
    - recover database until cancel
    - recover up to latest archive log
    - incomplete recovery and need to open resetlogs

    case 4
    - latest control file, backup dbf files, archives and the latest online redo log
    - recover database until cancel
    - recover up to point of failure
    - complete recovery and online redo logs will be applied automatically

    dino

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