Restore to different NODE through RMAN using TDP

[mujib]

Hi All,



OS: AIX 4.3.3

TDP: 2.2

Oracle DB Version: 8.1.7

RMAN Catalog DB version: 9.2



We have done RMAN backup on Node A and now we want to restore on NODE B. Here are the steps which we have done:



On Node A

Granted access to Node B



On Node B

Changed node name to A in : /usr/tivoli/tsm/client/oracle/bin/tdpo.opt, dsm.opt, dsm.sys

Changed the Server Name in /usr/tivoli/tsm/client/api/bin/dsm.sys

We also regenerated Password file. Still we are not able to restore files and we get the following error:



RMAN> run {

2> allocate channel t1 type 'sbt_tape' parms

3> 'ENV=(TDPO_OWNER=oraoem TDPO_FS=/adsmorc/)';

4> restore controlfile to '/ora10/orasys/bmcstg/control01.ctl';

5> }



RMAN-03022: compiling command: allocate

RMAN-03023: executing command: allocate

RMAN-08030: allocated channel: t1

RMAN-08500: channel t1: sid=18 devtype=SBT_TAPE

RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 2.2.0.0



RMAN-03022: compiling command: restore



RMAN-03022: compiling command: IRESTORE

RMAN-03023: executing command: IRESTORE

RMAN-08016: channel t1: starting datafile backupset restore

RMAN-08502: set_count=2 set_stamp=475518791 creation_time=17-OCT-02

RMAN-08021: channel t1: restoring controlfile

RMAN-08505: output filename=/ora10/orasys/bmcstg/control01.ctl

RMAN-03026: error recovery releasing channel resources

RMAN-08031: released channel: t1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure during compilation of command

RMAN-03013: command type: restore

RMAN-03007: retryable error occurred during execution of command: IRESTORE

RMAN-07004: unhandled exception during command execution on channel t1

RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file, handle="df_475518791_2_1", parms=""

ORA-27029: skgfrtrv: sbtrestore returned error

RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE





Please let me know if anyone has any idea.



Thanks



Mujib Khan

 

[psz]

We have a user who is trying to figure out how to do this too. If anyone has figured out how to do this, I'd appreciate hearing how to do it. Thanks! ..Paul



<TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font class="pn-sub">Quote:</font><HR></TD></TR><TR><TD><FONT class="pn-sub"><BLOCKQUOTE>Hi All,



OS: AIX 4.3.3

TDP: 2.2

Oracle DB Version: 8.1.7

RMAN Catalog DB version: 9.2



We have done RMAN backup on Node A and now we want to restore on NODE B. Here are the steps which we have done:



On Node A

Granted access to Node B



On Node B

Changed node name to A in : /usr/tivoli/tsm/client/oracle/bin/tdpo.opt, dsm.opt, dsm.sys

Changed the Server Name in /usr/tivoli/tsm/client/api/bin/dsm.sys

We also regenerated Password file. Still we are not able to restore files and we get the following error:



RMAN> run {

2> allocate channel t1 type 'sbt_tape' parms

3> 'ENV=(TDPO_OWNER=oraoem TDPO_FS=/adsmorc/)';

4> restore controlfile to '/ora10/orasys/bmcstg/control01.ctl';

5> }



RMAN-03022: compiling command: allocate

RMAN-03023: executing command: allocate

RMAN-08030: allocated channel: t1

RMAN-08500: channel t1: sid=18 devtype=SBT_TAPE

RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 2.2.0.0



RMAN-03022: compiling command: restore



RMAN-03022: compiling command: IRESTORE

RMAN-03023: executing command: IRESTORE

RMAN-08016: channel t1: starting datafile backupset restore

RMAN-08502: set_count=2 set_stamp=475518791 creation_time=17-OCT-02

RMAN-08021: channel t1: restoring controlfile

RMAN-08505: output filename=/ora10/orasys/bmcstg/control01.ctl

RMAN-03026: error recovery releasing channel resources

RMAN-08031: released channel: t1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure during compilation of command

RMAN-03013: command type: restore

RMAN-03007: retryable error occurred during execution of command: IRESTORE

RMAN-07004: unhandled exception during command execution on channel t1

RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file, handle="df_475518791_2_1", parms=""

ORA-27029: skgfrtrv: sbtrestore returned error

RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE





Please let me know if anyone has any idea.



Thanks



Mujib Khan</BLOCKQUOTE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE>

 

[DavidWhite]

Hi

We haven't done this as yet but here are my thoughts...

Have you got a Node A passwd file on NodeB.

ie a TDPO.nodeA on NodeB

Here are the restore steps used with ADSM maybe they will be helpful.



1. On Node B you will have to use DSMO_NODE=Node A env variable.

2. Before restoring, on Node B you'll need to generate the password file with env var DSMO_NODE=Node A set.

3. This will create a password file ADSMO.Node A on Node B.

Then you can start restoring the data from Node A to Node B.

4. Setup DSMO_NODE, ensure password file ADSMO.(nodename) is right.

5. Make sure backuped files existing in ADSM server is accessible. The adsm password file has to be regenerated on Node B with the DSMO_NODE set to Node A



Good Luck! Let me know how you go.

 

[pwatkins]

I'm wondering if you found the solutions to your problem. If so , could share your solutions with me, please? Our envrionemnent is very close to your setup and I'm facing the exact error messages.



Thanks in advance.



[email protected]