ASM snapshots and ACFS
654688Sep 16 2009 — edited Oct 21 2011I've been playing with 11gr2, asm and ACFS.. I saw the new snapshot technology and I thought wahooo.... I've worked with netapp in my previous job, and I loved the snapshot technology. I was thinking this would be the same..
You would put your files on a "cooked" file system, put your database in backup, snap, then take out of backup.. backup your snap.. Run into an issue , and you "snap back".. even better for dataguard.. You shutdown your Physicaly standby, snap the volume.. make your standby read write.. do you testing, then snap back and put back in recover.. easy as pie.
I have a number of questions after looking at ACFS.
1) There is no snapback ?? do I have this right ? you can create and delete, but you can't snap back?
2) Oracle ACFS does not support any file that can be directly stored in Oracle ASM. This is right out of the manual.. If you look up "any file that can be stored in oracle ASM" you find datafiles, controlfiles. archive logs, datapump files. This means that oracle will not the support using ACFS for your database files that you would most likely want to snap?
3) What do people see as the use of snapshots if you can't use them for database files, or are people going to put database files onto ACFS volumes regardless of the above statement ?
Personally I would love to put my archive logs, and datapump files on a "cooked" filesystem.. Database files are fine on ASM. This statement worries me too
"Create Oracle Database data files directly on Oracle ASM storage for best performance because Oracle ACFS does not support directIO for file read and write operations in 11g Release 2 (11.2)."