I need to create a local consistent snapshot from both the NAS and SAN at the same time. Currently, I can do a consistent snapshot from the array, but it may not reflect any in-flight data that isn't flushed from the host or NAS head.
Is there a way to ensure a consistent snapshot with a script that would pause or quiesce the host?
In your setup, put the Oracle database in suspend mode. When done, all I/O is suspended.
As long as the database is in suspend mode, SAP is in reconnect mode. As such, both SAP and database are 'waiting' and nothing is written to the database and SAP application file systems.
At that point, split the mirrors in both NAS and SAN and start your backup on the mirrors. If you resume the database, all activities continue as if nothing happened in between.
In addition, if you disable file system buffering at the OS level, all I/Os are written to the disks at database commit time. File system buffering is no longer used. This guarantees consistent backups.
Consult your OS documentation on the disabling of file system buffering. For the suspend/resume feature, consult the Oracle documentation.
For more information on backup/recovery from SAP, see http://service.sap.com/atg --> backup/restore.
Dig Deeper on SAP Basis
Related Q&A from Bert Vanstechelman
An SAP user wants to know the risks of changing time zones in ECC 6.0. Continue Reading
An SAP user wants to know how to access an SAP IDES 4.7 system via the Internet through SAP GUI. Continue Reading
A SearchSAP.com reader wants to know how an increase of indexes and tables after upgrade to SAP ECC 6.0 will affect the memory requirements of a DB2 ... Continue Reading