• Article Type: General
• Product: Aleph

Description:
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

libcat
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

Resolution:
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 11.1.0.7.0 - 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 <---------------------------
<etc.>

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

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

idle>
Database altered.

idle> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 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