tag:blogger.com,1999:blog-9087887235134509416.post2014398443831381022..comments2023-10-01T17:59:11.566+02:00Comments on OraClever: ACFS: NOT for Database Files!Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-9087887235134509416.post-68658485096390674792014-05-10T02:53:09.007+02:002014-05-10T02:53:09.007+02:00I read about that too. that's controversial or...I read about that too. that's controversial or could it be Oracle realised if there's nothing great about ACFS that it will not gain popularity thus in newer version they starting to certify more DB files there. <br /><br />But the question back, Oracle going to support or not? Also I run into patching issues using Opatch auto. Apparently it requires a share directory that can be seen by all nodes. We could use ACFS for this purpose.<br />Haanshttps://www.blogger.com/profile/09061914108576935545noreply@blogger.comtag:blogger.com,1999:blog-9087887235134509416.post-70146654241242422912012-11-15T15:52:25.228+01:002012-11-15T15:52:25.228+01:00Hi!
But:
Starting with Oracle Automatic Storage M...Hi!<br />But:<br /><br />Starting with Oracle Automatic Storage Management 11g Release 2 (11.2.0.3), Oracle ACFS supports RMAN backups (BACKUPSET file type), archive logs (ARCHIVELOG file type), and Data Pump dumpsets (DUMPSET file type). Note that Oracle ACFS snapshots are not supported with these files.<br /><br />http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmfilesystem.htm<br /><br /><br /><br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9087887235134509416.post-34742031579504550832010-11-25T03:12:19.426+01:002010-11-25T03:12:19.426+01:00[oracle@node1 ~]$ sqlplus "/ as sysdba"
...[oracle@node1 ~]$ sqlplus "/ as sysdba"<br /><br />SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 25 10:08:16 2010<br /><br />Copyright (c) 1982, 2010, Oracle. All rights reserved.<br /><br /><br />Connected to:<br />Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production<br />With the Partitioning, Real Application Clusters, Automatic Storage Management and Real Application Testing options<br /><br />SQL> archive log list; <br />Database log mode Archive Mode<br />Automatic archival Enabled<br />Archive destination /u01/app/acfsmounts/data_vltest<br />Oldest online log sequence 31<br />Next log sequence to archive 33<br />Current log sequence 33<br />SQL> select name from v$datafile;<br /><br />NAME<br />--------------------------------------------------------------------------------<br />+DATA/rac11g/datafile/system.261.735955787<br />+DATA/rac11g/datafile/sysaux.262.735955793<br />+DATA/rac11g/datafile/undotbs1.263.735955797<br />+DATA/rac11g/datafile/undotbs2.265.735955803<br />+DATA/rac11g/datafile/users.266.735955807<br />/u01/app/acfsmounts/data_vltest/demo01.dbf<br /><br />6 rows selected.<br /><br />SQL> !mount<br />/dev/mapper/VolGroup00-LogVol00 on / type ext3 (rw)<br />proc on /proc type proc (rw)<br />sysfs on /sys type sysfs (rw)<br />devpts on /dev/pts type devpts (rw,gid=5,mode=620)<br />/dev/sda1 on /boot type ext3 (rw)<br />tmpfs on /dev/shm type tmpfs (rw)<br />none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)<br />sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)<br />oracleasmfs on /dev/oracleasm type oracleasmfs (rw)<br />/dev/hda on /media/cdrom type iso9660 (ro)<br />/dev/asm/vltest-51 on /u01/app/acfsmounts/data_vltest type acfs (rw)yw.zhouhttp://oracleworld.spaces.live.com/noreply@blogger.comtag:blogger.com,1999:blog-9087887235134509416.post-69128141776303912912010-02-01T22:04:32.197+01:002010-02-01T22:04:32.197+01:00Thanks for stopping by, Gerwin!
Similar with me. I...Thanks for stopping by, Gerwin!<br />Similar with me. I actually was quite surprised to see this documented(!) limitation. On the other hand, one might consider it quite reasonable, seeing how ASM has been positioned.Arnoud Rothhttps://www.blogger.com/profile/03608371398611583649noreply@blogger.comtag:blogger.com,1999:blog-9087887235134509416.post-6457369464625560552010-02-01T13:12:22.353+01:002010-02-01T13:12:22.353+01:00Thanks for the update on this. At first when I hea...Thanks for the update on this. At first when I heard about ACFS, I didn't think of the fact that this is not intended to store datafiles. I expected the file system like GPFS, CFS, etc.<br /><br />Regards, GerwinGerwin Hendriksenhttps://www.blogger.com/profile/04506843235395647116noreply@blogger.com