ADSM-L

ANS1302E on TDP Oracle restore

2004-03-24 11:58:06
Subject: ANS1302E on TDP Oracle restore
From: Bill Boyer <bill.boyer AT VERIZON DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 24 Mar 2004 11:56:19 -0500
TSM Server 5.2.2.1 on AIX 5.2
TSM Client 5.2.2.1 on Solaris V8
TSM For Databases Oracle 5.2.2.0
Oracle 8.1.7.4


I have a client trying to restore a database into a new instance using the
RMAN DUPLICATE command. The channel gets allocated, but then the command
fails with ANS1302E no objects match query. The object in question is on the
server. If we login with "dsmc" and do a QUERY BACKUP on the Oracle
filespace, the objects show and as active.

Here's the RMAN error:
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve
sequential fi
le, handle="df_521549451_206_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: ANS1302E (RC2)    No objects on server match query


and this is the output of the QUERY BACKUP:
             Size      Backup Date        Mgmt Class A/I File
             ----      -----------        ---------- --- ----
API 12,378,112 KB  03/20/04   23:42:46    DEFAULT     A
/oratest//df_521336569_135_1
API 12,378,112 KB  03/20/04   23:48:42    DEFAULT     A
/oratest//df_521336924_136_1
API 12,374,016 KB  03/20/04   23:54:17    DEFAULT     A
/oratest//df_521337260_137_1
API 12,374,016 KB  03/21/04   00:00:06    DEFAULT     A
/oratest//df_521337606_139_1
API 12,374,016 KB  03/21/04   00:05:28    DEFAULT     A
/oratest//df_521337931_140_1
API 12,392,448 KB  03/21/04   23:31:09    DEFAULT     A
/oratest//df_521422269_164_1
API 12,396,544 KB  03/21/04   23:37:26    DEFAULT     A
/oratest//df_521422644_165_1
API 12,387,328 KB  03/21/04   23:43:13    DEFAULT     A
/oratest//df_521422990_166_1
API 12,391,424 KB  03/21/04   23:50:56    DEFAULT     A
/oratest//df_521423386_167_1
API 12,387,328 KB  03/22/04   00:05:28    DEFAULT     A
/oratest//df_521423906_168_1
API 12,392,448 KB  03/22/04   00:19:49    DEFAULT     A
/oratest//df_521425162_170_1
API 12,387,328 KB  03/22/04   00:25:53    DEFAULT     A
/oratest//df_521425557_171_1
API 12,392,448 KB  03/22/04   23:31:07    DEFAULT     A
/oratest//df_521508666_191_1
API 12,396,544 KB  03/22/04   23:38:12    DEFAULT     A
/oratest//df_521509091_192_1
API 12,392,448 KB  03/22/04   23:43:38    DEFAULT     A
/oratest//df_521509418_193_1
API 12,387,328 KB  03/22/04   23:49:23    DEFAULT     A
/oratest//df_521509763_194_1
API 12,392,448 KB  03/22/04   23:54:59    DEFAULT     A
/oratest//df_521510099_195_1
API 12,387,328 KB  03/23/04   00:00:34    DEFAULT     A
/oratest//df_521510434_197_1
API 12,387,328 KB  03/23/04   00:05:59    DEFAULT     A
/oratest//df_521510759_198_1
API 12,397,568 KB  03/23/04   10:50:52    DEFAULT     A
/oratest//df_521549451_206_1

My experience with RMAN is limited. Most DBA's run when you mention RMAN to
them, so we haven't had much call for TDP Oracle.

Any help on this would be appreciated!

Bill Boyer
"Life is not about how fast you run,
or how high you climb
but how well you bounce." - ??

<Prev in Thread] Current Thread [Next in Thread>