6 Replies Latest reply: Dec 28, 2012 4:33 AM by debashisora RSS

    Failed to take RMAN Backup in Windows2003 Server

    debashisora
      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
          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
            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
              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
                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
                  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
                    This is working now