Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Backup Package: hot backup doesn't flush online redo log to archive

    Backup Package: hot backup doesn't flush online redo log to archive

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    We've discovered a problem with the current Ex Libris Backup Package that has to do with recovery from hot backups.

    As written, the hot backup routine does not flush the online redo log to archive upon completion. As a result, upon recovery, the 'recover database' command will expect the online redo log to be available. This is not guaranteed in all recovery scenarios.

    We've made a change so that at the completion of the backup, 'alter system archive log current' is executed. This flushes the online redo log to an archived redo log, which will be backed up along with rman backup data files by normal system backup utilities. Recovery can then use 'restore database until sequence n' and 'recover database until sequence n', where n is the last archived sequence (after the backup
    completed) and no online redo logs will be needed.

    If online redo logs are available, 'restore database' and 'recover database' without the until clause will work fine.

    [Note: for more information and/or to discuss this further, please contact Cory Snavely <csnavely@umich.edu> ] [ <Jonathan Rothman > ]
    [ <Alan Manifold > ]
    [ <Jerry Specht > ]
    [ <Jerry Specht > ]
    [ <Jerry Specht > ]

    Resolution:
    [From Ex Libris:] We think this is a nice addition to the backup package and hope to include it in the next release.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Backup Package: exec_backup_main: Too many arguments; 'nknown option'
      • Backup Package: any backup of Oracle database fails with error message ORA-27040: file create error
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved