Re: [Veritas-bu] open files to be backed up

Subject:

From:

Ed Wilts <ewilts AT ewilts DOT org>

To:

"veritas-bu AT mailman.eng.auburn DOT edu" <VERITAS-BU AT mailman.eng.auburn DOT edu>

Date:

Mon, 22 Mar 2010 10:55:00 -0500

On Mon, Mar 22, 2010 at 10:45 AM, Dustin Damour <dustind AT plateautel DOT com> wrote:

I think the technical terms for this is Cold Backup which requires the database to be stopped before backup. Hot Backup is when there is an agent or some other software that doesn’t shut down the database, and instead takes a snapshot in a point of time while data can be written still after snapshot.

The key concepts here are crash-consistent or transactionally-consistent.

If you attempt to use a snapshot approach, you'll get a crash-consistent copy. Transactions could be in the middle of being applied and it's possible you'll get half a transaction on disk/tape. This will not make for a clean recovery. Transactionally-consistent database backups are done either through the of host agents, database-specific tools, or shutting down the database.

You need to focus the questions on what you want your recovery to look like. Don't focus on the BACKUPS - focus on the RECOVERIES. If you have no plans to recover, don't bother backing it up in the first place.

Ed Wilts, RHCE, BCFP, BCSD, SCSP, SCSE
ewilts AT ewilts DOT org

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

<Prev in Thread]

Current Thread

[Next in Thread>

Previous by Date:

Re: [Veritas-bu] open files to be backed up, Dustin Damour

Next by Date:

Re: [Veritas-bu] LTO-5 tape, what will it be called in NBU? hcart2?, WEAVER, Simon (external)

Previous by Thread:

Re: [Veritas-bu] open files to be backed up, Dustin Damour

Next by Thread:

Re: [Veritas-bu] open files to be backed up, judy_hinchcliffe

Indexes:

[Date] [Thread] [Top] [All Lists]