Purge ADR Contents

# Purge ADR contents (adr_purge.sh)

# 00 05 * * 0 adr_purge.sh

# Add the above line with `crontab -e` to the oracle user's cron

 

ALERT_RET="129600" # 90 Days

INCIDENT_RET="43200" # 30 Days

TRACE_RET="43200" # 30 Days

CDUMP_RET="43200" # 30 Days

HM_RET="43200" # 30 Days

 

echo "INFO: adrci purge started at `date`"

adrci exec="show homes"|grep -v : | while read file_line

do

echo "INFO: adrci purging diagnostic destination " $file_line

echo "INFO: purging ALERT older than 90 days"

adrci exec="set homepath $file_line;purge -age $ALERT_RET -type ALERT"

echo "INFO: purging INCIDENT older than 30 days"

adrci exec="set homepath $file_line;purge -age $INCIDENT_RET -type INCIDENT"

echo "INFO: purging TRACE older than 30 days"

adrci exec="set homepath $file_line;purge -age $TRACE_RET -type TRACE"

echo "INFO: purging CDUMP older than 30 days"

adrci exec="set homepath $file_line;purge -age $CDUMP_RET -type CDUMP"

echo "INFO: purging HM older than 30 days"

adrci exec="set homepath $file_line;purge -age $HM_RET -type HM"

echo ""

echo ""

done

echo

echo "INFO: adrci purge finished at `date`"

RAC Health Checks

 RAC Health Checks

1) RAC Node Apps Health Checks :

[grid@rac19cdb01 ~]$ srvctl status nodeapps

VIP rac19cdb01-vip is enabled

VIP rac19cdb01-vip is running on node: rac19cdb01

VIP rac19cdb02-vip is enabled

VIP rac19cdb02-vip is running on node: rac19cdb02

Network is enabled

Network is running on node: rac19cdb01

Network is running on node: rac19cdb02

GSD is disabled

GSD is not running on node: rac19cdb01

GSD is not running on node: rac19cdb02

ONS is enabled

ONS daemon is running on node: rac19cdb01

ONS daemon is running on node: rac19cdb02

[grid@rac19cdb01 ~]$

2) ASM Status : 

[grid@rac19cdb01 ~]$ srvctl status asm

ASM is running on rac19cdb02,rac19cdb01

[grid@rac19cdb01 ~]$ srvctl status asm -n rac19cdb01

ASM is running on rac19cdb01

[grid@rac19cdb01 ~]$ srvctl status asm -n rac19cdb02

ASM is running on rac19cdb02

[grid@rac19cdb01 ~]$

3) Database Status:

[grid@rac19cdb01 ~]$ srvctl status database -d racdb

Instance racdb1 is running on node rac19cdb01

Instance racdb2 is running on node rac19cdb02

[grid@rac19cdb01 ~]$ srvctl status instance -d racdb -i racdb1

Instance racdb1 is running on node rac19cdb01

[grid@rac19cdb01 ~]$ srvctl status instance -d racdb -i racdb2

Instance racdb2 is running on node rac19cdb02

[grid@rac19cdb01 ~]$

4) CRS Status:

[grid@rac19cdb01 ~]$ crsctl check crs

CRS-4638: Oracle High Availability Services is online

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

[grid@rac19cdb01 ~]$

5) Cluster Status:

[grid@rac19cdb01 ~]$ crsctl check cluster

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

[grid@rac19cdb01 ~]$

6) RAC High Availability Services Status:

[grid@rac19cdb01 ~]$ crsctl check has

CRS-4638: Oracle High Availability Services is online

[grid@rac19cdb01 ~]$

7) Database Services Status : 

[grid@rac19cdb01 ~]$ srvctl status service -d racdb

Service racdb_service is running on instance(s) racdb1,racdb2

[grid@rac19cdb01 ~]$

8) Listener Status: 

[grid@rac19cdb01 ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): rac19cdb02,rac19cdb01

[grid@rac19cdb01 ~]$

9) SCAN VIP Status : 

[grid@rac19cdb01 ~]$ srvctl status scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node rac19cdb02

SCAN VIP scan2 is enabled

SCAN VIP scan2 is running on node rac19cdb01

SCAN VIP scan3 is enabled

SCAN VIP scan3 is running on node rac19cdb01

[grid@rac19cdb01 ~]$

10) Scan Listener Status : 

[grid@rac19cdb01 ~]$ srvctl status scan_listener

SCAN Listener LISTENER_SCAN1 is enabled

SCAN listener LISTENER_SCAN1 is running on node rac19cdb02

SCAN Listener LISTENER_SCAN2 is enabled

SCAN listener LISTENER_SCAN2 is running on node rac19cdb01

SCAN Listener LISTENER_SCAN3 is enabled

SCAN listener LISTENER_SCAN3 is running on node rac19cdb01

[grid@rac19cdb01 ~]$

11) Server Status : 

[grid@rac19cdb01 ~]$ srvctl status server -n rac19cdb01 -a

Server name: rac19cdb01

Server state: ONLINE

Server active pools: Generic ora.racdb ora.racdb_racdb_service

Server state details:

[grid@rac19cdb01 ~]$ srvctl status server -n rac19cdb02 -a

Server name: rac19cdb02

Server state: ONLINE

Server active pools: Generic ora.racdb ora.racdb_racdb_service

Server state details:

[grid@rac19cdb01 ~]$

12)CVU Status: 

[grid@rac19cdb01 ~]$ srvctl status cvu

CVU is enabled and running on node rac19cdb01

[grid@rac19cdb01 ~]$

13) GNS Status :  ( As root user)

[root@rac19cdb01 ~]#/u01/app/oracle/product/19.0.0/grid/bin/srvctl status gns

PRCS-1065 : GNS is not configured.

[root@rac19cdb01 ~]#

14) Serverpool Details : 

[grid@rac19cdb01 ~]$ srvctl status srvpool

Server pool name: Free

Active servers count: 0

Server pool name: Generic

Active servers count: 2

[grid@rac19cdb01 ~]$

15) Cluster Interconnect Details : 

[grid@rac19cdb01 ~]$ oifcfg getif

eth0  192.168.1.0  global  public

eth1  192.168.50.0  global  cluster_interconnect

16) OCR Checks:

[grid@rac19cdb01 ~]$ ocrcheck

Status of Oracle Cluster Registry is as follows :

         Version                  :          3

         Total space (kbytes)     :     262120

         Used space (kbytes)      :       3224

         Available space (kbytes) :     258896

         ID                       : 1449084471

         Device/File Name         :  +OCR_VOTE

                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check bypassed due to non-privileged user

[grid@rac19cdb01 ~]$

17) OCR Backups:

[grid@rac19cdb01 ~]$ ocrconfig -showbackup

rac19cdb01     2013/09/23 11:46:41    /u01/app/oracle/product/19.0.0/grid/cdata/orrcdbdv-clstr/backup00.ocr

rac19cdb01     2013/09/23 04:19:26    /u01/app/oracle/product/19.0.0/grid/cdata/orrcdbdv-clstr/backup01.ocr

rac19cdb01     2013/09/23 00:19:25    /u01/app/oracle/product/19.0.0/grid/cdata/orrcdbdv-clstr/backup02.ocr

rac19cdb01     2013/09/22 08:19:24    /u01/app/oracle/product/19.0.0/grid/cdata/orrcdbdv-clstr/day.ocr

rac19cdb01     2013/09/10 08:18:54    /u01/app/oracle/product/19.0.0/grid/cdata/orrcdbdv-clstr/week.ocr

PROT-25: Manual backups for the Oracle Cluster Registry are not available

[grid@rac19cdb01 ~]$

18) Voting Disk Status: 

[grid@rac19cdb01 ~]$ crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

 1. ONLINE   9bc0828570854fa5bff3221500a1fc63 (ORCL:CRSVOL1) [OCR_VOTE]

Located 1 voting disk(s).

[grid@rac19cdb01 ~]$

19) Node apps config details : 

[grid@rac19cdb01 ~]$ srvctl config nodeapps  -a -g -s

Network exists: 1/192.168.1.0/255.255.255.0/eth0, type static

VIP exists: /rac19cdb01-vip/192.168.1.73/192.168.1.0/255.255.255.0/eth0, hosting node rac19cdb01

VIP exists: /rac19cdb02-vip/192.168.1.74/192.168.1.0/255.255.255.0/eth0, hosting node rac19cdb02

GSD exists

ONS exists: Local port 6100, remote port 6200, EM port 2016

[grid@rac19cdb01 ~]$

20) Diskgroups Status:

[grid@rac19cdb01 ~]$ crs_stat -t | grep -i dg

ora....DATA.dg ora....up.type ONLINE    ONLINE    rac19cdb01

ora.FLASH.dg   ora....up.type ONLINE    ONLINE    rac19cdb01

ora....VOTE.dg ora....up.type ONLINE    ONLINE    rac19cdb01

[grid@rac19cdb01 ~]$

CRSCTL Commands

Oracle CRSCTL Commands List
CRSCTL utility allows you to administer cluster resources. Here are few quick commands to help you administer Oracle RAC cluster!
Check Cluster Status 
Check Cluster Nodes 
Stop Grid Cluster 
Start Grid Cluster 

Check Cluster Status

Status of upper & lower stack

./crsctl check crs

Status of upper stack

./crsctl check cluster

Cluster status on all nodes

./crsctl check cluster -all

Cluster status on specific node

./crsctl check cluster -n rac2

Check Cluster Nodes

Check cluster services in table format

./crsctl status resource -t

Checking status of clusterware nodes / services

./crsctl status server -f

Check cluster nodes

olsnodes -n

oraracn1        1

oraracn2        2

Stop Grid Cluster

Stop HAS on current node

./crsctl stop has

Stop HAS on remote node

./crsctl stop has –n rac2

Stop entire cluster on all nodes

./crsctl stop cluster -all

Stop cluster ( CRS + HAS ) on remote node

./crsctl stop cluster –n rac2 

Start Grid Cluster

Start HAS on current node

./crsctl start has 

Start HAS on remote node

./crsctl start has –n rac2

Start entire cluster on all nodes

./crsctl start cluster –all

Start cluster(CRS + HAS) on remote node

./crsctl start cluster –n rac2

ENABLE – DISABLE CLUSTER AUTO START

crsctl enable has

crsctl disable has

Back up and recover Oracle Database on an Azure Linux VM by using Azure Files

Back up and recover Oracle Database on an Azure Linux VM by using Azure Files - Azure Virtual Machines | Microsoft Learn

RMAN Backup Script

## Mohamed Fowjil

## RMAN Database backup

#!/bin/bash
# Configuration
ORACLE_HOME=/u01/app/oracle/product/19c/db_1
ORACLE_SID=DBSPRD
RMAN_LOG_DIR=/home/oracle/logs
RMAN_BACKUP_BASE_DIR=/BACKUP/DBSPRD/
##EMAIL_RECIPIENT="fowjil@abc.ae"
BACKUP_TYPE=$1
DATE_FORMAT=$(date +%Y%m%d)
CURRENT_BACKUP_DIR="$RMAN_BACKUP_BASE_DIR/$DATE_FORMAT"
##LOG_FILE="$RMAN_LOG_DIR/rman_backup_${DATE_FORMAT}.log"
LOG_FILE="$RMAN_LOG_DIR/rman_backup_${BACKUP_TYPE}_${DATE_FORMAT}.log"
PARALLELISM=6
MAXPIECESIZE=25G

# Export Oracle environment variables
export ORACLE_HOME ORACLE_SID
# Validate backup type
if [[ "$BACKUP_TYPE" != "full" && "$BACKUP_TYPE" != "INC0" && "$BACKUP_TYPE" != "INC1" && "$BACKUP_TYPE" != "archivelog" ]]; then
    echo "Invalid backup type specified. Use 'full', 'incremental', or 'archivelog'."
    exit 1
fi
# Create necessary directories if they don't exist
mkdir -p $RMAN_LOG_DIR $CURRENT_BACKUP_DIR
# Function to send email
send_email() {
    SUBJECT=$1
    BODY=$2
    echo -e "$BODY" | mailx -s "$SUBJECT" $EMAIL_RECIPIENT
 }
# Function to perform RMAN backup based on type
perform_rman_backup() {
    case $BACKUP_TYPE in
        full)
            BACKUP_CMD="BACKUP DATABASE TAG 'FULL BACKUP'; BACKUP ARCHIVELOG ALL FORMAT '${CURRENT_BACKUP_DIR}/ARC_%d_%Y%M%D_%U.bkp' DELETE ALL INPUT;"
            ;;
        INC0)
            BACKUP_CMD="BACKUP INCREMENTAL LEVEL 0 DATABASE TAG 'INC0 BACKUP'; BACKUP ARCHIVELOG ALL FORMAT '${CURRENT_BACKUP_DIR}/ARC_%d_%Y%M%D_%U.bkp' DELETE ALL INPUT; "
            ;;
        INC1)
            BACKUP_CMD="BACKUP INCREMENTAL LEVEL 1 DATABASE TAG 'INC1 BACKUP'; BACKUP ARCHIVELOG ALL FORMAT '${CURRENT_BACKUP_DIR}/ARC_%d_%Y%M%D_%U.bkp' DELETE ALL INPUT; "
            ;;
        archivelog)
            BACKUP_CMD="BACKUP ARCHIVELOG ALL FORMAT '${CURRENT_BACKUP_DIR}/ARC_%d_%Y%M%D_%U.bkp' DELETE ALL INPUT;"
            ;;
    esac
    $ORACLE_HOME/bin/rman target / <<EOF > $LOG_FILE
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE DEVICE TYPE DISK PARALLELISM $PARALLELISM;
RUN {
    ALLOCATE CHANNEL C1 TYPE DISK FORMAT '${CURRENT_BACKUP_DIR}/%d_%Y%M%D_%U.bkp' MAXPIECESIZE ${MAXPIECESIZE};
    ALLOCATE CHANNEL C2 TYPE DISK FORMAT '${CURRENT_BACKUP_DIR}/%d_%Y%M%D_%U.bkp' MAXPIECESIZE ${MAXPIECESIZE};
    ALLOCATE CHANNEL C3 TYPE DISK FORMAT '${CURRENT_BACKUP_DIR}/%d_%Y%M%D_%U.bkp' MAXPIECESIZE ${MAXPIECESIZE};
    ALLOCATE CHANNEL C4 TYPE DISK FORMAT '${CURRENT_BACKUP_DIR}/%d_%Y%M%D_%U.bkp' MAXPIECESIZE ${MAXPIECESIZE};
    ALLOCATE CHANNEL C5 TYPE DISK FORMAT '${CURRENT_BACKUP_DIR}/%d_%Y%M%D_%U.bkp' MAXPIECESIZE ${MAXPIECESIZE};
    ALLOCATE CHANNEL C6 TYPE DISK FORMAT '${CURRENT_BACKUP_DIR}/%d_%Y%M%D_%U.bkp' MAXPIECESIZE ${MAXPIECESIZE};
        CROSSCHECK BACKUP;
        CROSSCHECK ARCHIVELOG ALL;
        SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
        $BACKUP_CMD
        BACKUP FORMAT '${CURRENT_BACKUP_DIR}/ctrlfile_%d_%Y%M%D_%U.bkp' CURRENT CONTROLFILE;
        BACKUP SPFILE FORMAT '${CURRENT_BACKUP_DIR}/spfile_%d_%Y%M%D_%U.bkp' ;
        REPORT OBSOLETE;
        DELETE NOPROMPT OBSOLETE;
    RELEASE CHANNEL C1 ;
    RELEASE CHANNEL C2 ;
    RELEASE CHANNEL C3 ;
    RELEASE CHANNEL C4 ;
    RELEASE CHANNEL C5 ;
    RELEASE CHANNEL C6 ;
}
EOF
}
# Perform the backup
perform_rman_backup
# Function to delete old backups
cleanup_old_empty_dir() {
    find $RMAN_BACKUP_BASE_DIR -maxdepth 1 -type d -empty -delete;
}
# Check RMAN backup status
if grep -q "ORA-" $LOG_FILE; then
##    send_email "RMAN Backup Failed" "RMAN $BACKUP_TYPE backup failed. Check the log file for details: $LOG_FILE"
    exit 1
else
 ##   send_email "RMAN Backup Successful" "RMAN $BACKUP_TYPE backup completed successfully. Check the log file for details: $LOG_FILE"
        # Delete old backups empty directories if current backup is successful
    cleanup_old_empty_dir
fi

-------------------------------------------------------------------------------------------------------------

Usage:

sh rman_backup.sh full

sh rman_backup.sh archivelog