This discussion is archived
6 Replies Latest reply: Dec 28, 2012 2:33 AM by debashisora RSS

Failed to take RMAN Backup in Windows2003 Server

debashisora Newbie
Currently Being Moderated
Hi Oracle Gurus

I am using Oracle 11.2.0.3.0 on windows2003 enterprise server 4GB RAM , with 800 GB harddisk . Our Oracle DB Data
take 360GB Disk space .
It is development DB which is clone from production . I plan to take RMAN full Back up on the same machine ( as we have plenty
space )
I want to take full back up ( Hot back up is my preference )

Here I am sowing My server memory configuration




SQL> show parameter sga ;

NAME TYPE VALUE
------------------------------------ ----------- -------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 1408M
sga_target big integer 0
SQL> show parameter pga ;

NAME TYPE VALUE
------------------------------------ ----------- -------------
pga_aggregate_target big integer 292947558
SQL> show parameter pool ;

NAME TYPE VALUE
------------------------------------ ----------- -------------
buffer_pool_keep string
buffer_pool_recycle string
global_context_pool_size string
java_pool_size big integer 160M
large_pool_size big integer 0
olap_page_pool_size big integer 0
shared_pool_reserved_size big integer 24M
shared_pool_size big integer 480M
streams_pool_size big integer 0
SQL>

SQL> select * from v$version 2 ;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for 32-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production



Here is my default RMAN configuration



RMAN configuration parameters for database with db_unique_name TEST are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 7 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'O:\Database\RMAN_BACKUP1/Backup%d_DB_%u_%s_%p' MAXPIECESIZE 300 G;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT 'N:\Database\RMAN_BACKUP2/Backup%d_DB_%u_%s_%p' MAXPIECESIZE 10 G;
CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT 'N:\Database\RMAN_BACKUP3/Backup%d_DB_%u_%s_%p' MAXPIECESIZE 30 G;
CONFIGURE CHANNEL 4 DEVICE TYPE DISK FORMAT 'K:\Database\RMAN_BACKUP4/Backup%d_DB_%u_%s_%p' MAXPIECESIZE 25 G;
CONFIGURE CHANNEL 5 DEVICE TYPE DISK FORMAT 'I:\Database\RMAN_BACKUP5/Backup%d_DB_%u_%s_%p' MAXPIECESIZE 20 G;
CONFIGURE CHANNEL 6 DEVICE TYPE DISK FORMAT 'H:\Database\RMAN_BACKUP6/Backup%d_DB_%u_%s_%p' MAXPIECESIZE 15 G;
CONFIGURE CHANNEL 7 DEVICE TYPE DISK FORMAT 'G:\Database\RMAN_BACKUP7/Backup%d_DB_%u_%s_%p' MAXPIECESIZE 20 G;
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;


I ran this script

run {
BACKUP TAG 'BACKUP_full' DATABASE ;
backup current controlfile format 'D:\Database\Control_filebackup/%d_%t_%p_%s_%c_%u.ctl';
}

and ended with error like this ,


RMAN-03009: failure of backup command on ORA_DISK_6 channel at 12/26/2012 13:09:35
ORA-04030: out of process memory when trying to allocate 524812 bytes (KSFQ heap,KSFQ Buffers)
continuing other job steps, job failed will not be re-run


I tried with increasing SGA and PGA_TARGET . As my hardisk has 8 partition so I created several chanels to distribute back up
to avoid disspace issue in particular drive . on Diskspace O is having 400GB space


Even I tried this when no one using the systems but I got same fate

Error look like PGA memory issue so in that case can we minimize PGA allocoation in RMAN so rather than failed , It will run longer time
which is acceptable to me

Or
any other solution ? ( We have OS copy back up from prod which we mounted on our dev box . But this time we
have some different requirement we need RMAN backup for Dev Data also we has to set up periodic back up )

Thanks in Advance
Debashis

Thanks
  • 1. Re: Failed to take RMAN Backup in Windows2003 Server
    Mihael Pro
    Currently Being Moderated
    It seems that you have 32-bit version of windows and so have 2Gb memory limitations for total processes of oracle database service. Try to set total memory to 1.5 Gb by using memory_target parameter.
  • 2. Re: Failed to take RMAN Backup in Windows2003 Server
    debashisora Newbie
    Currently Being Moderated
    I already tried with that , but in my configuration I can not incerease SGA more than 1.7G though I have 4G RAM , so is there any alternet wait to control process memory consumption of RMAN ?
  • 3. Re: Failed to take RMAN Backup in Windows2003 Server
    mseberg Guru
    Currently Being Moderated
    Hello;

    I would refer to this Microsoft document on large memory Support :

    http://support.microsoft.com/kb/283037

    Best Regards

    mseberg
  • 4. Re: Failed to take RMAN Backup in Windows2003 Server
    debashisora Newbie
    Currently Being Moderated
    Hi
    I chabged the boot.ini file and increase mem_max_target = 3 GB and mem_target=2500MB and reset SGA and PGA
    setting to 0 . Now It seems RMAN backup is fine , here is the log

    RMAN>
    Starting backup at 27-DEC-12
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=292 device type=DISK
    allocated channel: ORA_DISK_2
    channel ORA_DISK_2: SID=392 device type=DISK
    allocated channel: ORA_DISK_3
    channel ORA_DISK_3: SID=488 device type=DISK
    allocated channel: ORA_DISK_4
    channel ORA_DISK_4: SID=586 device type=DISK
    allocated channel: ORA_DISK_5
    channel ORA_DISK_5: SID=683 device type=DISK
    allocated channel: ORA_DISK_6
    channel ORA_DISK_6: SID=4 device type=DISK
    allocated channel: ORA_DISK_7
    channel ORA_DISK_7: SID=99 device type=DISK
    channel ORA_DISK_1: starting incremental level 0 datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    input datafile file number=00021 name=E:\DATABASE\TEST\CUSTIDX2TEST.ORA
    input datafile file number=00285 name=I:\DATABASE\TEST\IDX32TEST.ORA
    .
    .
    .
    input datafile file number=00013 name=K:\DATABASE\TEST\EQPIDX1TEST.ORA
    input datafile file number=00015 name=I:\DATABASE\TEST\XFACEIDX1TEST.ORA
    channel ORA_DISK_1: starting piece 1 at 27-DEC-12
    channel ORA_DISK_2: starting incremental level 0 datafile backup set
    channel ORA_DISK_2: specifying datafile(s) in backup set
    input datafile file number=00025 name=E:\DATABASE\TEST\UNDO1TEST.ORA
    .
    .
    .
    input datafile file number=00286 name=D:\DATABASE\RMAN\RMAN01.DBF
    input datafile file number=00009 name=F:\DATABASE\TEST\XFACEUSR1TEST.ORA
    input datafile file number=00014 name=I:\DATABASE\TEST\IDX1TEST.ORA
    channel ORA_DISK_2: starting piece 1 at 27-DEC-12
    channel ORA_DISK_3: starting incremental level 0 datafile backup set
    channel ORA_DISK_3: specifying datafile(s) in backup set
    input datafile file number=00005 name=J:\DATABASE\TEST\CUSTUSR1TEST.ORA
    input datafile file number=00011 name=E:\DATABASE\TEST\CUSTIDX1TEST.ORA
    .
    .
    .
    input datafile file number=00210 name=E:\DATABASE\TEST\SHIPIDX36TEST.ORA
    input datafile file number=00217 name=M:\DATABASE\TEST\SHIPUSR30TEST.ORA
    input datafile file number=00224 name=E:\DATABASE\TEST\SHIPIDX38TEST.ORA
    input datafile file number=00231 name=E:\DATABASE\TEST\SHIPIDX39TEST.ORA
    input datafile file number=00238 name=K:\DATABASE\TEST\EDIIDX21TEST.ORA
    input datafile file number=00245 name=J:\DATABASE\TEST\EDIUSR21TEST.ORA
    input datafile file number=00253 name=J:\DATABASE\TEST\EDIUSR23TEST.ORA
    input datafile file number=00260 name=E:\DATABASE\TEST\SHIPIDX42TEST.ORA
    input datafile file number=00267 name=F:\DATABASE\TEST\USR48TEST.ORA
    input datafile file number=00274 name=M:\DATABASE\TEST\SHIPUSR36TEST.ORA
    input datafile file number=00281 name=M:\DATABASE\TEST\SHIPUSR37TEST.ORA
    input datafile file number=00002 name=D:\DATABASE\TEST\RBS1TEST.ORA
    channel ORA_DISK_6: starting piece 1 at 27-DEC-12
    channel ORA_DISK_7: starting incremental level 0 datafile backup set
    channel ORA_DISK_7: specifying datafile(s) in backup set
    input datafile file number=00006 name=E:\DATABASE\TEST\SHIPIDX3TEST.ORA
    input datafile file number=00276 name=E:\DATABASE\TEST\SHIPIDX45TEST.ORA
    input datafile file number=00283 name=J:\DATABASE\TEST\EDIUSR28TEST.ORA
    channel ORA_DISK_7: starting piece 1 at 27-DEC-12
    channel ORA_DISK_2: finished piece 1 at 27-DEC-12
    piece handle=N:\DATABASE\RMAN_BACKUP2\BACKUPTEST_DB_2ENTU9GN_78_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_2: starting piece 2 at 27-DEC-12
    channel ORA_DISK_2: finished piece 2 at 27-DEC-12
    piece handle=N:\DATABASE\RMAN_BACKUP2\BACKUPTEST_DB_2ENTU9GN_78_2 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_2: starting piece 3 at 27-DEC-12
    channel ORA_DISK_6: finished piece 1 at 27-DEC-12
    piece handle=H:\DATABASE\RMAN_BACKUP6\BACKUPTEST_DB_2INTU9P4_82_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_6: starting piece 2 at 27-DEC-12
    channel ORA_DISK_5: finished piece 1 at 27-DEC-12
    piece handle=I:\DATABASE\RMAN_BACKUP5\BACKUPTEST_DB_2HNTU9LI_81_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_5: starting piece 2 at 27-DEC-12
    RMAN-03009: failure of backup command on ORA_DISK_2 channel at 12/27/2012 18:43:36
    ORA-19502: write error on file "N:\DATABASE\RMAN_BACKUP2\BACKUPTEST_DB_2ENTU9GN_78_3", block number 813568 (block size=8192)
    ORA-27072: File I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 112) There is not enough space on the disk.
    channel ORA_DISK_2 disabled, job failed on it will be run on another channel
    channel ORA_DISK_4: finished piece 1 at 27-DEC-12
    piece handle=K:\DATABASE\RMAN_BACKUP4\BACKUPTEST_DB_2GNTU9IM_80_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_4: starting piece 2 at 27-DEC-12
    channel ORA_DISK_7: finished piece 1 at 27-DEC-12
    piece handle=G:\DATABASE\RMAN_BACKUP7\BACKUPTEST_DB_2JNTU9TS_83_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_7: starting piece 2 at 27-DEC-12
    channel ORA_DISK_3: finished piece 1 at 27-DEC-12
    piece handle=M:\DATABASE\RMAN_BACKUP3\BACKUPTEST_DB_2FNTU9H8_79_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_3: starting piece 2 at 27-DEC-12
    channel ORA_DISK_1: finished piece 1 at 27-DEC-12
    piece handle=O:\DATABASE\RMAN_BACKUP1\BACKUPTEST_DB_2DNTU9GM_77_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:41:09
    channel ORA_DISK_1: starting incremental level 0 datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    input datafile file number=00025 name=E:\DATABASE\TEST\UNDO1TEST.ORA

    input datafile file number=00004 name=G:\DATABASE\TEST\TLS1TEST.ORA
    input datafile file number=00286 name=D:\DATABASE\RMAN\RMAN01.DBF
    input datafile file number=00009 name=F:\DATABASE\TEST\XFACEUSR1TEST.ORA
    input datafile file number=00014 name=I:\DATABASE\TEST\IDX1TEST.ORA
    channel ORA_DISK_1: starting piece 1 at 27-DEC-12
    RMAN-03009: failure of backup command on ORA_DISK_6 channel at 12/27/2012 18:53:56
    ORA-19502: write error on file "H:\DATABASE\RMAN_BACKUP6\BACKUPTEST_DB_2INTU9P4_82_2", block number 1399424 (block size=8192)
    ORA-27072: File I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 112) There is not enough space on the disk.
    channel ORA_DISK_6 disabled, job failed on it will be run on another channel
    RMAN-03009: failure of backup command on ORA_DISK_7 channel at 12/27/2012 18:53:57
    ORA-19502: write error on file "G:\DATABASE\RMAN_BACKUP7\BACKUPTEST_DB_2JNTU9TS_83_2", block number 432768 (block size=8192)
    ORA-27072: File I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 112) There is not enough space on the disk.
    channel ORA_DISK_7 disabled, job failed on it will be run on another channel
    RMAN-03009: failure of backup command on ORA_DISK_4 channel at 12/27/2012 18:54:53
    ORA-19502: write error on file "K:\DATABASE\RMAN_BACKUP4\BACKUPTEST_DB_2GNTU9IM_80_2", block number 1266560 (block size=8192)
    ORA-27072: File I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 112) There is not enough space on the disk.
    channel ORA_DISK_4 disabled, job failed on it will be run on another channel
    RMAN-03009: failure of backup command on ORA_DISK_5 channel at 12/27/2012 18:54:53
    ORA-19502: write error on file "I:\DATABASE\RMAN_BACKUP5\BACKUPTEST_DB_2HNTU9LI_81_2", block number 1611520 (block size=8192)
    ORA-27072: File I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 112) There is not enough space on the disk.
    channel ORA_DISK_5 disabled, job failed on it will be run on another channel
    channel ORA_DISK_3: finished piece 2 at 27-DEC-12
    piece handle=M:\DATABASE\RMAN_BACKUP3\BACKUPTEST_DB_2FNTU9H8_79_2 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_3: backup set complete, elapsed time: 00:43:54
    channel ORA_DISK_3: starting incremental level 0 datafile backup set
    channel ORA_DISK_3: specifying datafile(s) in backup set
    input datafile file number=00251 name=J:\DATABASE\TEST\CUSTUSR9TEST.ORA
    input datafile file number=00280 name=I:\DATABASE\TEST\IDX31TEST.ORA
    input datafile file number=00007 name=M:\DATABASE\TEST\EQPUSR1TEST.ORA
    channel ORA_DISK_1: starting piece 1 at 27-DEC-12
    channel ORA_DISK_1: finished piece 1 at 27-DEC-12
    piece handle=O:\DATABASE\RMAN_BACKUP1\BACKUPTEST_DB_2MNTUCFS_86_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:04:55
    channel ORA_DISK_1: starting incremental level 0 datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    input datafile file number=00079 name=F:\DATABASE\TEST\USR102TEST.ORA
    input datafile file number=00275 name=I:\DATABASE\TEST\IDX30TEST.ORA
    input datafile file number=00282 name=E:\DATABASE\TEST\SHIPIDX46TEST.ORA
    input datafile file number=00008 name=F:\DATABASE\TEST\USR1TEST.ORA
    channel ORA_DISK_1: starting piece 1 at 27-DEC-12
    channel ORA_DISK_1: finished piece 1 at 27-DEC-12
    piece handle=O:\DATABASE\RMAN_BACKUP1\BACKUPTEST_DB_2NNTUCP6_87_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:05:05
    channel ORA_DISK_1: starting incremental level 0 datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    input datafile file number=00001 name=G:\DATABASE\TEST\SYSTEST.ORA
    input datafile file number=00016 name=F:\DATABASE\TEST\USR3TEST.ORA
    input datafile file number=00217 name=M:\DATABASE\TEST\SHIPUSR30TEST.ORA
    input datafile file number=00224 name=E:\DATABASE\TEST\SHIPIDX38TEST.ORA
    input datafile file number=00231 name=E:\DATABASE\TEST\SHIPIDX39TEST.ORA
    input datafile file number=00238 name=K:\DATABASE\TEST\EDIIDX21TEST.ORA
    input datafile file number=00245 name=J:\DATABASE\TEST\EDIUSR21TEST.ORA
    input datafile file number=00253 name=J:\DATABASE\TEST\EDIUSR23TEST.ORA
    input datafile file number=00260 name=E:\DATABASE\TEST\SHIPIDX42TEST.ORA
    input datafile file number=00267 name=F:\DATABASE\TEST\USR48TEST.ORA
    input datafile file number=00274 name=M:\DATABASE\TEST\SHIPUSR36TEST.ORA
    input datafile file number=00281 name=M:\DATABASE\TEST\SHIPUSR37TEST.ORA
    input datafile file number=00002 name=D:\DATABASE\TEST\RBS1TEST.ORA
    channel ORA_DISK_1: starting piece 1 at 27-DEC-12
    channel ORA_DISK_1: finished piece 1 at 27-DEC-12
    piece handle=O:\DATABASE\RMAN_BACKUP1\BACKUPTEST_DB_2ONTUD2P_88_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:05:06
    channel ORA_DISK_1: starting incremental level 0 datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    input datafile file number=00006 name=E:\DATABASE\TEST\SHIPIDX3TEST.ORA
    input datafile file number=00010 name=F:\DATABASE\TEST\USR2TEST.ORA
    input datafile file number=00276 name=E:\DATABASE\TEST\SHIPIDX45TEST.ORA
    input datafile file number=00283 name=J:\DATABASE\TEST\EDIUSR28TEST.ORA
    channel ORA_DISK_1: starting piece 1 at 27-DEC-12
    channel ORA_DISK_1: finished piece 1 at 27-DEC-12
    piece handle=O:\DATABASE\RMAN_BACKUP1\BACKUPTEST_DB_2PNTUDCD_89_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:05:05
    channel ORA_DISK_1: starting incremental level 0 datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    including current control file in backup set
    channel ORA_DISK_1: starting piece 1 at 27-DEC-12
    channel ORA_DISK_1: finished piece 1 at 27-DEC-12
    piece handle=O:\DATABASE\RMAN_BACKUP1\BACKUPTEST_DB_2QNTUDM0_90_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    channel ORA_DISK_1: starting incremental level 0 datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    including current SPFILE in backup set
    channel ORA_DISK_1: starting piece 1 at 27-DEC-12
    channel ORA_DISK_1: finished piece 1 at 27-DEC-12
    piece handle=O:\DATABASE\RMAN_BACKUP1\BACKUPTEST_DB_2RNTUDM4_91_1 tag=BACKUP_1 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    Finished backup at 27-DEC-12

    Could you please tell me above channel error is ignorable
  • 5. Re: Failed to take RMAN Backup in Windows2003 Server
    P.Forstmann Guru
    Currently Being Moderated
    In this backup run you can ignore channel errors because RMAN has used other channels and your backup run has completed successfully. However you should simplify your backup scripts to avoid such errors and use less backup destinations where you are sure you have enough disk space.

    Make sure that archived redo logs are also backed up.
  • 6. Re: Failed to take RMAN Backup in Windows2003 Server
    debashisora Newbie
    Currently Being Moderated
    This is working now

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points