DanBrother的部落格

Oracle 12c ASM Disk Groups Backup & Restore Example
SQL> conn sys@pdb1 as sysdba
Enter password:
Connected.
SQL> show con_name
CON_NAME
------------------------------
PDB1
Create a Tablespace Named DATA2_TBS In Disk Group DATA2:
SQL> create tablespace DATA2_TBS datafile '+DATA2' SIZE 10M autoextend on next 1 M;
Tablespace created.
SQL> select file_name from dba_data_files where tablespace_name = 'DATA2_TBS';
FILE_NAME
--------------------------------------------------------------------------------
+DATA2/CDBRAC/426B78A071E83DCAE0530B0AA8C04DB5/DATAFILE/data2_tbs.256.930739747
1 row selected.

Online ASM Disk Migration of Oracle 11g RAC  (Demo on Oracle VM VirtualBox 5.0)
On the host operating system(Windows 7 as my environment), switch to the command line interface:

Issue:
ORA-15306: ASM Password File Update Failed On At Last One Node While Createing ASMSNMP User
Cause:
ASM password file is missing or typo in one or several node(s) or it is corrupt.

Solution:
cd $GRID_HOME/dbs
orapwd file=orapw+ASM1 entries=5 passwod=mypwd
scp -p orapw+ASM1 rac2:/grid/grid11203/dbs/orapw+ASM2

Error Messages found in /var/log/messages as follows:
multipathd: asm!.asm_ctl_spec: add path (uevent)
multipathd: asm!.asm_ctl_spec: failed to store path info
multipathd: uevent trigger error
Solution:
Modify /etc/multipath.conf  and add the highlighted two lines to the file.
>>
blacklist {
        devnode         "^(ram|raw|loop|fd|md|dm-|sr|scd|st)[0-9]*"
        devnode         "^hd[a-z][[0-9]*]"
        devnode         "^asm/*"
        devnode         "ofsctl"
}

oracle enterprise manager 11g login:
conn sys as sysasm encountered ORA-01031
Solution:
export ORACLE_SID=+ASM1
sqlplus / as sysasm
grant sysasm to sys;

Change SPFILE location to ASM:
[oracle@RAC1 ~]$ srvctl config database -d TESTDB
Database unique name: TESTDB
Database name: TESTDB
Oracle home: /oracle/db11gr2
Oracle user: oracle
Spfile: +DATA/TESTDB/spfileTESTDB.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: TESTDB
Database instances: TESTDB1,TESTDB2
Disk Groups: DATA,ARCH
Mount point paths:
Services:
Type: RAC
Database is administrator managed

ASM Command - asmcmd
asmcmd -p    => which show full path
Inside asmcmd:
help
ls
ls -l  => Display extended file information.
ls -s => Display file space information.
ls -t => Sort the listing by timestamp (lastest first) instead of by name.

lsdsk => List Oracle ASM disks.
lsdg   => List diskgroups and their information.  (from v$asm_diskgroup_stat)
cd   =>  Change directory (which is case insensitive)
pwd => Display the absolute path of the current directory.
lsct    => list current Oracle ASM clients from the v$asm_client view.

** For Oracle11gR2  on RHEL4.8 (x64) :
Modify/etc/udev/permission.d/50-udev.permissions
dm-[0-3]:oracle:dba:0664
** For Oracle11gR2  on RHEL5.5 (x64) :
Modify/etc/rc.local
chmod 0660 /dev/mapper/DATA
chmod 0660 /dev/mapper/ARCH
chmod 0660 /dev/mapper/SYSTEM