Re: Minimizing backup induced downtime

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 12 Jul 2007 08:46:14 -0700
Message-ID: <1184255173.859218@bubbleator.drizzle.com>

Alexander Skwar wrote:

> Let me explain how I currently do a backup.
>
> 1) Shut down application, which uses Oracle as a backend

Not necessary with RMAN

> 2) Shut down Oracle

Not necessary with RMAN

> 3) Create filesystem snapshots with ZFS on Solaris 10

Not necessary with RMAN

> 4) Start backup to tape of filesystem snapshots. When done, remove snapshots

Not necessary with RMAN

> 5) Startup Oracle

Not necessary with RMAN

> 6) Startup application

Not necessary with RMAN

Absolutely paleolithic. Read Oracle's wonderful RMAN documents at http://tahiti.oracle.com.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Jul 12 2007 - 10:46:14 CDT