ASM

The srvctl utility can be used to set environment variables for a resource, with the "srvctl setenv" command. These environment variables are then used at resource startup. When setting an environment variable for the database with "srvctl setenv database", it affects all the instances that belong to that database. To give a concrete example, if you run this command: $ srvctl setenv database -d mydb -T "TNS_ADMIN=/oracle/102/asm/network/admin" Then, this setting of TNS_ADMIN will be used … [Read more...] about Oracle Database : How to set Environment Variables Using Srvctl

ASM files can be renamed like any other files in a standard filesystem. For ASM, rename is performed through some type of statements (ADD ALIAS, RENAME ALIAS, ADD DIRECTORY) to manipulate filenames, alias, and directories. Renaming datafiles is sometimes needed when database file names still contain old database name after a database on ASM is renamed (for example with nid). Then, it is required to change ASM datafile names accordingly with the new database name. RMAN backup copy doesn't … [Read more...] about How to move or rename a datafile in the same ASM diskgroup (Using ASM alias)

The post provides an example of how to define and associated meaningful device names for Candidate or Member ASM Disks on Linux/Unix using mknod. The example shown below is of a 2 node RAC setup with +ASM1 and +ASM2 instances. 1. We have below mounted on both +ASM1 & +ASM2 instances: GROUP_NUMBER NAME STATE TYPE TOTAL_MB FREE_MB ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 1 CRSDG MOUNTED EXTERN 20480 20052 2 DATADG1 MOUNTED EXTERN 102400 77005 3 DATADG2 MOUNTED EXTERN … [Read more...] about How To Create Device Alias For ASM Disks Using mknod On Linux/Unix

The post provides an example of how to resize an ACFS Filesystem/ASM Volume (ADVM) through the command line. 1. Create the ACFSDG (8GB) diskgroup from ASM instance: SQL> CREATE DISKGROUP ACFSDG EXTERNAL REDUNDANCY DISK 'ORCL:ASMDISK8' SIZE 4157 M DISK 'ORCL:ASMDISK9' SIZE 4157M ATTRIBUTE 'compatible.asm' = '11.2', 'compatible.advm' = '11.2'; Diskgroup created. SQL> Select name, state, total_mb, free_mb from v$asm_diskgroup where name like 'ACFSDG'; NAME … [Read more...] about How To Resize An ACFS Filesystem/ASM Volume (ADVM)

The post example shows how to delete the SPFILE in the +ASM DISKGROUP and relocate it to the $ORACLE_HOME/dbs directory. This process needs an instance restart and thus an outage. 1. Create pfile from the spfile First, we will create pfile in filesystem from the existing spfile in ASM. $ . oraenv a ORACLE_SID = [testdb] ? testdb SQL> create pfile=’$ORACLE_HOME/dbs/initINFPRD.ora’ from spfile='+DG_ARCH/TESTDB/spfileINFPRD.ora'; 2. Remove the spfile from ASM We can now connect the … [Read more...] about How to move spfile from ASM to filesystem

The post explains in detail the exact steps to migrate ASM diskgroups from one storage to another storage without a downtime. This procedure will also work for diskgroups hosting OCR and Votefiles and ASM spfile. Note: These steps are applicable to External, Normal & High redundancy diskgroups. If your plans are replacing the current disks associated to your diskgroups with a new storage, this operation can be accomplished without any downtime, so you can follow the next steps Add the … [Read more...] about How to Migrate ASM Disk Groups to another Storage Online [non ASMLIB Devices]

The post explains in detail the exact steps to migrate ASM diskgroups (when using ASMLIB devices) from one storage to another storage without a downtime. This procedure will also work for diskgroups hosting OCR, Vote files and ASM spfiles. Note: These steps are applicable to External, Normal & High redundancy diskgroups. Creating New ASM disks If you need to migrate and to replace the current ASMLIB disks associated to your diskgroups to a new storage, then you can perform this operation … [Read more...] about How to Migrate ASM Disk Groups to another Storage Online [When ASMLIB Devices Are Involved]