Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Hot backup can be done only when running in archive mode"

    • Article Type: General
    • Product: Aleph

    The hot backup script generates the following email:

    Subject: Backup error on : 26-11-2009 00:20:01 ora_hot

    Oracle DB: alephp
    Backup type: ora_hot
    Message Number: 08
    Hot backup can be done only when running in archive mode

    Linux libcat 2.6.18-128.1.1.el5 #1 SMP Mon Jan 26 13:58:24 EST 2009 x86_64 x86_64 x86_64 GNU/Linux

    It seems that the operation to correct the Insufficient privileges (KB 16384-21953) / the reboot of the server stopped archive logging for some reason. util o/7/3 showed:

    SQL*Plus: Release - Production on Thu Nov 26 18:34:25 2009

    Copyright (c) 1982, 2008, Oracle. All rights reserved.

    idle> Connected.
    idle> idle> Database log mode No Archive Mode <---------------------------
    Automatic archival Disabled <---------------------------

    so I turned it on (util o/7/1):

    idle> Database closed.
    Database dismounted.
    ORACLE instance shut down.
    Database mounted.
    Database altered.

    Database altered.

    idle> Disconnected from Oracle Database 11g Enterprise Edition Release - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    Restarting Aleph servers and Aleph Daemons.
    All done

    Note: the preceding util o/7/1 will *not* work if the site is Two-Task, with a separate database server.

    • Article last edited: 10/8/2013