Rman

Backup, Recover, Import, Export, Datapump, etc
Post Reply
ricardo25ti
Rank: Programador Pleno
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
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
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

The bank is in Archivelog right?

The archives were not erased in the hand?
ricardo25ti
Rank: Programador Pleno
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
Rank: Programador Pleno
Posts: 44
Joined: Tue, 05 Jan 2010 11:01 pm
Location: RN

Yes, the directory exists yes
ricardo25ti
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 44
Joined: Tue, 05 Jan 2010 11:01 pm
Location: RN

yes now the file

Select all

o1_mf_nnndf_TAG20100316T011740_%u_.bkp
no longer exists it is not created during the process ???
elidias7
Rank: Analista Sênior
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!
ricardo25ti
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 44
Joined: Tue, 05 Jan 2010 11:01 pm
Location: RN

is the first plus backup has no file there
elidias7
Rank: Analista Sênior
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
Rank: Programador Pleno
Posts: 44
Joined: Tue, 05 Jan 2010 11:01 pm
Location: RN

I think poe is space even tried: backup tablespace example and was
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

In Linux see the space available,

later

Select all

du -sh data
to see how much has the Datafiles, to have an idea,
ricardo25ti
Rank: Programador Pleno
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
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

Select all

backup as compressed backupset database
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 13 guests