Home > Ask the SAP software/management Experts > Upgrade/migration and Basis administration expert Questions & Answers > How to create a snapshot from NAS and SAN of Oracle database
Ask The SAP Expert: Questions & Answers
EMAIL THIS

How to create a snapshot from NAS and SAN of Oracle database

Bert Vanstechelman EXPERT RESPONSE FROM: Bert Vanstechelman

Pose a Question
Other SAP Categories
Meet all SAP Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 15 January 2009
I have SAP with Oracle running on Solaris with a Java front end. My data resides on both NAS (NFS) and a SAN on the same storage array.

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?


>
The most important technical component in a SAP environment is always the database. If all fails, and you succeed in restoring your database, all other SAP components can be reconstructed in a worst-case scenario with a re-install of the SAP instances.

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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Upgrade/migration and Basis administration expert
How to establish communication between SAP Unicode and non-Unicode systems
How to install an add-on using a SAINT transaction in SAP Basis
Converting from MDMP to Unicode
SAP FI/CO consultant's role during upgrade from R/3 to ECC 6.0
How to move SAP NetWeaver Enterprise Portal between servers
Alternatives to downloading a trial version of SAP IDES ERP software
Verifying data consistency in production SAP FI/CO system when restoring a backup
How to upgrade DB2 on SAP R/3 4.7
How to clone an SAP ECC 6.0 instance
Can we get SAP ECC 6.0 support with an Oracle database?

SAP Basis administration and NetWeaver administration
Collaboration a must for SAP hardware teams and software teams
How to establish communication between SAP Unicode and non-Unicode systems
Mission-critical SAP software demands a mission-critical hardware infrastructure
In an upgrade to SAP ECC 6.0, when do integrated apps get upgraded?
NetWeaver PI 7.1 easier to implement than earlier versions, SAP says
SAP Software Deployment Manager vs. Java Support Package Manager
Tips for setting up a default SAP BI client after implementation
How to reset the SAP transport buffer after abnormal patch termination
Installing SAP NetWeaver PI 7.1 on servers running ECC 6.0
How to install an add-on using a SAINT transaction in SAP Basis
SAP Basis administration and NetWeaver administration Research

SAP Basis administration tips
Converting from MDMP to Unicode
Can SAP developer include authority check for S_TCODE in a called transaction?
How to fix Smart Forms printing double purchase orders
Deriving the name of a Smart Style from a Smart Form
SAP FI/CO consultant's role during upgrade from R/3 to ECC 6.0
Alternatives to downloading a trial version of SAP IDES ERP software
Verifying data consistency in production SAP FI/CO system when restoring a backup
How to upgrade DB2 on SAP R/3 4.7
How to clone an SAP ECC 6.0 instance
How to manually add files to an SAP transport queue

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
Basis  (SearchSAP.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



SAP White Paper Topics
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2000 - 2009, TechTarget | Read our Privacy Policy
SearchSAP.com is a search service provided by TechTarget and is completely
independent of and not affiliated with SAP AG.
  TechTarget - The IT Media ROI Experts