2011-09-30 12:48 PM - edited 2015-12-18 12:43 AM
2011-10-01 03:30 AM
You have two options
1) Crash consistent. Comment out APP_NAME and just have SC take snapshot while DB is running. Since we dont do anything with DB backup is crash consistent.
2) Offline backup. Shutdown DB and snapshot volumes while its offline. You would also disable plugin so dont set or comment out APP_NAME. You can automate startup and shutdown of DB by providing script or sql commands.
APP_QUIESCE_CMD01=sqlplus / as sysdba;shutdown immediate;exit
APP_UNQUIESCE_CMD01=sqlplus / as sysdba;startup mount;alter database open;exit
I would probably create script for startup / shutdown and run it from SC in order to do some error checking but this should give you idea. This is just example.
For databases that are not in archive log mode there simply is no way to consistently back them up online
Hope this help
2012-01-10 12:34 PM
I've created a "small" client plugin in perl that will shutdown oracle (quiesce) and startup oracle (unquiesce). I'm using it for some istances we have. I've uploaded it here: https://communities.netapp.com/docs/DOC-14134
If you want to give it a try let me know how it works.