ORA-19502 Solutions

Today I’m just performing the database full backup and suddenly I’m facing an ORA-19502 error message. I didn’t understand why this error came because I did not see any ora error in the alert file. I’m suffering on google but didn’t get any solution then I just checked my mount points and found there is insufficient space in the backup mount point. Read the below step for ORA-19502 Solutions.

Read: TNS-00583: Valid Node Checking: Unable To Parse Configuration

Then i decided to share this error with you on my blog.

Read: ORA-00031: session marked for kill Solution

subscribe YouTube Channel

ORA-19502 solution step

Taking oracle database error using below command.

RMAN> backup as backupset database format '/u01/BACKUP/db_%d';

Error:

Starting backup at 08-JUN-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/gaming/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/gaming/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/gaming/undotbs01.dbf
input datafile file number=00006 name=/u01/dharma01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/gaming/und01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/gaming/users01.dbf
channel ORA_DISK_1: starting piece 1 at 08-JUN-21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/08/2021 20:40:09
ORA-19502: write error on file "/u01/BACKUP/db_FRTGAME", block number 10880 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 10880
Additional information: 778240

Check mount point using df -h command.

$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1              25G   23G   87M 100% /
tmpfs                 1.9G  1.2G  766M  61% /dev/shm

Solution:

Make some space in respected mount point and then run database backup again.

Read: Load oracleasm module

ORA-19502 Solutions completed.

If the article is useful for you, please write your fillings in the comment box or chat with me on 👇:

1 thought on “ORA-19502 Solutions”

Leave a Comment

%d bloggers like this:
Enable Notifications    OK No thanks