Note on SAP DB Backup

A sample backup schedule might look like:
1. Hourly - brarchive backup of archive logs
2. Daily - brbackup backup of full database
3. Monthly - file system backup of /sapmnt/, including SAP executables and profile data, and /oracle/SID/_/dbs & network ---making sure you get Oracle/SAP init files and network files (tnsnames.ora, listener.ora,\nnames.ora, etc., though you might have relocated these files elsewhere), & /usr/sap/trans directory.
4. Quarterly - Oracle export performed to tape.

This schedule is good enough for a small system landscape with an orgnanization. If the landscape is huge, then you need to re-think about how backup is done. An integration with Oracle RMAN is good for running incremental backup. This will reduce the number of media needed for running daily full online backup - storage optimization.

No comments:

topics