Veritas and RMAN restores

From: Carlos Sevillano (carlos_sevillano_at_ureach.com)
Date: 10/03/03

  • Next message: Loukinas, Jeremy: "Solaris x86 Inspiron 5100" 
    Date: Fri, 3 Oct 2003 14:44:36 -0400
To: sunmanagers@sunmanagers.org

    Solaris 2.6
    Production Veritas VM3.2 and FS3.4
    COB Veritas VM2.04 and FS3.3.3 (+ patches)
    4500
    Oracle 8.17
    RMAN

    We were asked to copy 27 2GB files from our Production machine
    to COB for building a new database. RMAN cannot open the backup
    set. The 27 files match in checksum.

    Oracle seems to believe that the difference in Volumen Manager
    between Production and COB is preventing RMAN from reading the
    files. Has anyone heard about a case like this?

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
      RMAN-08089: channel dev1: specifying datafile(s) to restore
    from backup set
      RMAN-08523: restoring datafile 00001 to
    /ora8i02/oradata/ORA8I/system_01.dbf
      RMAN-08523: restoring datafile 00002 to
    /ora8i03/oradata/ORA8I/rbs_01.dbf
      RMAN-08523: restoring datafile 00016 to
      /ora8i01/oradata/ORA8I/edel01_data01.dbf
      RMAN-08523: restoring datafile 00017 to
    /ora8i02/oradata/ORA8I/rbs_02.dbf
      RMAN-03026: error recovery releasing channel resources
      RMAN-08031: released channel: dev1
      RMAN-00571:
    ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
    ===============
      RMAN-00571:
    ===========================================================
      RMAN-03002: failure during compilation of command
      RMAN-03013: command type: restore
      RMAN-03007: retryable error occurred during execution of
    command: IRESTORE
      RMAN-07004: unhandled exception during command execution on
    channel dev1
      RMAN-10035: exception raised in RPC: ORA-19587: error occurred
    reading 0 bytes at block number 1
      ORA-27091: skgfqio: unable to queue I/O
      Additional information: 2
      RMAN-10031: ORA-19624 occurred during call to
      DBMS_BACKUP_RESTORE.RESTOREBACKUPP
      IECE
      RMAN>

      ### Target database alert.log: ###
      Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
      With the Partitioning option
      JServer Release 8.1.7.4.0 - Production
      ORACLE_HOME = /ecom/app/oracle/8.1.7
      System name: SunOS
      Node name: mysystem
      Release: 5.6
      Version: Generic_105181-35
      Machine: sun4u
      Instance name: ORA8I
      Redo thread mounted by this instance: 1

      Oracle process number: 17
      Unix process pid: 16314, image: oracle@lecwec01 (TNS V1-V3)
      *** SESSION ID:(14.3) 2003-10-02 15:29:09.608
      corrupt block 1 found during reading backup piece
      Text continued in next action...

      dump corrupted block
      1A96F80 00000000 00000200 003D0900 5A5B5C5D
    [.........=..Z[\]]
      1A96F90 00000000 00000000 00000000 00000000
    [................]
      Repeat 6 times

      ### Third party Media Manager API: ###
      N/A

      Error : ORA-27091
      Contact me via : MetaLink

    ________________________________________________
    Get your own "800" number
    Voicemail, fax, email, and a lot more
    http://www.ureach.com/reg/tag
    _______________________________________________
    sunmanagers mailing list
    sunmanagers@sunmanagers.org
    http://www.sunmanagers.org/mailman/listinfo/sunmanagers

  • Next message: Loukinas, Jeremy: "Solaris x86 Inspiron 5100"

    Relevant Pages

    • Re: service name / invalid directory path
      ... command should appear thus: ... create or replace directory mydir as '/mydir/for/general/stuff'; ... Copyright 2000 Oracle Corporation. ... Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production ...
      (comp.databases.oracle.server)
    • Re: Reports Security info in url
      ... This brings up Adobe with the userid/ ... Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production ... Oracle Procedure Builder V10.1.2.0.2 - Production ... The actual command we are using is: ...
      (comp.databases.oracle.tools)
    • Re: service name / invalid directory path
      ... command should appear thus: ... David, create directory wasn't available in 8i. ... Copyright 2000 Oracle Corporation. ... Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production ...
      (comp.databases.oracle.server)
    • Re: Connecting to an Oracle database
      ... PL/SQL Release 2.3.4.0.0 - Production ... I now succeded to connect to the database in Delphi with the ADO ... > use it to connect to the database and immediately after you connect Oracle ... > conform to their programming paradigm. ...
      (borland.public.delphi.database.ado)
    • Re: Adding columns to SQL Server tables dynamically
      ... So would you recommend a production app to add columns through ado.net ... > fragmentation in Sql Server or Oracle. ... > nullable column and then updating each row. ...
      (microsoft.public.dotnet.framework.adonet)