Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: backup failing while using rman

Re: backup failing while using rman

From: Surya <sdpantab_at_yahoo.com>
Date: Fri, 06 Sep 2002 19:17:04 GMT
Message-ID: <Qa7e9.107786$Yb1.100185@sea-read.news.verio.net>

Solved the mystery. It was the bacupset that was the culprit, not the space as per the error. Created seperate bacup set for datafiles and archivelogs and that seems to have worked. Thanks Richard for the hint. SP
"Surya" <sdpantab_at_yahoo.com> wrote in message news:iw5e9.107783$Yb1.100214_at_sea-read.news.verio.net...
> I am. Backups set is 104 MB where as the disk have 15GB free space. Do
 you
> think if I spread out to different backup set, that would help?
> Thanks,
> SP
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:NRSd9.25963$g9.73320_at_newsfeeds.bigpond.com...
> > Hi Surya,
> >
> > I can only suggest that RMAN doesn't believe you ... ? It looks like
 you're
> > backing everything onto the one backup set, are you really really sure
 you
> > have enough space ?
> >
> > Sorry
> >
> > Richard
> > "Surya" <sdpantab_at_yahoo.com> wrote in message
> > news:OqNd9.107751$Yb1.99847_at_sea-read.news.verio.net...
> > > I'm running rman to backup test db (windows 2000 oracle 8.1.7). It
 has
 been
> > > giving "O/S-Error: (OS 112) There is not enough space on the disk."
 and
 all
> > > the other errors as given below, but the disk has still lots of space
 on
 it.
> > > Backup was working earlier and the setup is the same.
> > >
> > > RMAN> run {
> > > 2> allocate channel d1 type disk format 'b_%u_%s_%p';
> > > 3> backup
> > > 4> ( database include current controlfile );
> > > 5> backup ( archivelog all delete input );
> > > 6>release channel d1;
> > > 7> }
> > >
> > > RMAN-08031: released channel: d1
> > > RMAN-03022: compiling command: allocate
> > > RMAN-03023: executing command: allocate
> > > RMAN-08030: allocated channel: d1
> > > RMAN-08500: channel d1: sid=16 devtype=DISK
> > >
> > > RMAN-03022: compiling command: backup
> > > RMAN-03023: executing command: backup
> > > RMAN-08008: channel d1: starting full datafile backupset
> > > RMAN-08502: set_count=70 set_stamp=471784284 creation_time=SEP-05-2002
> > > 11:11AM
> > > RMAN-08010: channel d1: specifying datafile(s) in backupset
> > > RMAN-08522: input datafile fno=00002
 name=F:\ORACLE\ORADATA\GL\RBS01.DBF
> > > RMAN-08522: input datafile fno=00001
 name=F:\ORACLE\ORADATA\GL\SYSTEM01.DBF
> > > RMAN-08011: including current controlfile in backupset
> > > RMAN-08522: input datafile fno=00003
 name=F:\ORACLE\ORADATA\GL\USERS01.DBF
> > > RMAN-08522: input datafile fno=00004
 name=F:\ORACLE\ORADATA\GL\TEMP01.DBF
> > > RMAN-08522: input datafile fno=00006
 name=F:\ORACLE\ORADATA\GL\INDX01.DBF
> > > RMAN-08522: input datafile fno=00005
 name=F:\ORACLE\ORADATA\GL\TOOLS01.DBF
> > > RMAN-00571:



> > > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS


> > > RMAN-00571:


> > > RMAN-03007: retryable error occurred during execution of command:
 backup
> > > RMAN-07004: unhandled exception during command execution on channel d1
> > > RMAN-10035: exception raised in RPC: ORA-19504: failed to create file
> > > "b_26e1tm
> > > s_70_1"
> > > ORA-27044: unable to write the header block of file
> > > OSD-04008: WriteFile() failure, unable to write to file
> > > O/S-Error: (OS 112) There is not enough space on the disk.
> > > RMAN-10031: ORA-19624 occurred during call to
> > > DBMS_BACKUP_RESTORE.BACKUPPIECECR
> > > ATE
> > >
> > > Thanks,
> > > SP
> > >
> > >
> >
> >

>
> Received on Fri Sep 06 2002 - 14:17:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US