Oracle ASMLIB v/s Oracle ASM Filter Driver (ASMFD)

Oracle ASM Filter Driver (Oracle ASMFD) is installed with an Oracle Grid Infrastructure installation. If you have an existing Oracle ASM library driver (Oracle ASMLIB) configuration, then depending on whether you want to use Oracle ASMLIB or Oracle ASMFD, consider the following scenarios: If you use Oracle ASMLIB to manage your Oracle ASM devices and […]

Read More

Back Up & Restore an Oracle ASM Password File with pwget Command

In this article we are showing how to backup and restore password file of Oracle ASM with pwget command. pwget Purpose Returns the location of the password file for the Oracle ASM or database instance. pwcopy Purpose Copies an Oracle ASM or database instance password file to the specified location. pwset Purpose Sets the location […]

Read More

Different ways to find spfile location in Oracle RAC

1. By using SqlPlus $ sqlplus / as sysasm SQL> show parameter spfile NAME    TYPE      VALUE ——     ——     ————————————————- spfile     string     +DATA/ASM/ASMPARAMETERFILE/registry.253.822856169 SQL> 2. By using ASMCMD find command $ asmcmd find –type ASMPARAMETERFILE +DATA “*” +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.822856169 3. By using spget command ASMCMD> spget +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.822856169 […]

Read More

Use spget and spmove command in Oracle ASM

Starting with ASM version 11.2, the ASM spfile can be stored in an ASM disk group. Indeed, during a new ASM installation, the Oracle Universal Installer (OUI) will place the ASM spfile in the disk group that gets created during the installation. New ASMCMD commands To support this feature, new ASMCMD commands were introduced to […]

Read More

ACFS for Database and Flex ASM – Part II

I must thank my fellow DBA Franky Weber Faust for his publication in Portuguese OTN. Objective: Explain and demonstrate the use of ACFS for storing Oracle Home binaries and the database itself, registering the ACFS filesystem to start automatically, configuring the logs to be generated in a unified directory, and displaying ACFS behavior with the […]

Read More