[Veritas-bu] Backup using Storage Level Flash for DB (FC,BC,SI)
2012-06-20 21:37:33
Hi Jeff,
Thanks for sharing your experience on your enviornment.
I might need to clarify further, this method of backup does work but i guess it
varies from different environment setup.
>From your main reason that you stated, i've no doubt about what benefit it
>brings but i'm not convince this method applies to all DB backup in one
>enviornment. Imagine for one enviornment do not have a share SAN infra and
>each project had it dedicated SAN switch and SAN media server or SAN client to
>perform the backup for the DB servers. This is reason i feel from the backup
>team, the member needs to know all these different DB servers backup
>(something like network NAT), what is that particular SAN media or client is
>mounting the split mirror disk for its backup because the DBA will submit the
>restore request of the actual DB server.
The 2nd problem my enviornment face will be each project might purchase
differnet type of storage, IBM, EMC, HDS and the list goes on, the splitting
script which we deploy needs to be consistant, each time a new storage was
introduced, new script needs to be written and tested before release to
production. And to deploy such backup in my enviornment requires afew teams
effort to make the backup work as explain in my first post.
As for the single point of failure i describe is actually referring to backup
and not restore. The point is each project might only purchase 1 dedicated SAN
media or client to mount the mirror disk as they do not plan to buy redundancy
for this and they also feel its a waste of the SAN switch port as well. We had
a setup of 10 different DB server using 1 SAN client for it mirror LUN backup
as it comes from the same project and my concern is that if that SAN client
went down, all DB servers backup will be affected.
Running multiple stream, we are using bpstart notify script on the SAN client
to ssh into the DB server into put the DB into backup mode and split the mirror
before putting the DB into end backup mode prior to mounting up for backup. We
may need to use parent start notify to ensure we only run the DB script once
per backup job as the bpstart notify will trigger more than once depend how
many streams we set on the backup policy.
+----------------------------------------------------------------------
|This was sent by dy_lan018 AT yahoo DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
Previous by Date: |
Re: [Veritas-bu] Backup using Storage Level Flash for DB (FC, BC, SI), Lightner, Jeff |
Next by Date: |
[Veritas-bu] Out of office, Abhishek Dhingra1 |
Previous by Thread: |
Re: [Veritas-bu] Backup using Storage Level Flash for DB (FC, BC, SI), Lightner, Jeff |
Next by Thread: |
[Veritas-bu] Out of office, Abhishek Dhingra1 |
Indexes: |
[Date]
[Thread]
[Top]
[All Lists] |
|
|