It is in fact the same machine, just different instances. The DBA was logged
in as ORATEST when he did the backups, and again as ORATEST when he
attempted the restore. I made sure they were from the same userid as I saw
some documents on IBM about not being able to delete backup objects via RMAN
and it had to do with the OWNER of the objects. As a shot-in-the-dark, the
DBA added TDPO_OWNER ORATEST to the option file and the duplicate is now
working.
Strange!
Bill Boyer
DSS, Inc.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Neil Rasmussen
Sent: Wednesday, March 24, 2004 1:05 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: ANS1302E on TDP Oracle restore
Bill,
Most likely the problem is due to the fact that your target machine is not
configured correctly - that is, from a DP for Oracle point of view.
Generally, if you configure your target machine exactly as your source the
duplicate command should work without a hitch. My method for doing this is
to copy all the options files for DP Oracle (dsm.opt, dsm.sys, tdpo.opt)
from the source machine to the target machine.
The common misconception is that the duplicate command uses the
configuration setting from the source machine when in fact it comes from
the target machine. Hope this helps.
Regards,
Neil Rasmussen
Software Development
Data Protection for Oracle
Bill Boyer <bill.boyer AT VERIZON DOT NET>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
03/24/2004 08:56 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L AT VM.MARIST DOT EDU
cc
Subject
ANS1302E on TDP Oracle restore
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." - ??
|
