Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

Backup Solution for Large OLTP SAP and Oracle DB's in VBLOCK environment

Created: 03 Jan 2012 | 6 comments
Srikanth Gubbala's picture
0 0 Votes
Login to vote

HI ALL..

i am looking for better solution to backup Large OLTP SAP and Oracle DB's in VBLOCK environment.. please share the best practises.

 

regards,

Srikanth.

Comments

Stuart Green's picture
03
Jan
2012
0 Votes 0
Login to vote

Whats your current solution -

Whats your current solution - if you have one?

Tip: Get overview/document your NBU environment. Run 'nbsu' and review the output.

• If this provides help, please vote or mark appropriate solution.

Marianne van den Berg's picture
03
Jan
2012
0 Votes 0
Login to vote

"i am looking for better

"i am looking for better solution..."

Better than what?

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links

Srikanth Gubbala's picture
04
Jan
2012
0 Votes 0
Login to vote

Current is standalone SAP

Current is standalone SAP servers with BCV backups on dedicated server and move them to tape via SAN.. now our idea is move these servers to VM on a Vblock. so looking out for different solutions we can implement.

regards, Srikanth.

Yasuhisa Ishikawa's picture
04
Jan
2012
0 Votes 0
Login to vote

Tell us more detail of your plan

Please tell us more detail of your plan like below.
* DB size
* DB residence(on vmdk, on RDM disks, on NFS, on iSCSI, ...)
* Type and version of OS
* Current transfer rate

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

Srikanth Gubbala's picture
04
Jan
2012
0 Votes 0
Login to vote

multiple DB's are there, may

multiple DB's are there, may vary from 2-4 TB

DB's are on Linux VM- VMDK

dont have exact version and transfer rate

regards, Srikanth.

Stuart Green's picture
04
Jan
2012
0 Votes 0
Login to vote

Your options are: Install

Your options are:

  1. Install the NBU Client inside the VM and the SAP Agent and backup to a media server over the network. 
  2. Alternatively, configure brtools for brbackup and brarchive to write out to a NFS share mounted on the SAP Central Instance piping the output through gzip. The NFS export is actually on a SAN media server. Now back this up as a file system backup using NBU on that SAN Media Server. This Media Server could be your master. We do this with some SAP instances and get 1TB database down to 175GB gzipped. You obviously need the space to store these and restore, but effective and can be quick to backup. You could backup once a week and take redo logs for the rest of the week. Its down to your business as to the time to restore etc.
  3. Perform a VMware Snapshot of the entire VMDK that the SAP DB is on. But the snapshot will not be application DB aware. You could write some pre-freeze-script to place the DB tablespaces in BACKUP mode. Now if your backup software has deduplication turned on you could get some good rates for storing and reduce the backup times down.
  4. Also think about how this might figure into your SAP landscape refreshes, as designing/choosing a good backup solution might help cut down refresh times on your DEV and QAS systems. 

Their might be other 'rolled' solutions available, just some food for thought.

Tip: Get overview/document your NBU environment. Run 'nbsu' and review the output.

• If this provides help, please vote or mark appropriate solution.