john.mcconnell_at_jhmi.edu wrote:
> Hello,
> We're implementing SAP on IBM AIX V5.3 with Oracle 9i and we have
> several databases that are almost 1 TB in size. Currently we do the
> backup by:
> 1) put db in backup mode
> 2) flash (IBM shark) from the source disk to a target disk
> 3) take db out of backup mode
> 4) mount target disk
> 5) use "save" command to back up to Legato
> 6) unmount target disk
> So, every day I'm doing a full backup of my database. This is getting
> (and will get worse) very time consuming. (We've not implemented
> production yet and it's already 1TB!)
>
> How do other people handle backups of databases that are this large?
> I've heard there are products that do incremental backups--would that
> work with the "flash" scenario I've mentioned? Is Legato the way to
> go? Is there something better?
>
> Sorry if these are stupid questions... I'm an AIX admin...
>
> Thank you
>
You could consider RMAN with incremental nightly on-line backups and one
full weekend backup. I think you will not need to do SAN snapshot in
this case.
Received on Thu Aug 04 2005 - 13:33:34 CDT
