Re: RMAN and filesystem backups
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: ftilly@xxxxxxxxxxxxxx
- Date: Fri, 6 Nov 2009 08:24:51 -0300
Fred,
I am working on backup improvement project for a very big company and we
have this kind of backup in many sites. It beats the hell out of 'BEGIN/END
backup' and provides an actual real backup (which export does not) plus it
is rather easy to move to a tape subsystem (i.e. TDPO, NBU, etc)
However, consider that it requires about twice the space of the database
just to keep one online backup. (could be more, could be less, but in
average it's the same space as the DB). It requires careful synchronization
of the tape backup and RMAN backup, since if you start taking the tape
backup before RMAN is finished you will most likely end up with an invalid
backup and worst of all you won't know about it. If you implement this kind
of backup, I'd suggest monthly recovery tests (i.e. get a clean server and
perform a full recovery and any PiT recovery you might need).
As usual, if you can afford the integration agent for oracle (mml) it's
far better than any alternative.
hth
Alan Bort
Oracle Certified Professional
On Thu, Nov 5, 2009 at 3:55 PM, Fred Tilly <ftilly@xxxxxxxxxxxxxx> wrote:
> All,
>
> Has anyone set up an environment where they run RMAN (hot) backups to
> disk and then move the backups to tape using a standard filesystem
> backup, then remove the older backups from disk.
>
> Does anyone see any problems with doing this ?
>
> Thanks
>
> Fred
>
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
