[Info-vax] backups and compaction or nocompaction might be better

[pcoviello at gmail.com]

On Tuesday, January 29, 2013 10:47:14 AM UTC-5, Stephen Hoffman wrote:
> On 2013-01-29 15:28:54 +0000, pcoviello at gmail.com said:
> 
> 
> 
> > that was what I was afraid of and unfortunately I can not un-encrypt 
> 
> > the databases :-(
> 
> 
> 
> Copying a live database is likely futile, in any case.  Databases 
> 
> aren't fond of that, given there's no coordination with BACKUP.  
> 
> Copying an encypted database created by the database-specific 
> 
> (lowercase-backup) backup tool is usually entirely feasible, but that 
> 
> archiving processing is probably best performed with just a generic 
> 
> BACKUP command and without resorting to compression or compaction or 
> 
> encryption.
> 
> 
> 
> If the operation is a file-based BACKUP and you're intending to archive 
> 
> the whole disk and particularly the application-related and ancillary 
> 
> files, I'd be seriously tempted to omit the database files and related 
> 
> baggage from that BACKUP, and storing that stuff in a different saveset 
> 
> on the tape, or on a different tape.
> 
> 
> 
> 
> 
> -- 
> 
> Pure Personal Opinion | HoffmanLabs LLC

ok first what is endless september?


as far as databases we do a freeze of the application and while the dbs are acquiesced we do a copy to a clone and backup the whole cloned disk.  so we get all files including the cache.dat files.