The RMAN script for the backup says "backup backupset all;"....I have not 
had time to research this command (to see what it is supposed to do) but I 
do not think you are backing up your whole Oracle database with this 
command. Try doing a "backup database" and then run your restore script.


Regards,

Neil Rasmussen
Software Development
Data Protection for Oracle
rasmussn AT us.ibm DOT com




"Gill, Geoffrey L." <GEOFFREY.L.GILL AT SAIC DOT COM> 
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
11/22/2006 08:19 AM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Oracle Agent help






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