Re: Hotbackup

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 17 Apr 2002 00:41:33 -0700
Message-ID: <1e8276d6.0204162341.7ffeaafd@posting.google.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<ubnb9sl53pgbfb_at_corp.supernews.com>...
> Anyone, who already has RMAN (comes with Enterprise Edition), would waster
> their time by writing their own conventional backup scripts.

We're now testing a new backup system using maybe unconventional method. The advantage is nearly no time between begin and end backup. We're using O8i EE and the steps are:

1) Issuing begin backup to all tablespaces.
2) Disconnecting array mirror. (time < 1 minute)
3) End backup to all tablespaces.
4) Log switching, archiving current group as usual.
5) Moving new archived logs (only one) to disconnected mirror drives.
6) After ten hours of waiting for tabe, perform backup on disconnected

mirror drives.
7) Reconnecting mirror.

The purpose of this system was not to minimise begin ... end backup time, but no free backup device in time frame, when we need to do this backup. While using this method we can postpone backups to early morning when some tape device is available. The only problem is reconnecting of mirror, because that gives some IO to our disks. However, because array is distributing only changed blocks across the drives and through the night there is a lower activity, it looks like everything will works fine.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.

Received on Wed Apr 17 2002 - 02:41:33 CDT