ADSM-L

ADSM Restore of Oracle File

1999-09-29 15:55:13
Subject: ADSM Restore of Oracle File
From: Steve Cartacki <cartacs AT PJM DOT COM>
Date: Wed, 29 Sep 1999 15:55:13 -0400
ADSM'ers........RMAN having problems restoring an Oracle OPS (v 8) archivelog
from ADSM.  The file is active/available and on tape ( I have queried the ADSM
database and located the file).   Below is the RMAN script and also part of what
RMAN returns.  Below that is what is logged in the 'sbtio' file
............Running ADSM Server 3.1.2.13 on NT 4.0 sp4.  Help!  Thanks !!

                RMAN> run {
                2> allocate channel t2 type 'SBT_TAPE' ;
                3> restore archivelog from logseq 739 until logseq 740 thread 1;
                4> release channel t2;
                5> }

                RMAN-08510: archivelog thread=1 sequence=739
                RMAN-08022: channel t2: restoring archivelog
                RMAN-08510: archivelog thread=1 sequence=740
                RMAN-03026: error recovery releasing channel resources
                RMAN-08031: released channel: t2
                RMAN-00569: ================error message stack
follows================
                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 t2
                RMAN-10032: unhandled exception during execution of job step 1:
ORA-06512: at line 74
                RMAN-10035: exception raised in RPC: ORA-19624: operation
failed, retry possible

                ORA-19507: failed to retrieve sequential file,
handle="PIW_al_376840938_189_1", parms=""
                ORA-27002: function called with invalid device structure
                OSD-00000: Message 0 not found;  product=RDBMS80; facility=SOSD
(OS 7000)
                ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 922
                RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE


sbtio

(52) OBK-sbt:<09/29/1999:14:04:34> odsmSess():  # of dsmInit retries = 1
(52) OBK-sbt:<09/29/1999:14:04:34> queryObj():  ANS1302E (RC2)  No objects on
server match query
(52) OBK-sbt:<09/29/1999:14:04:35> sbtopen():  ANS1302E (RC2)   No objects on
server match query





Steve Cartacki
LAN Systems Support
PJM Interconnection, LLC
<Prev in Thread] Current Thread [Next in Thread>
  • ADSM Restore of Oracle File, Steve Cartacki <=