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.
Then I decided to share this error with you on my blog.
subscribe YouTube Channel
ORA-19502 solution step
Taking oracle database error using below command.
RMAN> backup as backupset database format '/u01/BACKUP/db_%d';
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
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 👇: