Have your say: December 2015

Oracle ACFS is the preferred file manager for non-database files, which can be visualized as a layer on Oracle ASM and is configured with Oracle ASM storage. It is optimized for general purpose files.Oracle ACFS should not contain file types that can be directly stored in Oracle ASM. Doing that could violate oracle recommended best practices and even void support coverage.

Here are the basic commands list for ACFS.

root@oda1 /root #acfsutil -h

Usage: acfsutil [-h] command ... # (Version 12.1.0.2.0)

-h - help

Command Subcmd Arguments
--------------- --------- ------------------------------------------------------
help [command] - display this message
version - display ACFS version information
version -v - display in verbose format
info fs - Display all ACFS file systems
info fs [ ...] - Display specific ACFS file system
info fs -o - Display specific file system item:
info fs -o freespace, totalspace,
info fs -o mountpoints, volumes,
info fs -o available, ismountpoint,
info fs -o isavailable, iscorrupt,
info fs -o isadvm, diskgroup,
info fs -o redundancy, resizeincrement,
info fs -o stripewidth, stripecolumns,
info fs -o primaryvolume, replication,
info fs -o isreplprimary, isreplstandby,
info fs -o fetasize,
info fs -o autoresize, autoresizeincrement,
info fs -o autoresizemax
info fs [-s [-d] [ ...]]
info fs [-s [ []] [-d] ]
info fs Display ACFS file system statistics
info fs - [-s] Display ACFS file system statistics
info fs - [-d] Modify -s to display detailed
info fs statistical information
info fs [[-f [-v]] []] - Display ACFS file system fragmentation
info fs - [-f] Display ACFS file
info fs system fragmentation
info fs - [-v] Modify -f to display
info fs more information
info file [-d] [-o ] [ ...] -
info file Display specific file info
info file - [-d] Display ADVM extent information
info file - [-o ] Supply
info file an ACFS extent offset
info id -
info id Display the pathname associated with the given
info id ACFS file identifier and mountpoint.
tag set [-r] [-v] [ ...] - Set tag name
tag set on file
tag set - [-r] recursively traverse
tag set directories
tag set - [-v] verbose output
tag unset [-r] [-v] {all | } [ ...] - Unset
tag unset tag name on file. "all"
tag unset unsets all tag names on
tag unset the selected file
tag unset - [-r] recursively traverse
tag unset directories
tag unset - [-v] verbose output
tag info [-r] [[-c] -t ] [ ...] - Display file
tag info tag names
tag info - [-r] recursively traverse
tag info directories
tag info - [-c] modifies -t permitting
tag info case-insensitive partial
tag info tag name matching
tag info - [-t] search for tag name in
tag info path names
tag info [[-c] -t ] - Display file tag names for
tag info all file systems when no
tag info paths given
rmfs - Remove unmounted ACFS file system
rmfs [-b] - No user interaction (batch mode)
size [[-|+]nnn[K|M|G|T|P]] [-a nnn[K|M|G|T|P]] [-x nnn[K|M|G|T|P]] [-d ]
size - Resize file system and configure auto-resize
size [-a] - Auto-resize increment
size [-x] - Auto-resize maximum
size [-d] - Resize only this device
registry - Display, add, modify or delete ACFS Registry entries.
registry With no options, displays all file systems configured for
registry automatic start in a human-readable format.
registry [-l |-l |-l |-m |-r]
registry - Display registry information
registry -l - Display all file systems configured for automatic start
registry in line format
registry -l - Display a device in the ACFS Registry in line format
registry -l - Display a mount point in the ACFS Registry in line format
registry -m - Display a specific mount point associated with a device
registry -r - Display all registered file systems
registry -a [-f] [-o ] [-n ] [-u ] [-t ]
registry - Add a mount point to the registry
registry -c { | } [-o ] [-n ] [-u ] [-t ]
registry - Change a device or a mount point in the ACFS Registry
registry -d { | }
registry - Delete a device or a mount point from the ACFS Registry
log -f [filename] - Get memory log [default: oks.log]
log -s - Show log file size
log -r nnn[K|M|G|T|P] - Set log file size
log -p avd|ofs|oks - Product for setting or querying settings
log -l debuglevel - Set the in-memory debug level
log -n consolelevel - Set the persistent/console debug level
log -c debugcontext - Set the debug context
log -T file_type - Set the debug file type (ACFS only)
log -m - Set the debug file system
log -a - Reset debug logging to all file systems
log -q - Query debug settings for a product
log -C - Get log on all cluster nodes
tune AcfsMaxOpenFiles - Maximum number of open files
tune (Windows only)
snap create [-w|-r] [-p parent_snap_name]
snap create [-w] - create a writeable snapshot
snap create [-r] - create a read-only snapshot
snap create This is the default behavior
snap create [-p parent_snap_name] - create a snapshot from a snapshot
snap delete - delete a file system snapshot
snap convert -w|-r
snap convert -w - convert to a writeable snapshot
snap convert -r - convert to a read-only snapshot
snap info [-t] []
snap info - get information about snapshots
snap info [-t] - display family tree starting at next name given
snap info [] - snapshot name
snap info - mount point
repl init primary | standby - which site
repl init -p primary_connect_string - standby only, primary connect
repl init string
repl init -s standby_connect_string - primary only, standby connect
repl init string
repl init [tagname . . . ] - primary only, tags to be
repl init replicated
repl init [-m mountpoint] - primary only, optional standby
repl init mount point
repl init [-c service name] - optional service name for the
repl init local site
repl init [-d {0..6} ] - set trace level for debugging
repl init [-z {on|off}] - primary only, rlog compression
repl init mountpoint - mount point for replication
repl terminate primary | standby - which site
repl terminate [immediate] - standby only, terminate
repl terminate immediately
repl terminate mountpoint - mount point for replication
repl pause mountpoint - mount point to pause
repl pause replication on
repl resume mountpoint - mount point to
repl resume resume replication on
repl info
repl info info -c [-v] mountpoint - configuration information or
repl info info -s [-v][-l] [-n m|h|d|w|y]
repl info [-r [#]]
repl info {-f | } - statistics or
repl info info [-e|a|t] [-v][-l] [-r [#]]
repl info {-f | } - events
repl info -v - verbose output
repl info -l - display only last event
repl info -e - display only error events
repl info -a - display only apply events
repl info -t - display only transport events
repl info -n m|h|d|w|y - interval period to display info
repl info -r start_time#stop_time - yyyy-nn-ddThh:mm:ss
repl info yyyy - Year.
repl info nn - Month. (01..12)
repl info dd - Day. (01..31)
repl info hh - Hour. (00..23)
repl info mm - Minute. (00..59)
repl info ss - Second. (00..59)
repl info -f | - path to replication
repl info event log or
repl info replication mount point
repl sync [apply] - return when all is applied
repl sync mountpoint - mount point on primary
repl update -p primary_connect_string | -s standby_connect_string
repl update [-z {on|off}] - primary only, rlog compression
repl update mountpoint - mount point on primary
repl bg start | stop | info
repl bg mountpoint - replication mount point
repl trace - level (0..6)
repl trace mountpoint - replication mount point
repl compare [-a [-s] [-v]] | [-t {ALL | , ...} [-s] [-v]]
repl compare - Compares all directories and
repl compare files in the primary mount
repl compare point against those in the
repl compare standby mount point. Verifies
repl compare no extra files exist on the
repl compare standby.
repl compare -a - Enables tag name and extended
repl compare attribute name checking on the
repl compare default comparison method.
repl compare -t {ALL | , ...} - Search for files with
repl compare any of the specified tag names
repl compare in the primary mount point and
repl compare compare only these files
repl compare to the standby mount point.
repl compare Only tag names specified during
repl compare the acfsutil repl init
repl compare operation or "ALL" are
repl compare allowed. Also compares
repl compare these file''s tag and extended
repl compare attribute names.
repl compare All directories are compared
repl compare regardless of tags.
repl compare -s - Skips extended attribute and/or
repl compare tag name comparisons on
repl compare symlinks.
repl compare -v - Verbose output.
repl compare - Primary mount point for
repl compare replication.
repl compare - Standby mount point for
repl compare replication. The standby
repl compare mount point must be mounted
repl compare locally using a networked file
repl compare system on the primary node.
sec realm create -m
sec realm create -e {on -a {AES} -k {128|192|256} | off}
sec realm create [-o {enable|disable}]
sec realm create [-d ""]
sec realm create - Create a realm
sec realm create - realm to be created
sec realm create - [-m ] mount point
sec realm create - [-e ] encryption status
sec realm create - [-a {AES}] encryption algorithm
sec realm create - [-k {128|192|256}] encryption key length
sec realm create - [-o {enable|disable}] realm status,
sec realm create default realm status is enable
sec realm create - [-d ""] realm description
sec realm clone -s
sec realm clone {[][-d ]}
sec realm clone [-u][-G][-l][-e][-f]
sec realm clone - Clone a realm
sec realm clone - name of realm to be
sec realm clone cloned
sec realm clone - [-s ] source mount
sec realm clone point
sec realm clone - new realm name
sec realm clone - [-d ] destination
sec realm clone mount point
sec realm clone - [-u] copy users
sec realm clone - [-G] copy groups
sec realm clone - [-l] copy filters
sec realm clone - [-e] copy realm encryption parameters
sec realm clone - [-f] copy objects
sec realm destroy -m
sec realm destroy - Destroy a realm
sec realm destroy - realm to be destroyed
sec realm destroy - [-m ] mount point
sec realm add -m
sec realm add {[-u ,...][-G ,...]
sec realm add [-l ,...]
sec realm add [-e -a {AES} -k {128|192|256}]
sec realm add [-f [-r] [...]]}
sec realm add - Add objects to realm
sec realm add - realm name
sec realm add - [-m ] mount point
sec realm add - [-u ,...] add user(s)
sec realm add - [-G ,...] add group(s)
sec realm add - [-l :,...]
sec realm add add filter(s)
sec realm add - command rule
sec realm add - rule set name
sec realm add - [-e] turn on encryption
sec realm add - [-a {AES}] encryption algorithm
sec realm add - [-k {128|192|256}] encryption key length
sec realm add - [-f] add file object(s)
sec realm add - [-r] recursively add file object(s)
sec realm add - [...]
sec realm add file object name(s)
sec realm delete -m
sec realm delete {[-u ,...][-G ,...]
sec realm delete [-l ,...]
sec realm delete [-e][-f [-r] [...]]}
sec realm delete - Delete objects from realm
sec realm delete - realm name
sec realm delete - [-m ] mount point
sec realm delete - [-u ,...] delete user(s)
sec realm delete - [-G ,...] delete group(s)
sec realm delete - [-l :,...]
sec realm delete delete filter(s)
sec realm delete - command rule
sec realm delete - rule set name
sec realm delete - [-e] turn off encryption
sec realm delete - [-f] delete file object(s)
sec realm delete - [-r] recursively delete file object(s)
sec realm delete - [...]
sec realm delete file object name(s)
sec realm audit enable -m
sec realm audit enable [-l commandrule[,...,commandrule]]
sec realm audit enable [-a] [-v[-u]]
sec realm audit info -m -n
sec realm audit disable -m
sec realm audit disable [-l commandrule[,...,commandrule]]
sec realm audit disable [-a] [-v[-u]]
sec ruleset create -m
sec ruleset create [-o {ALL_TRUE|ANY_TRUE}]
sec ruleset create - Create a rule set
sec ruleset create - rule set name
sec ruleset create - [-m ] mount point
sec ruleset create - [-o {ALL_TRUE|ANY_TRUE}] rule set option
sec ruleset create ALL_TRUE = all rules evaluate
sec ruleset create to TRUE
sec ruleset create ANY_TRUE = any one rule evaluates
sec ruleset create to TRUE
sec ruleset create default rule set option is ALL_TRUE
sec ruleset clone -s
sec ruleset clone {[][-d ]}
sec ruleset clone - Clone a rule set
sec ruleset clone - name of rule set
sec ruleset clone to be cloned
sec ruleset clone - [-s ] source mount
sec ruleset clone point
sec ruleset clone - [] new rule set name
sec ruleset clone - [-d ] destination
sec ruleset clone mount point
sec ruleset destroy -m
sec ruleset destroy - Destroy a rule set
sec ruleset destroy - rule set name
sec ruleset destroy - [-m ] mount point
sec ruleset edit -m
sec ruleset edit {[-a ,...][-d ,...]
sec ruleset edit [-o {ALL_TRUE|ANY_TRUE}]}
sec ruleset edit - Update a rule set
sec ruleset edit - rule set name
sec ruleset edit - [-m ] mount point
sec ruleset edit - [-a ,...] add rule(s)
sec ruleset edit - [-d ,...] remove rule(s)
sec ruleset edit - [-o {ALL_TRUE|ANY_TRUE}] rule set option
sec ruleset edit ALL_TRUE = all rules evaluate
sec ruleset edit to TRUE
sec ruleset edit ANY_TRUE = any one rule evaluates
sec ruleset edit to TRUE
sec rule create -m
sec rule create -t [,]
sec rule create [-o {ALLOW|DENY}]
sec rule create - Create a rule
sec rule create - rule name
sec rule create - [-m ] mount point
sec rule create - [-t ] rule type can be
sec rule create username, time, hostname, or application
sec rule create - rule value
sec rule create - [-o {ALLOW|DENY}] rule option
sec rule create ALLOW = allow operation if rule
sec rule create evaluates to TRUE
sec rule create DENY = deny operation if rule
sec rule create evaluates to TRUE
sec rule create default rule option is DENY
sec rule clone -s
sec rule clone {[][-d ]}
sec rule clone - Clone a rule
sec rule clone - name of rule to be
sec rule clone cloned
sec rule clone - [-s ] source mount
sec rule clone point
sec rule clone - new rule name
sec rule clone - [-d ] destination
sec rule clone mount point
sec rule edit -m
sec rule edit {[-t [,]]
sec rule edit [-o {ALLOW|DENY}]}
sec rule edit - Edit a rule
sec rule edit - rule name
sec rule edit - [-m ] mount point
sec rule edit - [-t ] rule type can be
sec rule edit username, time, hostname, or application
sec rule edit - rule value
sec rule edit - [-o {ALLOW|DENY}] rule option
sec rule edit ALLOW = allow operation if rule
sec rule edit evaluates to TRUE
sec rule edit DENY = deny operation if rule
sec rule edit evaluates to TRUE
sec rule destroy -m
sec rule destroy - Destroy a rule
sec rule destroy - rule name
sec rule destroy - [-m ] mount point
sec info -m [-S ]
sec info [{[-n []] | [-l []] |
sec info [-s [
sec info - Display ACFS Security information
sec info - [-m ] mount point
sec info - [-S ] snapshot name
sec info - [-n] list all realms
sec info - [-n ] information about
sec info a realm
sec info - [-l] list all rules
sec info - [-l ] information about
sec info a rule
sec info - [-s] list all rule sets
sec info - [-s ] information about
sec info a rule set
sec info - [-c] list all command rules
sec info file -m
sec info file [-r] [...]
sec info file - List the realms that the specified file
sec info file or directory belongs to
sec info file - [-m ] mount point
sec info file - [-r] recursively print information
sec info file - file or directory
sec info file object name
sec batch
sec batch - Execute 'acfsutil sec' commands in batch
sec batch - batch file name
sec init -u -g
sec init - Initialize security
sec init - [-u ] First
sec init security administrator
sec init - [-g ] Security
sec init administrator group
sec admin add
sec admin add - Add new ACFS Security administrator
sec admin add - new security
sec admin add administrator name
sec admin remove
sec admin remove - Remove ACFS Security administrator
sec admin remove - Existing
sec admin remove security administrator name
sec admin password - Change security administrator password
sec admin password of current user
sec admin info - List all ACFS Security administrators
sec enable -m
sec enable [-S ][]
sec enable - Enable ACFS Security
sec enable - [-m ] mount point
sec enable - [-S ] snapshot name
sec enable - name of realm to enable
sec enable security feature on. When no realm name
sec enable is specified, security will be enabled
sec enable on the mount point.
sec disable -m
sec disable [-S ][]
sec disable - Disable ACFS Security
sec disable - [-m ] mount point
sec disable - [-S ] snapshot name
sec disable - name of realm on which to
sec disable disable security feature. When no realm
sec disable name is specified, security will be
sec disable disabled on all realms in the
sec disable mount point.
sec prepare -m [-u]
sec prepare - Prepare filesystem for ACFS Security
sec prepare feature
sec prepare - [-m ] mount point
sec prepare - [-u] undo ACFS Security prepare
sec save -m -p
sec save - Save ACFS Security meta data
sec save - [-m ] mount point
sec save - [-p ] file name for saving
sec save ACFS Security meta data
sec load -m -p
sec load - Load ACFS Security meta data
sec load - [-m ] mount point
sec load - [-p ] name of saved ACFS
sec load Security meta data file to be loaded
encr init [-p]
encr init - Create storage for encryption keys
encr init - [-p] create password-protected wallet,
encr init if not specified creates a
encr init non-password-protected wallet
encr set -m [{[-a {AES} -k {128|192|256}] | -u}]
encr set - Set volume encryption parameters
encr set - [-m ] mount point
encr set - [-a {AES}] encryption algorithm
encr set - [-k {128|192|256}] encryption key length
encr set default key length is 192
encr set - [-u] undo ACFS Encryption set
encr set - [-e] store keys in external keystore
encr rekey -m [-a {AES} -k {128|192|256}]
encr rekey {-v | -f [-r] [...]}
encr rekey - Generate a new encryption key
encr rekey - [-m ] mount point
encr rekey - [-a {AES}] encryption algorithm
encr rekey - [-k {128|192|256}] encryption key length
encr rekey default algorithm and key length are
encr rekey parameters set on volume
encr rekey - [-v] generate Volume Encryption Key
encr rekey - [-f] generate File Encryption Key
encr rekey - [-r] recursively rekey
encr rekey - path name
encr info -m
encr info [[-r] [...]]
encr info - Display encryption-related information
encr info - [-m ] mount point
encr info - [-r] recursively print information
encr info - path name
encr on -m [[-a {AES} -k {128|192|256}]
encr on [-r] [...]]
encr on - Enable encryption
encr on - [-m ] mount point
encr on - [-a {AES}] encryption algorithm
encr on - [-k {128|192|256}] encryption key length
encr on default algorithm and key length are
encr on parameters set on volume
encr on - [-r] recursively enable
encr on - path name
encr off -m
encr off [[-r] [...]]
encr off - Disable encryption
encr off - [-m ] mount point
encr off - [-r] recursively disable
encr off - path name
keystore migrate [-p] - Migrate keystore from PKCS to SSO or vice versa
audit init -M -A
audit init
audit enable -m -s
audit enable
audit disable -m -s
audit disable
audit info -m
audit info
audit archive -m
audit archive - Archive the audit trail
audit archive - [-m ] mount point
audit read -m
audit read - Mark audit trail archive as read
audit read - [-m ] mount point
audit purge -m -f
audit purge - Delete the audit trail archive
audit purge - [-m ] mount point
audit purge - [-f] forceful deletion of audit trail archive
plugin enable -m [-t tagname,...] [-i [s|m]]
plugin enable - Enable plug-in metrics collection
plugin enable -m - Types of metrics to collect
plugin enable [-t tagname,...] - Tags for which to collect metrics
plugin enable [-i [s|m]] - Interval at which to post metrics
plugin disable - Disable plug-in
plugin info - Configuration information about plug-in

root@oda1 /root #

get ddl from command line
OBJECT_TYPE	COMMAND
(DB LINK)	SQL> set long 10000
	SQL> select dbms_metadata.get_ddl('DB_LINK',DB_LINK,'PUBLIC') from dba_db_links where DB_LINK='LINK_NAME';
	select 'select dbms_metadata.get_ddl(''TABLE'','''\|\|TABLE_NAME\|\|''','''\|\|OWNER\|\|''') from dual;' as "--Command" from dba_tables where owner IN ('MYNAME');

user	SELECT dbms_metadata.get_ddl('USER','MDSSWEBUSER') from dual;
roles granted	SELECT DBMS_METADATA.GET_GRANTED_DDL( 'ROLE_GRANT','MDSSWEBUSER') from dual;
roles	SELECT dbms_metadata.get_ddl('ROLE','MDSSWEBUSER') from dual;
profile	SELECT DBMS_METADATA.GET_DDL('PROFILE','DEFAULT') FROM DUAL;
objects grants	SELECT DBMS_METADATA.GET_GRANTED_DDL( 'OBJECT_GRANT','MDSSWEBUSER') from dual;
system grants	SELECT DBMS_METADATA.GET_GRANTED_DDL( 'SYSTEM_GRANT','MDSSWEBUSER') from dual;
cluster	select dbms_metadata.get_ddl('CLUSTER','C_MLOG#','SYS') from dual;
context	select dbms_metadata.get_ddl('CONTEXT','LT_CTX') from dual;
function	select dbms_metadata.get_ddl('FUNCTION','TO_DATE_FUNC','SCOTT') from dual;
index	select dbms_metadata.get_ddl('INDEX','REPCAT$_REPCOLUMN_PK','SYSTEM') from dual;
java source	select dbms_metadata.get_ddl('JAVA_SOURCE','java_util','ADAM') from dual
	select dbms_metadata.get_ddl('JAVA_SOURCE','/6c363944_Dumper','SYS') from dual
library	select dbms_metadata.get_ddl('LIBRARY','UTL_SMT_LIB','SYS') from dual;
materialized view	select dbms_metadata.get_ddl('MATERIALIZED_VIEW','BS_TAB_MV','SYS') from dual;
mv log	select dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG','MLOG$_BS_TABLE','SYS') from dual;
operator	select dbms_metadata.get_ddl('OPERATOR','OLAP_EXPRESSION') from dual;
	select dbms_metadata.get_ddl('OPERATOR','OLAP_EXPRESSION','SYS') from dual;
package	select dbms_metadata.get_ddl('PACKAGE','XMLPARSER') from dual;
	select dbms_metadata.get_ddl('PACKAGE','XMLPARSER','SYS') from dual;
package body	select dbms_metadata.get_ddl('PACKAGE_BODY','STATSPACK','PERFSTAT') from dual;
procedure	select dbms_metadata.get_ddl('PROCEDURE','ORA$_SYS_REP_AUTH','SYSTEM') from dual;
sequence	select dbms_metadata.get_ddl('SEQUENCE','STATS$SNAPSHOT_ID','PERFSTAT') from dual;
synonym	select dbms_metadata.get_ddl('SYNONYM','/2fddc42_paintARGB_PRE_ONTO_S5','PUBLIC') from dual;
table	select dbms_metadata.get_ddl('TABLE','SQLEXPERT_PLAN1','SYSTEM') from dual;
tablespace	select dbms_metadata.get_ddl('TABLESPACE','USERS') from dual;
trigger	select dbms_metadata.get_ddl('TRIGGER','DEF$_PROPAGATOR_TRIG','SYSTEM') from dual;
type	select dbms_metadata.get_ddl('TYPE','XMLSEQ_IMP_T','SYS') from dual;
type body	select dbms_metadata.get_ddl('TYPE_BODY','ORACLE_LOADER','SYS') from dual;
view	select dbms_metadata.get_ddl('VIEW','DBA_PROPAGATION','SYS') from dual;
	select dbms_metadata.get_ddl('VIEW','DBA_PROPAGATION') from dual;
package	select dbms_metadata.get_ddl('PACKAGE','DBMS_METADATA','SYS') from dual;

Have your say

Friday, December 4, 2015

Need DDL but no GUI : No Problem : DBMS_METADATA to the rescue.

ASM Cluster File System [ACFS]

Blog Archive

About Me