5 Replies Latest reply: Nov 14, 2008 8:49 AM by 670503 RSS

    ORA-27067 Error while restoring database using RMAN

    668928
      Hi All,

      I am trying to restore the backups from my production database to an other server. I was able to restore the spfile and control files but at the step where I restore the datafiles I get the following error:

      RMAN-03002: failure of restore command at 11/03/2008 14:28:16
      ORA-19587: error occurred reading 0 bytes at block number 1
      ORA-27091: skgfqio: unable to queue I/O
      ORA-27067: skgfdisp: size of buffer is invalid

      The OS and the Oracle version on the source server (on which the backups were taken) and the target server (the backups being restored to) are the same. They both are running SUNOS 5.9 and Oracle 9.2. I

      Below are what were reported in the trace files:

      Unix process pid: 12359, image: oracle@ (TNS V1-V3)

      *** SESSION ID:(13.1) 2008-11-03 15:23:26.265
      *** 2008-11-03 15:23:26.275
      corrupt block 1 found during reading backup piece,file=/xxx/xxx/36jucqpe_1_1.bak, corr_type=1
      dump corrupted block
      2F11600 00020000 00000001 00000000 00000101 [................]
      2F11610 00000000 00000000 00000000 00000000 [................]
      Repeat 6 times
      *** 2008-11-03 16:19:29.778
      corrupt block 1 found during reading backup piece,file=/xxx/xxx/36jucqpe_1_1.bak, corr_type=1
      dump corrupted block
      3211C00 00020000 00000001 00000000 00000101 [................]
      3211C10 00000000 00000000 00000000 00000000 [................]
      Repeat 6 times



      Redo thread mounted by this instance: 0 <none>
      Oracle process number: 14
      Unix process pid: 12194, image: oracle@ (TNS V1-V3)

      *** SESSION ID:(11.3) 2008-11-03 14:09:42.986
      (blkno = 0x88, size = 276, max = 1, in-use = 1, last-recid= 0)
      (blkno = 0x89, size = 56, max = 145, in-use = 1, last-recid= 1)


      *** 2008-11-03 15:16:40.960
      *** SESSION ID:(13.1) 2008-11-03 15:16:40.951
      =====================
      PARSING IN CURSOR #2 len=68 dep=0 uid=0 oct=42 lid=0 tim=172140509128 hv=287842151 ad='35cd9364'
      alter session set events '10046 trace name context forever, level 8'
      END OF STMT
      EXEC #2:c=0,e=250,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=172140509103
      WAIT #2: nam='SQL*Net message to client' ela= 8 p1=1650815232 p2=1 p3=0
      *** 2008-11-03 15:17:18.666
      WAIT #2: nam='SQL*Net message from client' ela= 36822299 p1=1650815232 p2=1 p3=0
      =====================
      PARSE ERROR #2:len=50 dep=0 uid=0 oct=3 lid=0 tim=172177341974 err=1219
      select /*+ FULL(t) */ count(*) from sys.source$ t
      WAIT #2: nam='SQL*Net break/reset to client' ela= 61 p1=1650815232 p2=1 p3=0
      WAIT #2: nam='SQL*Net break/reset to client' ela= 279 p1=1650815232 p2=0 p3=0
      WAIT #2: nam='SQL*Net message to client' ela= 5 p1=1650815232 p2=1 p3=0



      Unix process pid: 12156, image: oracle@ (TNS V1-V3)

      *** SESSION ID:(11.3) 2008-11-03 14:09:08.687
      Archiving is disabled
      Archiving is disabled


      Can anyone help me resolve this error?

      Thanks,
      Ashok