ORACLE: ASM - Backup And Restore DiskGroup Metadata With Oracle 21c - ptdb

Starting with Oracle 11g, Oracle extended the ASMCMD command to include ASM disk group metadata backup and restore functionality.

For a list of all commands added with 11g, take a look at the following MOS Note: ASMCMD – New commands in 11gR1 (Doc ID 451900.1)

The ASMCMD md_backup and md_restore commands provide the ability to recreate a pre-existing ASM disk group with the same disk paths, disk names, failure groups, attributes, templates and alias directory structure. In 10g you have to manually recreate the ASM disk group and any required user directories/templates. In 11g or newer we can take backup of ASM diskgroup metadata.

The md_backup command creates a backup file containing metadata for one or more disk groups. By default all the mounted disk groups are included in the backup file which is saved in the current working directory.

Backup the ACFS Disk Group metadata.

ASMCMD> lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512             512   4096  8388608      8192     7824                0            3912              0             N  ACFS/
MOUNTED  NORMAL  N         512             512   4096  1048576     24576    13609             8192            2708              0             N  DATA/
MOUNTED  NORMAL  N         512             512   4096  1048576     49152    45493             8192           18650              0             N  FRA/

[grid@ocm199 backup]$ srvctl status diskgroup -g ACFS
Disk Group ACFS is running on ocm199

Now run the actual md_backup command.

[sourcecode language="plain"]
ASMCMD> md_backup /u01/app/oracle/admin/+ASM/backup/ACFS_DG.metadata.backup -G ACFS
Disk group metadata to be backed up: ACFS
Current alias directory path: sw0
Current alias directory path: sw0/oracle
Current alias directory path: sw0/redis
Current alias directory path: sw0/postgres
Current alias directory path: sw0/mariadb
ASMCMD>


In case you want to learn more about the md_backup command, check out the help.
[sourcecode language="plain"]
ASMCMD> help md_backup
md_backup
        The md_backup command creates a backup file containing metadata
        for one or more disk groups.
        Volume and Oracle Automatic Storage Management Cluster File System
        (Oracle ACFS) file system information is also backed up.

Synopsis
        md_backup <backup_file> [--acfs_sec_encr] [-G <diskgroups,...>]

Description
        The options for the md_backup command are described below.

        backup_file     - Specifies the backup file in which you want to
                          store the metadata.
        --acfs_sec_encr - Specifies that security, encryption, and/or
                          audit information from ACFS will be backed up.
        -G diskgroup    - Specifies the disk group name of the disk group
                          that must be backed up

        By default all the mounted disk groups are included in the backup file,
        which is saved in the current working directory.

Examples
        The first example shows the use of the backup command when run
        without the disk group option. This example backs up all of the mounted
        disk groups and creates the backup image in the
        /scratch/backup/alldgs20100422 file. The second example creates a
        backup of DATA disk group. The backup that this example creates is
        saved in the /scratch/backup/data20100422 file. The third example
        creates a full disk group backup. This example backs up all of the
        mounted disk groups, volumes and file system that are visible on
        the current node and created the backup image in the given path.
        The forth example creates a full backup of disk group, volume and
        file system including file system security, encryption and audit
        attributes. The fifth example creates a backup of DATA disk group.
        This example starts DATA disk group backup and detects a volume
        with DRL (Disk group Recovery Log) and it adds DATADRL disk group
        to backup.

        ASMCMD [+] > md_backup /scratch/backup/alldgs20100422
        Disk group metadata to be backed up: DATA
        Disk group metadata to be backed up: FRA
        Current alias directory path: ORCL/ONLINELOG
        Current alias directory path: ORCL/PARAMETERFILE
        Current alias directory path: ORCL
        Current alias directory path: ASM
        Current alias directory path: ASM/ASMPARAMETERFILE
        Current alias directory path: ORCL/DATAFILE
        Current alias directory path: ORCL/TEMPFILE
        Current alias directory path: ORCL/CONTROLFILE
        Current alias directory path: ORCL/ARCHIVELOG/2009_07_13
        Current alias directory path: ORCL/BACKUPSET/2009_07_14
        Current alias directory path: ORCL/ARCHIVELOG/2009_07_14
        Current alias directory path: ORCL
        Current alias directory path: ORCL/DATAFILE
        Current alias directory path: ORCL/ARCHIVELOG
        Current alias directory path: ORCL/BACKUPSET
        Current alias directory path: ORCL/ONLINELOG


        ASMCMD [+] > md_backup /scratch/backup/data20100422 -G DATA
        Disk group metadata to be backed up: DATA
        Current alias directory path: ASM/ASMPARAMETERFILE
        Current alias directory path: ORCL/DATAFILE
        Current alias directory path: ORCL/TEMPFILE
        Current alias directory path: ORCL/CONTROLFILE
        Current alias directory path: ORCL/PARAMETERFILE
        Current alias directory path: ASM
        Current alias directory path: ORCL
        Current alias directory path: ORCL/CONTROLFILE
        Current alias directory path: ORCL/DATAFILE
        Current alias directory path: ORCL/ARCHIVELOG
        Current alias directory path: ORCL/BACKUPSET
        Current alias directory path: ORCL/ONLINELOG


        ASMCMD [+] > md_backup /scratch/backup/data20100422
        Disk group metadata to be backed up: DATA
        ADVM metadata to be backed up: VOL1
        ADVM metadata to be backed up: VOL2
        ADVM metadata to be backed up: VOL3
        ACFS metadata to be backed up:/mountfs/fs1
        ACFS metadata to be backed up:/mountfs/fs2
        ACFS metadata to be backed up:/mountfs/fs3


        ASMCMD [+] > md_backup /scratch/backup/data20100422 --acfs_sec_encr
        Disk group metadata to be backed up: DATA
        ADVM metadata to be backed up: VOL1
        ADVM metadata to be backed up: VOL2
        ADVM metadata to be backed up: VOL3
        ACFS metadata to be backed up:/mountfs/fs1
        ACFS metadata to be backed up:/mountfs/fs2
        ACFS metadata to be backed up:/mountfs/fs3


        ASMCMD [+] > md_backup /scratch/backup/data20100422 -G DATA
        Disk group metadata to be backed up: DATA
        ADVM metadata to be backed up: VOL1
        ADVM metadata to be backed up: VOL2
        ADVM metadata to be backed up: VOL3
        ACFS metadata to be backed up:/mountfs/fs1
        ACFS metadata to be backed up:/mountfs/fs2
        ACFS metadata to be backed up:/mountfs/fs3
        Disk group metadata to be backed up: DATADRL
        ADVM metadata to be backed up: DRLVOL3
        ADVM metadata to be backed up: VOL5
        ACFS metadata to be backed up:/mountfs/fs4
        ACFS metadata to be backed up:/mountfs/fs5

Stop the Disk Group ACFS and check the Disk Group status.

[grid@ocm199 backup]$ srvctl stop diskgroup -g ACFS -f
[grid@ocm199 backup]$
[grid@ocm199 backup]$ asmcmd lsdg -g --discovery ACFS
Inst_ID  State       Type  Rebal  Sector  Logical_Sector  Block  AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
      1  DISMOUNTED        N           0               0      0   0         0        0                0               0              0             N  ACFS/

Remove the Disk Group ACFS and cleanup the disk headers and check status.

[grid@ocm199 backup]$ srvctl remove diskgroup -g ACFS -f
[grid@ocm199 backup]$

[grid@ocm199 backup]$ dd if=/dev/zero of=/dev/nvme0n1 bs=8192 count=1024
1024+0 records in
1024+0 records out
8388608 bytes (8.4 MB, 8.0 MiB) copied, 0.0291739 s, 288 MB/s

[grid@ocm199 backup]$ dd if=/dev/zero of=/dev/nvme0n2 bs=8192 count=1024
1024+0 records in
1024+0 records out
8388608 bytes (8.4 MB, 8.0 MiB) copied, 0.0396138 s, 212 MB/s
[grid@ocm199 backup]$

[grid@ocm199 backup]$ srvctl status diskgroup -g ACFS
PRCA-1000 : ASM Disk Group ACFS does not exist
PRCR-1001 : Resource ora.ACFS.dg does not exist

[grid@ocm199 backup]$ asmcmd lsdg -g --discovery ACFS
ASMCMD-8001: diskgroup 'ACFS' does not exist or is not mounted

Before recreating the ACFS Disk Group, check the disk status and the disk group status.

[grid@ocm199 backup]$ asmcmd lsdsk -k -g --candidate
Inst_ID  Total_MB  Free_MB  OS_MB  Name       Failgroup  Site_Name  Site_GUID  Site_Status  Failgroup_Type  Library   Redund   Path
      1         0        0   4096                                                           REGULAR         System    UNKNOWN  /dev/nvme0n1
      1         0        0   4096                                                           REGULAR         System    UNKNOWN  /dev/nvme0n2
      1         0        0   8192                                                           REGULAR         System    UNKNOWN  /dev/sdl
      1         0        0   8192                                                           REGULAR         System    UNKNOWN  /dev/sdm
[grid@ocm199 backup]$

Now restore the Disk Group in full mode. The full mode restores the disk group exactly as it was at the time of backup.

[grid@ocm199 backup]$ asmcmd
ASMCMD> md_restore /u01/app/oracle/admin/+ASM/backup/ACFS_DG.metadata.backup --full -G ACFS
Current Diskgroup metadata being restored: ACFS
Diskgroup ACFS created!
System template AUTOLOGIN_KEY_STORE modified!
System template ASMPARAMETERFILE modified!
System template TEMPFILE modified!
System template PARAMETERFILE modified!
System template CHANGETRACKING modified!
System template BACKUPSET modified!
System template DUMPSET modified!
System template INCR XTRANSPORT BACKUPSET modified!
System template OCRFILE modified!
System template ARCHIVELOG modified!
System template AUDIT_SPILLFILES modified!
System template AUTOBACKUP modified!
System template DATAFILE modified!
System template FLASHBACK modified!
System template DATAGUARDCONFIG modified!
System template XTRANSPORT BACKUPSET modified!
System template CONTROLFILE modified!
System template VOTINGFILE modified!
System template XTRANSPORT modified!
System template FLASHFILE modified!
System template KEY_STORE modified!
System template ONLINELOG modified!
Directory +ACFS/sw0 re-created!
Directory +ACFS/sw0/redis re-created!
Directory +ACFS/sw0/postgres re-created!
Directory +ACFS/sw0/oracle re-created!
Directory +ACFS/sw0/mariadb re-created!
ASMCMD>


[grid@ocm199 backup]$ asmcmd lsdg -g  --discovery ACFS
Inst_ID  State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
      1  MOUNTED  NORMAL  N         512             512   4096  8388608      8192     7824                0            3912              0             N  ACFS/

Restart the Disk Group if necessary and display the Disk Group status.

[grid@ocm199 backup]$ srvctl start diskgroup -g ACFS
PRCC-1014 : ACFS was already running
PRCR-1004 : Resource ora.ACFS.dg is already running
PRCR-1079 : Failed to start resource ora.ACFS.dg
CRS-5702: Resource 'ora.ACFS.dg' is already running on 'ocm199'
[grid@ocm199 backup]$

[grid@ocm199 backup]$ srvctl status diskgroup -g ACFS
Disk Group ACFS is running on ocm199
[grid@ocm199 backup]$

Instead of running the md_restore command directly, you could have created a SQL file instead, which lists all the SQL commands.

ASMCMD> md_restore -S /u01/app/oracle/admin/+ASM/backup/md_restore.sql /u01/app/oracle/admin/+ASM/backup/ACFS_DG.metadata.backup --full -G ACFS
Current Diskgroup metadata being restored: ACFS


[grid@ocm199 ~]$ cat /u01/app/oracle/admin/+ASM/backup/md_restore.sql
create diskgroup ACFS NORMAL redundancy failgroup ACFS_0001 disk '/dev/nvme0n2' name ACFS_0001 size 4096M failgroup ACFS_0000 disk '/dev/nvme0n1' name ACFS_0000 size 4096M attribute 'compatible.asm' = '21.0.0.0.0', 'compatible.rdbms' = '21.0.0.0.0', 'au_size' = '8388608';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.OCRFILE._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUDIT_SPILLFILES.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT BACKUPSET._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ARCHIVELOG._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHBACK.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.PARAMETERFILE._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHFILE._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.BACKUPSET.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.KEY_STORE.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ASMPARAMETERFILE._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.INCR XTRANSPORT BACKUPSET.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CONTROLFILE._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAFILE._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DUMPSET.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOLOGIN_KEY_STORE.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.PARAMETERFILE.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.VOTINGFILE._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT BACKUPSET.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.BACKUPSET._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ASMPARAMETERFILE._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOBACKUP._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ASMPARAMETERFILE.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ARCHIVELOG._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DUMPSET.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CHANGETRACKING.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAGUARDCONFIG._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.VOTINGFILE._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ARCHIVELOG.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.BACKUPSET._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHFILE.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ASMPARAMETERFILE.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAFILE.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ARCHIVELOG.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CONTROLFILE._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CHANGETRACKING._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAGUARDCONFIG.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAFILE._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.OCRFILE._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.KEY_STORE._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHFILE._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHFILE._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.INCR XTRANSPORT BACKUPSET._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.VOTINGFILE.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUDIT_SPILLFILES._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUDIT_SPILLFILES.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAGUARDCONFIG._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CHANGETRACKING._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.KEY_STORE._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHBACK._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.OCRFILE._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.PARAMETERFILE.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOBACKUP._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.TEMPFILE._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.BACKUPSET.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CHANGETRACKING.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHBACK._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.BACKUPSET.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHFILE.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ONLINELOG._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAFILE.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CHANGETRACKING._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUDIT_SPILLFILES._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT BACKUPSET.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHFILE._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAGUARDCONFIG.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOBACKUP._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOLOGIN_KEY_STORE._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHFILE._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DUMPSET._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ARCHIVELOG.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CONTROLFILE._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOBACKUP.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.INCR XTRANSPORT BACKUPSET._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT BACKUPSET.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOLOGIN_KEY_STORE.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUDIT_SPILLFILES._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ARCHIVELOG._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.BACKUPSET._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.KEY_STORE.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHBACK.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHBACK.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOBACKUP.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOLOGIN_KEY_STORE._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT BACKUPSET._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.TEMPFILE._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT BACKUPSET._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ONLINELOG.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.PARAMETERFILE._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.KEY_STORE.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHBACK.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.TEMPFILE.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.INCR XTRANSPORT BACKUPSET.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.TEMPFILE.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAGUARDCONFIG.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ONLINELOG._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.OCRFILE._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ONLINELOG.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOLOGIN_KEY_STORE._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAGUARDCONFIG._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.INCR XTRANSPORT BACKUPSET._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.BACKUPSET._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.VOTINGFILE.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.OCRFILE.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ASMPARAMETERFILE._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.OCRFILE.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.VOTINGFILE._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.OCRFILE._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.BACKUPSET._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT BACKUPSET._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.OCRFILE.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOLOGIN_KEY_STORE.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DUMPSET.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ARCHIVELOG.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CONTROLFILE._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOBACKUP.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.INCR XTRANSPORT BACKUPSET.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.BACKUPSET.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.TEMPFILE._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAFILE.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOLOGIN_KEY_STORE._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute '_USD.LIST_SIZE' = '4';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.KEY_STORE._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ONLINELOG._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ONLINELOG.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ARCHIVELOG._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAGUARDCONFIG.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CONTROLFILE.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DUMPSET._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CHANGETRACKING.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DUMPSET._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.PARAMETERFILE._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CHANGETRACKING._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT BACKUPSET._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOLOGIN_KEY_STORE.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.VOTINGFILE._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.INCR XTRANSPORT BACKUPSET._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOBACKUP._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.VOTINGFILE._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CHANGETRACKING._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.TEMPFILE.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.TEMPFILE._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOBACKUP.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ARCHIVELOG._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOLOGIN_KEY_STORE._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAFILE._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DUMPSET.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHFILE.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.PARAMETERFILE._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.OCRFILE.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ONLINELOG._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ASMPARAMETERFILE.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHBACK._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.KEY_STORE._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHBACK._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHBACK._DIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.XTRANSPORT BACKUPSET.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ASMPARAMETERFILE.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.VOTINGFILE.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUDIT_SPILLFILES.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute '_._DIRVERSION' = '21.0.0.0.0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ONLINELOG.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CONTROLFILE.REDUNDANCY' = '19';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.INCR XTRANSPORT BACKUPSET.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAFILE._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CONTROLFILE._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DUMPSET._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAGUARDCONFIG._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUDIT_SPILLFILES.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.PARAMETERFILE.PRIMARY_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.TEMPFILE._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAGUARDCONFIG._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.KEY_STORE._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ASMPARAMETERFILE._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAFILE._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ONLINELOG._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CHANGETRACKING.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.ASMPARAMETERFILE._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.PARAMETERFILE._SYSTEM' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CONTROLFILE.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.TEMPFILE.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.INCR XTRANSPORT BACKUPSET._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUDIT_SPILLFILES._STRIPE_WIDTH' = '8';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUTOBACKUP._STRIPE_SIZE' = '17';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DUMPSET._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.FLASHFILE.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.PARAMETERFILE.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.DATAFILE.MIRROR_REGION' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.KEY_STORE.REDUNDANCY' = '18';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.CONTROLFILE.STRIPE' = '1';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.AUDIT_SPILLFILES._INDIRECT_EXTENTS' = '4294967295, 0, 0';
alter diskgroup /*ASMCMD AMBR*/ACFS set attribute 'TEMPLATE.VOTINGFILE.STRIPE' = '0';
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "INCR XTRANSPORT BACKUPSET" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "KEY_STORE" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "ONLINELOG" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "DATAGUARDCONFIG" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "FLASHFILE" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "DATAFILE" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "AUTOLOGIN_KEY_STORE" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "CHANGETRACKING" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "CONTROLFILE" attributes (HIGH FINE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "ARCHIVELOG" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "BACKUPSET" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "DUMPSET" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "AUTOBACKUP" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "VOTINGFILE" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "FLASHBACK" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "ASMPARAMETERFILE" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "PARAMETERFILE" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "OCRFILE" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "AUDIT_SPILLFILES" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "TEMPFILE" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "XTRANSPORT" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR*/ACFS alter template "XTRANSPORT BACKUPSET" attributes (MIRROR COARSE);
alter diskgroup /*ASMCMD AMBR */ ACFS add directory '+ACFS/sw0';
alter diskgroup /*ASMCMD AMBR */ ACFS add directory '+ACFS/sw0/redis';
alter diskgroup /*ASMCMD AMBR */ ACFS add directory '+ACFS/sw0/postgres';
alter diskgroup /*ASMCMD AMBR */ ACFS add directory '+ACFS/sw0/oracle';
alter diskgroup /*ASMCMD AMBR */ ACFS add directory '+ACFS/sw0/mariadb';
[grid@ocm199 ~]$

In case you want to learn more about the md_restore command, check out the help.

ASMCMD> help md_restore
md_restore
This command restores a disk group and ACFS metadata from backup.

Synopsis
md_restore <backup_file> [--silent][--full|--nodg|--newdg -o <old_diskgroup:new_diskgroup,...>] [--acfs_sec_encr <user:group> [--acfs_audit <user:mgr_group:auditor_group>]] [-S <sql_script_file>] [-G <diskgroups,...>]

Description
The options for the md_restore command are described below.

backup_file - Reads the metadata information from
backup_file.
--silent - Ignore errors. Normally, if md_restore
encounters an error, it will stop.
Specifying this flag ignores any errors.
--full - Specifies to create a disk group and restore
metadata.
--nodg - Specifies to restore metadata only.
--newdg -o old_diskgroup:new_diskgroup - Specifies a comma separated list
of old diskgroup name and new diskgroup names to create a disk
group with a different name when restoring
metadata. The -o option is required
with --newdg.
--acfs_sec_encr user:group
- Restore security and/or encryption.
The colon separated user and group
will be used for security restoration.
During restore, security and/or
encryption need to be initialized.
If security and/or encryption is not
pre-initialized, the colon separated values
passed to the acfs_sec_encr option will
be used to initialize security.
Encryption will be initialized with SSO wallet.
--acfs_audit user:mgr_group:auditor_group
- Requires acfs_sec_encr. Restores audit
information on an ACFS file system.
The colon separated values will be used
to initialize and execute audit commands.
During restore, audit needs to be initialized.
If audit is not pre-initialized, the audit
layer will be initialized using the colon
separated values given to the acfs_audit
option.
-S sql_script_file - Write SQL commands to the specified SQL
script file instead of executing the commands.
-G diskgroups - Comma separated list of disk groups to be restored.
If no disk groups are defined, then all
disk groups will be restored.

Examples
The first example restores the disk group DATA from the backup script
and creates a copy. The second example takes an existing disk group
DATA and restores its metadata. The third example restores disk group
DATA completely but the new disk group that is created is called DATA2.
The fourth example performs a full restore and inializes security with
the user johndoe and group dba. For this case audit is not restored.
The fifth example performs a full restore initializing security with
the user johndoe and group dba and initializing audit with manager
group sys and auditors group dba, user janedoe is used for restoring
backup audit settings.
The sixth example restores from the backup file after applying the
overrides defined in the override.sql script file

ASMCMD [+] > md_restore --full -G data --silent /tmp/dgbackup20090714
ASMCMD [+] > md_restore --nodg -G data --silent /tmp/dgbackup20090714
ASMCMD [+] > md_restore --newdg -o 'data:data2' --silent
/tmp/dgbackup20090714
ASMCMD [+] > md_restore --acfs_sec_encr johndoe:dba /tmp/dgbackup20090714
ASMCMD [+] > md_restore --acfs_sec_encr johndoe:dba -acfs_audit janedoe:sys:dba /tmp/dgbackup20090714
ASMCMD [+] > md_restore -S override.sql --silent /tmp/dgbackup20090714

ASMCMD>

Conclusion

The ASMCMD md_backup and md_restore is a very useful feature which helps you re-creating the ASM structure. But be careful, it restores only the metadata, not the data itself.

Post Views: 731

Conclusion

You Might Also Like

How To Create Udev Rules for Oracle 19c ASM on CentOS/RHEL 8.2

ORACLE: How to change the Oracle 21c ASM instance from MEMORY_TARGET to SGA_TARGET (Use HugePages)

How To Implement Unified Auditing For An Oracle 19c ASM Instance