Hot backup can be done only when running in archive mode"
- 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