Which two types of files can be stored In an ASM clustered file system?
A.
OCR and Voting Disk files
B.
data files for external tables
C.
Oracle database executable
D.
Grid Infrastructure executables
E.
data files for tablespaces
F.
archive log files
Explanation:
Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a
multi-platform, scalable file system, and storage management technology that extends Oracle
Automatic Storage Management (Oracle ASM) functionality to support customer files maintained
outside of Oracle Database. Oracle ACFS supports many database and application files, including
executables, database trace files, database alert logs, application reports, BFILEs, and
configuration files. Other supported files are video, audio, text, images, engineering drawings, and
other general-purpose application file data.
Notes:
Not supported means Oracle Support Services does not take calls and development does not fix
bugs associated with storing unsupported file types in Oracle ACFS.
A is wrong. ACFS does not support voting and OCR
B is right. ACFS supports external table files
C is right. ACFS supports DB home
D is wrong. ACFS does not support GI home
E is wrong. ACFS not preferred for DB data files
F is wrong. starting 11.2.0.3 ACFS supports backup sets and archive logs.
So B.C. are correct
Why F wrong?
“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.”
(link from oracle documentation: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmfilesystem.htm#OSTMG94163)
Also E wrong if question will be “can be stored and supported”