|
Re: tdpoconf error --- ANS0236E (RC2032)
2003-03-12 12:04:47
Neil ,
There are three dsm.sys files on AIX system . I deleted password access
-generate entries from three dsm.sys files
and was able to change password using tdpconf ,Was able to backup and
restore ORACLE 9.2DB using RMAN /TDP.
I have mailed you some of the questions off-line .
f5n75 />uname -a
AIX f5n75 3 4 000195544C00
f5n75 />find / -name dsm.sys -print
/usr/tivoli/tsm/client/api/bin/dsm.sys
/usr/tivoli/tsm/client/api/bin64/dsm.sys
/usr/tivoli/tsm/client/ba/bin/dsm.sys
f5n75 />tdpoconf password
-tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/t>
***************************************************************
* Tivoli Data Protection for Oracle Utility *
* Password file initialization/update program *
* ROOT privilege needed to update value *
***************************************************************
Please enter current password:
Please enter new password:
Please reenter new password for verification:
ANU0260I Password successfully changed.
Was able to backup and restore Oracle Database 9.2.0.2.0 sucesfully using TDP
2.2.1
Recovery Manager: Release 9.2.0.2.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: RMANTST (DBID=1620760367)
connected to recovery catalog database
allocated channel: t1
channel t1: sid=16 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 2.2.1.0
Starting backup at 11-MAR-03
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input controlfilecopy
name=/d01/app/oracle/admin/rmantst/rman/backup/ctl_back_rm
antst.ctl
channel t1: starting piece 1 at 11-MAR-03
channel t1: finished piece 1 at 11-MAR-03
piece handle=0iehoear_1_1 comment=API Version 2.0,MMS Version 2.2.1.0
channel t1: backup set complete, elapsed time: 00:00:01
Finished backup at 11-MAR-03
Starting backup at 11-MAR-03
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00001 name=/d12/oradata/rmantst/system01.dbf
input datafile fno=00002 name=/d12/oradata/rmantst/undotbs01.dbf
input datafile fno=00005 name=/d12/oradata/rmantst/example01.dbf
input datafile fno=00010 name=/d12/oradata/rmantst/xdb01.dbf
input datafile fno=00006 name=/d12/oradata/rmantst/indx01.dbf
input datafile fno=00009 name=/d12/oradata/rmantst/users01.dbf
input datafile fno=00003 name=/d12/oradata/rmantst/cwmlite01.dbf
input datafile fno=00004 name=/d12/oradata/rmantst/drsys01.dbf
input datafile fno=00007 name=/d12/oradata/rmantst/odm01.dbf
input datafile fno=00008 name=/d12/oradata/rmantst/tools01.dbf
channel t1: starting piece 1 at 11-MAR-03
channel t1: finished piece 1 at 11-MAR-03
piece handle=data_0jehoeat_1_1.bs comment=API Version 2.0,MMS Version
2.2.1.0
channel t1: backup set complete, elapsed time: 00:00:45
Finished backup at 11-MAR-03
sql statement: alter system archive log current
Starting backup at 11-MAR-03
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=5 recid=10 stamp=488037125
input archive log thread=1 sequence=6 recid=11 stamp=488037128
input archive log thread=1 sequence=7 recid=12 stamp=488037138
input archive log thread=1 sequence=8 recid=13 stamp=488037431
input archive log thread=1 sequence=9 recid=14 stamp=488037431
input archive log thread=1 sequence=10 recid=15 stamp=488038361
input archive log thread=1 sequence=11 recid=16 stamp=488038362
input archive log thread=1 sequence=12 recid=17 stamp=488138141
input archive log thread=1 sequence=13 recid=18 stamp=488238904
input archive log thread=1 sequence=14 recid=19 stamp=488336184
input archive log thread=1 sequence=15 recid=20 stamp=488387904
input archive log thread=1 sequence=16 recid=21 stamp=488387905
input archive log thread=1 sequence=17 recid=22 stamp=488389003
input archive log thread=1 sequence=18 recid=23 stamp=488389004
channel t1: starting piece 1 at 11-MAR-03
channel t1: finished piece 1 at 11-MAR-03
piece handle=arch_0kehoecd_1_1.bs comment=API Version 2.0,MMS Version
2.2.1.0
channel t1: backup set complete, elapsed time: 00:00:56
Finished backup at 11-MAR-03
released channel: t1
Recovery Manager complete.
Tue Mar 11 15:37:43 EST 2003
Tue Mar 11 15:37:44 EST 2003
Restored oracle database sucessfully :
6> # allocates 3 channels for disk backup
7> #
8> #
9> # allocate channel d1 type disk;
10> # allocate channel d2 type disk;
11> # allocate channel d3 type disk;
12> # setlimit channel d1 kbytes 2097150 maxopenfiles 32 readrate 200;
13> # setlimit channel d2 kbytes 2097150 maxopenfiles 32 readrate 200;
14> # setlimit channel d3 kbytes 2097150 maxopenfiles 32 readrate 200;
15>
24>
25> # Enter a date and time if it is a point in time incomplete
26> # recovery
27> # set until time '1998-11-10:17:00:00';
28> # set until time '2000-03-10:17:00:00';
29>
30> #
31> # Restore all datafiles in the database not including the controlfile
32> #
33> # restore
34> # (database);
35> restore database;
36> #
37> # Recovers all datafiles in the database
38> #
39> recover database;
40>
41> # Open database after recovery
42> # If controlfile was restored the a reselogs is necessary
43> # sql 'alter database open;
44> # sql 'alter database open resetlogs';
45>
46>
47> #
48> # Releases all of the disk channels
49> #
50> # release channel d1;
51> # release channel d2;
52> # release channel d3;
53>
54> # Release tape channels
55> release channel t1;
56>
57> }
58>
allocated channel: t1
channel t1: sid=12 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 2.2.1.0
Starting restore at 2003-03-11:16:36:58
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /d12/oradata/rmantst/system01.dbf
restoring datafile 00002 to /d12/oradata/rmantst/undotbs01.dbf
restoring datafile 00003 to /d12/oradata/rmantst/cwmlite01.dbf
restoring datafile 00004 to /d12/oradata/rmantst/drsys01.dbf
restoring datafile 00005 to /d12/oradata/rmantst/example01.dbf
restoring datafile 00006 to /d12/oradata/rmantst/indx01.dbf
restoring datafile 00007 to /d12/oradata/rmantst/odm01.dbf
restoring datafile 00008 to /d12/oradata/rmantst/tools01.dbf
restoring datafile 00009 to /d12/oradata/rmantst/users01.dbf
restoring datafile 00010 to /d12/oradata/rmantst/xdb01.dbf
media recovery complete
Finished recover at 2003-03-11:16:39:06
released channel: t1
Recovery Manager complete.
Thank You
Shekhar Dhotre.
Sr.Midrange Engineer.
Lend Lase , GSDC.
PH: 1+404-846-7483
Neil Rasmussen <rasmussn AT US.IBM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
03/12/2003 10:10 AM
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Re: tdpoconf error --- ANS0236E (RC2032)
I did not paste all of the original information because it gets a bit
cumbersome to read. But if you go back and look at some key things in the
'tdpoconf showenv' dump you will notice that you are specifying an options
file that exists in .../oracle/bin64 directory but you are using a 32bit
AIX TDP Oracle client, did you mean to do this? It is not mandatory, but I
would highly recommend keeping 32bit configuration files in the 32bit
client directory until you can work through these problems. What server
stanza are you using in /usr/tivoli/tsm/client/oracle/bin64/dsm.opt? If
you prefer we can take this off line too.
Also, on another note: do not worry about what client code versions you
see in the TDP Oracle trace, that has nothing to do with the BA Client you
have on your machine.
------------------------------
Date: Tue, 11 Mar 2003 14:14:51 -0500
From: shekhar Dhotre <Shekhar.Dhotre AT LENDLEASEREI DOT COM>
Subject: tdpoconf error --- ANS0236E (RC2032)
Hi All ,
I have double checked dsm.sys file and other opt file ,no
ASSWORDACCESS=generate .. Still I get the following error. has anyone seen
this error before ??
tdpoconf password
-tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
Regards,
Neil Rasmussen
Software Development
TDP for Oracle
rasmussn AT us.ibm DOT com
|
|
|
