Results 1 to 10 of 10
  1. #1
    Join Date
    Sep 2003
    Posts
    5

    Unanswered: Error Message from RMAN after backup

    Hello,

    I get this message when i try to backup a imported database:

    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 tut
    RMAN-10035: exception raised in RPC: ORA-19502: write error on file "/ora_db/backup/SKR/test.bak", blockno 238593 (blocksize=512)
    ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
    Additional information: 238593
    Additional information: 1024
    Additional information: 239121
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

    The RMAN ist configured correctly because i can backup the database before importing the dumpfile. It is possible that the Dumpfile is damaged?
    Discspace free: 50 GB

    I hope someone can help me.
    Thorsten

  2. #2
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102

    Re: Error Message from RMAN after backup

    hi,

    there is a 2-GB filesize limit. (the limit is within the oracle-libraries, not the OS)
    just check if you have files larger than 2GB?
    you can split up the rman-files in pieces smaller than 2GB.
    ^/\x

  3. #3
    Join Date
    Sep 2003
    Posts
    5
    Hi,

    all files together are ~3,5 GB large, can you tell me how i can split the files with the RMAN?

    Thorsten

  4. #4
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102
    Originally posted by Thorsten
    Hi,

    all files together are ~3,5 GB large, can you tell me how i can split the files with the RMAN?

    Thorsten
    use the setsize parameter. it gives the size in KB.

    run {
    allocate channel d1 type ....
    .......
    backup database setsize = 1024;
    }
    ^/\x

  5. #5
    Join Date
    Sep 2003
    Posts
    5
    my next try is tomorrow. Thx for the help.


    RMAN-03022: compiling command: backup
    RMAN-00571: ================================================== =========
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ================================================== =========
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: backup
    RMAN-06183: datafile or datafilecopy larger than SETSIZE: file# 6 /ora_db/TEST/oradata/ptdta_01.dbf

  6. #6
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102
    just see the error-message:

    RMAN-06183: datafile or datafilecopy larger than SETSIZE: file# 6 /ora_db/TEST/oradata/ptdta_01.dbf

    RMAN seems not to be able to split datatfiles into smaller pieces for the backup.
    So I suggest to set SETSIZE not smaller than max(filesize) of your datafiles.

    A totally other way is to create a named-pipe on Linux-level and give this as target of your RMAN-backup.
    during backup you can gzip/compress/tar/split/whatever the output of this pipe.

    kr
    berx
    ^/\x

  7. #7
    Join Date
    Sep 2003
    Posts
    5
    RMAN dont split the file, the named datafile is the lastone before 2 GB is reached.

  8. #8
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102
    hi,

    I did some tests (DB: 9.2.0.3, Solaris 5.8, both 64-bit):

    SQL> select max (bytes/1024) from v$datafile;
    MAX(BYTES/1024)
    ---------------
    1048576
    SQL>

    using this RMAN-script:
    connect target /
    run {
    allocate channel d1 type disk;
    backup
    full
    setsize 1048575
    tag full_online_backup
    format '/appl/home/oracle/martin/MYTEST_t%t_s%s_p%p.DBF'
    (database);
    release channel d1;
    }
    exit;

    brings the expected error:
    RMAN-00571: ================================================== =========
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ================================================== =========
    RMAN-03002: failure of backup command at 09/25/2003 08:54:53
    RMAN-06183: datafile or datafilecopy larger than SETSIZE: file# 11 /appl/FOURTY2/u07/FOURTY2_data01.dbf

    afterwards i set the size to 1048576 and RMAN worked fine.

    I checked the files:

    du -k *.DBF
    1576 MYTEST_t505644925_s4_p1.DBF
    275200 MYTEST_t505644960_s5_p1.DBF
    297072 MYTEST_t505644995_s6_p1.DBF
    463736 MYTEST_t505645022_s7_p1.DBF

    and all are smaller than 1048576 kB.


    please check with a equal testcase.
    ^/\x

  9. #9
    Join Date
    Sep 2003
    Posts
    5

    Talking

    yes, it works...but i dont understand why
    i checked the table v$datafile:
    409600 -> ok

    i set setsize=409600 -> it works but i get many backupfiles, all files are between 2MB - 70 MB large

    i set setsize=1048575 -> it works and i get files <100 MB.

    Thanks for the help

  10. #10
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102
    RMAN is using a really simple kind of compression:
    It doesn't backup unused (exactly: NEVER used) blocks.

    i _guess_ SETSIZE affects the maximum size of the _input_ stream _before_ this compression takes place. So the effectife files might be much smaller than SETSIZE.
    This is just a try of an explanation.

    kr
    berx
    ^/\x

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •