Creating ASM Disks

The ASM will be created on unformatted disk partitions.

As the root user, determine which devices can be partitioned.
# cat /proc/partitions

Create the partition for each disk. Select n for action, p for primary partition, 1 for partition number, default values for First and Last cylinder and w to write the partition table.
# fdisk /dev/sda

Configure Oracle ASM library driver. Answer default user and group as oracle and dba, y for Start Oracle ASM library driver on boot, y for Scan for Oracle ASM disks on boot.
# oracleasm configure -i

Load Oracle ASM module and mount oracleasm filesystem /dev/oracleasm.
# oracleasm init

Create ASM disk label for each disk.
# oracleasm createdisk DATA1 /dev/sda1

Check the disks are visible.
# oracleasm listdisks

Check the disks are mounted in oracleasm filesystem.
# ls -l /dev/oracleasm/disks

RMAN Catalog Backup Report

WITH bkp AS ( SELECT db_name, input_type, max(end_time) end_time FROM rman.rc_rman_backup_job_details WHERE end_time > sysdate - 1 GROUP BY input_type, db_name) SELECT b.db_name database, b.input_type, b.status, to_char(b.start_time,'DD-MON-YYYY HH24:MI') start_time, to_char(b.end_time,'DD-MON-YYYY HH24:MI') end_time, b.time_taken_display time_taken, b.output_device_type output_device, b.output_bytes_display bkp_size, b.output_bytes_per_sec_display "BKP_RATE/s" FROM rman.rc_rman_backup_job_details b, bkp a WHERE b.db_name = a.db_name and b.input_type = a.input_type and b.end_time = a.end_time ORDER BY b.input_type desc, b.db_name