Home » RDBMS Server » Backup & Recovery » BACKUP problam??? (Oracle 10g, Windows Server 2003)
BACKUP problam??? [message #434330] Tue, 08 December 2009 13:08 Go to next message
kkxenon
Messages: 9
Registered: August 2009
Location: dd
Junior Member

Oracle 10g, Windows Server 2003

I do FULL database backup with RMAN:

**********************************************
run {
BACKUP AS BACKUPSET DATABASE FORMAT 'D:\ORA_BACKUP\DF_%d_%u_%s_%T' INCLUDE CURRENT CONTROLFILE;
crosscheck archivelog all;
delete expired archivelog all;
BACKUP AS BACKUPSET ARCHIVELOG ALL FORMAT 'D:\ORA_BACKUP\arch_%d_%u_%s_%T';
crosscheck archivelog all;
delete expired archivelog all;
BACKUP AS BACKUPSET CURRENT CONTROLFILE FORMAT 'D:\ORA_BACKUP\controlfile_%d_%u_%s_%T';
CROSSCHECK BACKUP;
DELETE NOPROMPT OBSOLETE;
DELETE NOPROMPT EXPIRED BACKUP;
}

**************************************************
From yesterday I have problems:

******************************************************
Starting backup at 07-DEC-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=231 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
channel ORA_DISK_1: starting piece 1 at 07-DEC-09
input datafile fno=00013 name=...
...
...
input datafile fno=00009 name=....
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

O/S-Error: (OS 112) There is not enough space on the disk.

ORA-27072: File I/O error
ORA-19502: write error on file "'D:\ORA_BACKUP \DF_........._20091207", blockno 1932964 (blocksize=8192)
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/07/2009 18:05:01
RMAN-00571: ===========================================================
OSD-04008: WriteFile() failure, unable to write to file

*********************************************


My backup is around 105GB and Ddisc is 120GB.

I have 15GB free space, why I get this error.

Because I don't have another larger disk how can I store backup files on two different discs???
Re: BACKUP problam??? [message #434331 is a reply to message #434330] Tue, 08 December 2009 13:16 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
asked & answered
http://forums.oracle.com/forums/thread.jspa?threadID=998076&tstart=0
Previous Topic: Reuse Datafile in Other Server
Next Topic: RMAN Restore stuck up
Goto Forum:
  


Current Time: Fri Nov 22 01:32:36 CST 2024