Subscribe
Accepted Solution

Oracle DB not in Archive Log Mode

[ Edited ]

    We have oracle databases that are not configured for Archive Log Mode.  How do we get SnapCreator to take snapshots of these databases?  The out file is  attached.

Oracle DB not in Archive Log Mode

Hello

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

Keith

Re: Oracle DB not in Archive Log Mode

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.

Francesco