Skip to main content

Posts

Showing posts from September, 2023

Oracle Database RMAN Backup Script

RMAN Backup Script Oracle Recovery Manager (RMAN) is a comprehensive tool designed to efficiently back up and recover Oracle databases. It works closely with the server, providing block-level corruption detection during backup and restore. RMAN backups are created using the 'BACKUP' command. The primary purpose of RMAN backups is to protect your data. In the event of a media failure or disaster, you can restore your backups and recover lost changes. For more detailed information about RMAN backup concepts, you can refer to the Oracle Help Center. Additionally, if you are interested in creating an Oracle database backup using RMAN, you can find step-by-step instructions on how to do so in the Oracle-Patches website. archivelog_not_backed_up.sh cat /home/oracle/.scripts/archivelog_not_backed_up.sh

Logical Volume Manager (LVM) of MultiPath Block Storage

Logical Volume Manager (LVM) of MultiPath Block Storage 01.00. Attached Block Storage Device: 01.01. Check the attached block storage device on the host. lsblk If we can see the mpathX, where X = a, b, c etc. our block storage device provides by multipath channel. In that case we also check by- 'multipath -l' or 'multipath -ll' command. 01.02. Now check the mpathX block storage device and its associated representator disk. sdb             8:16   0  600G  0 disk   └─mpatha      253:5    0  600G  0 mpath  sdc             8:32   0  600G  0 disk   └─mpathb      253:6    0  600G  0 mpath  sdd             8:48   0  600G  0 disk   └─mpathc      253:7    0  600G  0 mpath  sde             8:64   0    1T  0 disk   └─mpathd      253:8    0    1T  0 mpath  sdf             8:80   0  400G  0 disk   └─mpathe      253:10   0  400G  0 mpath  sdg             8:96   0    1T  0 disk   └─mpathf      253:12   0    1T  0 mpath  sdh             8:112  0    1T  0 disk   └─mpathd      253:8    0