Oracle Database Commands and Practical Examples: RMAN - Full Backup on asm disk group and script to copy backup from asm disk group to local disk

RMAN - Full Backup on asm disk group and script to copy backup from asm disk group to local disk

Login asmcmd console and create directory fro backup on shared storage
Add controlfile snapshot location on ASM disk group.
Create full rman backup script mentioning asm backup location and Connect rman or shedule script in corntab for backup
Check backup status on disks
Script to copy rman backup to local disk from asm diskgroup

Login and create backup directory on asm disk group

grid@srv1:/home/oracle> . oraenv

ORACLE_SID = [rac1] ? +ASM1

The Oracle base has been changed from /u01/app/oracle to /u01/app/grid

grid@srv1:/home/oracle> asmcmd

ASMCMD> lsdg

State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED EXTERN N 512 4096 1048576 24573 20095 0 20095 0 Y CRS/

MOUNTED EXTERN N 512 4096 1048576 15359 13098 0 13098 0 N DATA/

MOUNTED EXTERN N 512 4096 1048576 15359 14617 0 14617 0 N FRA/

ASMCMD> mkdir rmanbkp

ASMCMD> pwd

+FRA/rmanbkp

ASMCMD> mkdir rmnan_snapshot

ASMCMD> ls

RAC/

rmanbkp/

rmnan_snapshot/

ASMCMD> rm -f rmnan_snapshot/

ASMCMD> mkdir rman_snapshot

ASMCMD> ls

RAC/

rman_snapshot/

rmanbkp/

ASMCMD> cd rman_snapshot/

ASMCMD> pwd

+FRA/rman_snapshot

ASMCMD> ls

snapcf_rac1.f

Add controlfile snapshot location on ASM disk group.

oracle@srv1:~> rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Dec 8 13:38:11 2021

connected to target database: RAC (DBID=2666656136)

RMAN> show all ;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name RAC are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/snapcf_rac1.f'; # default

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/rman_snapshot/snapcf_rac1.f';

new RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/rman_snapshot/snapcf_rac1.f';

new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters for database with db_unique_name RAC are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/rman_snapshot/snapcf_rac1.f';

RMAN>

Add backup location on full rman backup script

run

{

allocate channel c1 device type disk format '+FRA/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

allocate channel c2 device type disk format '+FRA/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

allocate channel c3 device type disk format '+FRA/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

crosscheck backup;

crosscheck archivelog all;

report obsolete;

delete noprompt obsolete;

sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

#backup full database format '+FRA/rmanbkp/%d_%U.bckp' plus archivelog;

copy current controlfile to '+FRA/rmanbkp/control_%d_%T.bak';

backup current controlfile for standby format '+FRA/rmanbkp/standbycontrol_%d_%U.ctl';

release channel c1;

release channel c2;

release channel c3;

}

Login into rman console and run rman backup command

RMAN> run

{

allocate channel c1 device type disk format '+FRA/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

allocate channel c2 device type disk format '+FRA/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

allocate channel c3 device type disk format '+FRA/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

crosscheck backup;

crosscheck archivelog all;

report obsolete;

delete noprompt obsolete;

sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

#backup full database format '+FRA/rmanbkp/%d_%U.bckp' plus archivelog;

copy current controlfile to '+FRA/rmanbkp/control_%d_%T.bak';

backup current controlfile for standby format '+FRA/rmanbkp/standbycontrol_%d_%U.ctl';

release channel c1;

release channel c2;

release channel c3;

}2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18>

allocated channel: c1

channel c1: SID=55 instance=rac1 device type=DISK

allocated channel: c2

channel c2: SID=72 instance=rac1 device type=DISK

allocated channel: c3

channel c3: SID=1 instance=rac1 device type=DISK

specification does not match any backup in the repository