What is ora 19502?
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
How do you resolve Ora in 19502?
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 a 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 👇:
One thought on “ORA-19502 Solutions”