Oracle Agent help
2006-11-22 11:34:59
Admittedly I have very limited knowledge on this subject so I hope you
can pardon my ignorance while I ask some questions. This is something we
(the dbas) have not used for some years and are only now trying to get
working again. The TSM server is on AIX 5.3 TSM 5.3.3.0, and this
particular client is at 5.3.4 on HP-UX Itanium. The agent level they
installed is 5.2.3.0 from the looks of the info they sent me, yet they
say they just got it from IBM so I am confused since I have 5.3.3. for
them if they would have just talked to me. Perhaps the best thing to do
is upgrade but I think it will not fix the errors since it is more than
likely some sort of config problem to start. The dbas here now have no
experience with this product, and although he says hes configured it
properly some things stick out at me as being wrong based on some of the
email I have saved from the group.
To start I have created a management class and node specifically for
this client. It is not in its own domain so it is not the default
class, and I dont think that is a problem, however I am guessing the
tdpo.opt needs this information, see below, but they have that section
commented out and the names listed are not the one I created. Should
this be fixed and is there something else missing from the file. The
dsm.opt for the client only has the servername and the dsm.sys a bit
more but not sure if those entries are relevant so they are not listed
here.
Hopefully someone can decipher all of this and help me out.
DSMI_ORC_CONFIG /opt/tivoli/tsm/client/api/bin64/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/logs
TDPO_FS oracle10gdb
TDPO_NODE o-cppsdbd1
TDPO_OWNER oracle
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64
TDPO_DATE_FMT 1
TDPO_NUM_FMT 1
TDPO_TIME_FMT 1
* TDPO_MGMT_CLASS_2 mgmtclass2
* TDPO_MGMT_CLASS_3 mgmtclass3
* TDPO_MGMT_CLASS_4 mgmtclass4
They say they ran a backup, and from a TSM perspective what I see is one
filespace, oracle10gdb, within TSM which seems to be 4 files.
RMAN> run
2> {
3> ALLOCATE CHANNEL t1 TYPE 'sbt_tape' parms
4> 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
5> backup backupset all;
6> }
allocated channel: t1
channel t1: sid=504 instance=PSHDMO1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.2.3.0
Starting backup at 06-NOV-06
input backupset count=125 stamp=605788428 creation_time=06-NOV-06
channel t1: starting piece 1 at 06-NOV-06
channel t1: backup piece
/d1/app/oracle/product/cur_rev/db/dbs/3ti1n68c_1_1
piece handle=3ti1n68c_1_2 comment=API Version 2.0,MMS Version 5.2.3.0
channel t1: finished piece 1 at 06-NOV-06
channel t1: backup set complete, elapsed time: 00:00:25
Finished backup at 06-NOV-06
released channel: t1
A restore however failed and below is most of what was in the logs. I
have cut out numerous data file lines between 5 and 123 as they were
all the same.
RMAN> run
2> {
3> ALLOCATE CHANNEL t1 TYPE 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> RESTORE DATABASE VALIDATE;
5> }
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: sid=500 instance=PSHDMO1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.2.3.0
Starting restore at 10-NOV-06
data file 5 will be created automatically during restore operation
data file 123 will be created automatically during restore operation
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/10/2006 16:58:09
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
Thanks and Happy Thanksgiving to all who celebrate,
Geoff Gill
TSM Administrator
PeopleSoft Sr. Systems Administrator
SAIC M/S-G1b
(858)826-4062
Email: geoffrey.l.gill AT saic DOT com
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Oracle Agent help,
Gill, Geoffrey L. <=
|
|
|