Discussions
Categories
- 381.6K All Categories
- 2.1K Data
- 206 Big Data Appliance
- 1.9K Data Science
- 447.1K Databases
- 220.7K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 23 Multilingual Engine
- 515 MySQL Community Space
- 463 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 460 SQLcl
- 3.9K SQL Developer Data Modeler
- 185.8K SQL & PL/SQL
- 20.9K SQL Developer
- 292.3K Development
- 7 Developer Projects
- 119 Programming Languages
- 289.1K Development Tools
- 94 DevOps
- 3K QA/Testing
- 645.4K Java
- 20 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.8K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 14 Java Essentials
- 142 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 197 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 215 LiveLabs
- 34 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
rman error
Hi,
OS - WIN 2019
DB - 19c
I am running below rman code and getting below error, having enough space in the drive.
RMAN> run
{
backup incremental level 0 cumulative device type disk tag 'weekly_db' database;
backup device type disk tag 'db_arc' archivelog all not backed up delete all input;
allocate channel c1 device type disk;
delete noprompt obsolete device type disk;
release channel c1;
}
error
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/15/2021 14:11:41
ORA-19502: write error on file "F:\ORA19\FRA\19DEV\BKPSET\1R01ABD1_2_3", block number 25340032 (block size=8192)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 112) There is not enough space on the disk.
Thanks.
Answers
-
Hello
can you check the size of disk F: .
O/S-Error: (OS 112) There is not enough space on the disk.
regards
Thomas
-
O/S-Error: (OS 112) There is not enough space on the disk.
Looks pretty self-explanatory.
-
Like i mentioned there is enough space in the drive.
-
Like i mentioned there is enough space in the drive.
Oracle disagrees.
I see from the path of the file being written that it appears you are utilizing the FRA. If you have been doing a manual deletion of files that reside in the FRA, then oracle will not know about it and the bookkeeping on FRA usage will overstate the amount of space used.
Show us the output of the following from sqlplus:
SELECT * FROM V$RECOVERY_FILE_DEST; SELECT * FROM V$RECOVERY_AREA_USAGE;
And the following from the Windows command prompt on the db server:
dir f:
In both cases, copy the full text of the command and the full response, from the command window, and paste it as formatted text into your response.
-
As a side observation, why are you allocating a disk channel after your backups?
In reality, in your case there is no reason to explicitly allocate a channel at all.
-
getting new error -
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 06/17/2021 10:54:35
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/17/2021 10:53:05
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 67108864 bytes disk space from 75161927680 bytes limit
Recovery Manager complete.
-
getting new error -
We don't know what you changed.
And you have ingored my last request to execute some diagnostic commands and show the results.