DanBrother的部落格

Oracle 12c ASM Disk Groups Backup & Restore Example

SQL> conn sys@pdb1 as sysdba
Enter password:

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:

How to Find Physical Devices for Oracle ASM Disks:

(login as root)

Issue:
ORA-15306: ASM Password File Update Failed On At Last One Node While Createing ASMSNMP User

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

crsctl status res -t  or
crsctl status resource -t
shows state_details as empty for some ASM instances

oracle enterprise manager 11g login:
conn sys as sysasm encountered ORA-01031

Change SPFILE location to ASM:

[oracle@RAC1 ~]$ srvctl config database -d TESTDB

Each time a change in the attribute for the storage RAID system, it will result in editing the multipath.conf
file, reloading the configurations, and restarting the Multipathd Daemon by the following commands:

Solving ORA-01180: can not create datafile When restoring DB for ASM disk files

Convert Controlfile to OMF:

# Current controlfile is none-OMF

$ srvctl  status asm
ASM is not running.

Check ASM Diskgroup Space Usage:

Method 1: Use Oracle11g Grid Control

vi /etc/multipath.conf
#add the followings:

ASM Disk Group Configuration Recommendation

1. Create three disk groups.
The first one is for the datafile (DATA_DG)