Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

Can I backup a SAP database with a SQL or Oracle agent?

Created: 16 Jul 2012 • Updated: 01 Mar 2013 • 1 comment
pkh's picture
0 0 Votes
Login to vote

Yes and no.

Increasing this question is being asked because the SAP agent is discontinued in BE 2012. Since SAP is based on either SQL Server or Oracle, can I back up the SAP database using the SQL or Oracle agent?

Yes, if your SAP database comprises one SQL or Oracle database, then you can backup the database using the appropriate agent.

No, if your SAP database comprises more than one SQL or Oracle databases.  Although you can backup the individual databases using the database agent, you might end up with a logically inconsistent database when you restore them.

Suppose your SAP database comprises database DB1, DB2 and DB3.  There might be a transaction TransA which updates DB1, DB2 and DB3.  When you use the SAP agent, it is aware of the entire transaction.  When it backs up the SAP database, it will make sure that the updates to DB1, DB2 and DB3 are backed up together.  When you do a restore using the SAP agent, it will restore all the updates to the various databases, so you have a logically consistent database.

If you use either a SQL or Oracle agent to backup the individual databases, these agent are not aware of the transaction spanning the three databases.  Each database is backed up as if it is a stand-alone database.  Due to the timing of the database backups, you might have a backup of DB1 and DB2 with the updates from TransA and the backup of DB3 might not have the update from TransA. When you restore the databases from the backups, then TranA will be incomplete and the SAP database will be logically inconsistent.

 

The above argument also applies to Sharepoint farms which comprise more than 1 SQL database.  For these farm, you would need the Sharepoint agent to back up the farm.  Using the SQL agent to backup the individual databases may also result in an inconsistent Sharepoint farm after a restore.

 

Comments 1 CommentJump to latest comment

Morgs's picture

Thanks I saw this.. Is there an installguide to load the racle agent ..perhaps

+3
Login to vote