ORA-27063: skgfospo: number of bytes read/written is incorrect
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: ORA-27063: skgfospo: number of bytes read/written is incorrect

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    ORA-27063: skgfospo: number of bytes read/written is incorrect

    hi,

    I'm trying to do a hot backup to disk using RMAN and I'm keep getting following error messages. I know I have enough space on disk and I also find a not from metalink saying that I need to specify set limit channel d1 kbytes 2024800 (as an examplem) and still does not work and getting same error messages.

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03009: failure of backup command on c0 channel at 05/25/2005 14:03:29
    ORA-19502: write error on file "bk_698_1_559231200", blockno 132353
    (blocksize=8192)
    ORA-27063: skgfospo: number of bytes read/written is incorrect
    SVR4 Error: 28: No space left on device
    Additional information: -1
    Additional information: 1048576

    Anyone has any idea?

    following is my RMAN script that I ran:
    $RMAN target $TARGET_CONNECT_STR catalog rman_${ORACLE_SID%[1-9]}/rman_${ORACLE_SID%[1-9]}@rmancat msglog $RMAN_LOG_FILE append << EOF
    RUN {
    allocate channel c0 type disk format '/a03/app/oracle/admin/backup/';
    allocate channel c1 type disk format '/a03/app/oracle/admin/backup/';
    allocate channel c2 type disk format '/a03/app/oracle/admin/backup/';
    allocate channel c3 type disk format '/a03/app/oracle/admin/backup/';
    allocate channel c4 type disk format '/a03/app/oracle/admin/backup/';
    allocate channel c5 type disk format '/a01/app/oracle/arch/backup/';
    allocate channel c6 type disk format '/a01/app/oracle/arch/backup/';
    allocate channel c7 type disk format '/a01/app/oracle/arch/backup/';
    allocate channel c8 type disk format '/a01/app/oracle/arch/backup/';
    allocate channel c9 type disk format '/a01/app/oracle/arch/backup/';
    #
    #
    setlimit channel c0 kbytes 5194300;
    setlimit channel c1 kbytes 5194300;
    setlimit channel c2 kbytes 5194300;
    setlimit channel c3 kbytes 5194300;
    setlimit channel c4 kbytes 5194300;
    setlimit channel c5 kbytes 5194300;
    setlimit channel c6 kbytes 5194300;
    setlimit channel c7 kbytes 5194300;
    setlimit channel c8 kbytes 5194300;
    setlimit channel c9 kbytes 5194300;

    BACKUP
    $BACKUP_TYPE
    # SKIP INACCESSIBLE
    TAG hot_db_bk_level0
    #FILESPERSET 5
    #FILESPERSET 20
    setsize 20971520
    # recommended format
    FORMAT 'bk_%s_%p_%t'
    DATABASE;
    sql 'alter system archive log current';
    release channel c0;
    release channel c1;
    release channel c2;
    release channel c3;
    release channel c4;
    release channel c5;
    release channel c6;
    release channel c7;
    release channel c8;
    release channel c9;

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    show me the output from:

    ls-l /a03/app/oracle/admin/backup/
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2001
    Posts
    243
    that directory is empty. Did not generate anything.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Ah, I see now. I bet your bk* files are in your $ORACLE_HOME/dbs directory, right? The format you want to use is:
    allocate channel c0 type disk format '/a03/app/oracle/admin/backup/bk%U';
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jun 2001
    Posts
    243
    I specified file like $path/bk%U'; and still getting same error messages.

  6. #6
    Join Date
    Jun 2001
    Posts
    243
    and yes you're right....bk_, al_, and cntrl_.. all were in $ORACLE_HOME/dbs directory.

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    OK, here's your problem. You are allocating channels, but then specifying a single format. Try:
    Code:
    allocate channel c0 type disk format '/a03/app/oracle/admin/backup/bk0%U';
    setlimit channel c0 kbytes 2097150;
    
    allocate channel c1 type disk format '/a03/app/oracle/admin/backup/bk1%U';
    setlimit channel c1 kbytes 2097150;
    
    allocate channel c2 type disk format '/a03/app/oracle/admin/backup/bk2%U';
    setlimit channel c2 kbytes 2097150;
    
    allocate channel c3 type disk format '/a03/app/oracle/admin/backup/bk3%U';
    setlimit channel c3 kbytes 2097150;
    
    
    BACKUP
    $BACKUP_TYPE
    TAG hot_db_bk_level0
    DATABASE;
    
    release channel c0;
    release channel c1;
    release channel c2;
    release channel c3;
    Last edited by marist89; 05-26-2005 at 01:21 PM.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Jun 2001
    Posts
    243
    it works now. format was the problem. what's the query to find out SCN and time so that I can do PITTR?

Posting Permissions

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



Click Here to Expand Forum to Full Width