Last week while doing restoration on target server, I faced the below error.
ORA-19870: error reading backup piece rman_TEST_cold_20903043_2200_285_1.bak
ORA-19507: failed to retrieve sequential file, handle="rman_TEST_cold_20903043_2200_285_1.bak", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
ANU2508E Wrong write state
I did the following on troubleshooting the error
"tdpoconf showenv" from the Oracle user on both target and source machine resulted the TDP on oracle level.
Then ran command "dsmc" , this will tell on the tsm client level installed on the machine.
At os lever aix command "lslpp -l tivoli.tsm*".
Below document found to be very useful to me.
http://www-01.ibm.com/support/docview.wss?uid=swg21260621
Yet the issue did not resolve to me
activated some tracing to understand why i get this error.
following is to active tracing at TDP and API levels =>
- Add the following parameters to the TDPO_OPTFILE file used for the restore :
tdpo_trace_flags orclevel0 orclevel1 orclevel2
tdpo_trace_file /tmp/tdpo.trc
- To enable tracing of the API Client, add the following parameters to the file pointed to by the DSMI_ORC_CONFIG ( this option is in the tdpo.opt ) :
traceflag service
tracefile /tmp/api.trc
However the error here is due to the configuration most likely not set correctly to provide access to the object that is stored on TSM. To verify how the object is saved on TSM, run the following select statement from a TSM Server administrative commandline (dsmsdmc):
Select * from backups where node_name='NodeNameInCaps'
Where 'NodeNameInCaps' is the nodename that was used on the production when performing the backups.
-------------------------------------------------------------------------------------
Perform a find for all the libobk.a files on the target server where you are restoring to. As the root user run the command:
find / -name libobk.a -exec ls -l {} \; and found the link for oracle 10.2 is broken
$ORACLE_HOME/db/lib/libobk.a -> /usr/tivoli/tsm/client/oracle/bin64/libobk64a
Verify if this file exist =>
/usr/tivoli/tsm/client/oracle/bin64/libobk64.a ( note it is libobk64.a not libobk64a )
If it exist ; correct the link =>
rm $ORACLE_HOME/db/lib/libobk.a
then =>
ln -s /usr/tivoli/tsm/client/oracle/bin64/libobk64.a $ORACLE_HOME/db/lib/libobk.a
Keep the same ownership and permission for this link =>
lrwxrwxrwx 1 oracle dba
Then retry the restore operation .
No comments:
Post a Comment