Backup, Recover, Import, Export, Datapump, etc
-
ricardo25ti
- Rank: Programador Pleno
- Posts: 44
- Joined: Tue, 05 Jan 2010 11:01 pm
- Location: RN
Environment information:
* Oracle version: 10g
* Operating system: Red Hat 5
Good morning everyone When trying to give a backp database in RMAN appears The following error:
Select all
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/16/2010 01:19:38
ORA-19502: write error on file "/u01/app/oracle/flash_recovery_area/ORCL/backupset/2010_03_16/o1_mf_nnndf_TAG20100316T011740_%u_.bkp", blockno 38913 (blocksize=8192)
ORA-27072: File I/O error
Linux Error: 2: No such file or directory
Additional information: 4
Additional information: 38913
Additional information: 749568
Someone know what can be?
-
elidias7
- Rank: Analista Sênior
- Posts: 153
- Joined: Thu, 01 Nov 2007 2:53 pm
- Location: Osasco
Eli Dias
Oracle Certified Professional
Good Morning.
Is the directory exist? Do you have space? Is there a file with the same name on the spot?
Hugs
-
ricardo25ti
- Rank: Programador Pleno
- Posts: 44
- Joined: Tue, 05 Jan 2010 11:01 pm
- Location: RN
No, I configured for the archive log mode to use RMAN before it was not used
-
ricardo25ti
- Rank: Programador Pleno
- Posts: 44
- Joined: Tue, 05 Jan 2010 11:01 pm
- Location: RN
yes now the file
no longer exists it is not created during the process ???
-
elidias7
- Rank: Analista Sênior
- Posts: 153
- Joined: Thu, 01 Nov 2007 2:53 pm
- Location: Osasco
Eli Dias
Oracle Certified Professional
I did not quite understand what you answered!
If the file is there, go to RMAN (if the first backup) and issue
"Delete Backup"
99] And try to do it again, if I misunderstood your response, explain Dinovo!
Hugs!
-
elidias7
- Rank: Analista Sênior
- Posts: 153
- Joined: Thu, 01 Nov 2007 2:53 pm
- Location: Osasco
Eli Dias
Oracle Certified Professional
Then!
without seeing I even think the disk space is out of the minimum possible to make the backup, because it does not have many reasons.
has already tried to back up only Archives or ControlFile to see if the error also occurs, since backupsets will be created with a smaller size.
Hugs
-
ricardo25ti
- Rank: Programador Pleno
- Posts: 44
- Joined: Tue, 05 Jan 2010 11:01 pm
- Location: RN
Dude really kkkk the bank is bigger than the space available. Thanks
-
Dulima-SP
- Rank: DBA Júnior
- Posts: 193
- Joined: Thu, 24 Jan 2008 1:56 pm
- Location: SP
Dulima
DBA Oracle Jr
Friend put this parameter in your routine !!!
helps reduce the size
-
Users browsing this forum: No registered users and 13 guests