Data Protector on OpenVMS + intergration with ORACLE

[Jiri Koutnik]

I have installed Cell Manager on Windows server. Client is VMS server, db is ORACLE. Iam able to backup just filesystem, but the problem is Integration DP with Oracle, I mean backup db ORACLE using RMAN to tape devices !!! I was told, it should worked, but no success for me. Even worse I have no documentation of DP for Open VMS ! Can anyone help me to solve this ?
VMS - 7.3-2
ORACLE 9.2.0.5
DP - 5.50-74

thanx Jiri

[ASHOK KUMAR_8]

Hello Jiri,

Document for Oracle integration is available
in following path...

SYS$SYSROOT:[SYSHLP]DPA0550.RELEASE_NOTES
and also please find the same ....
******************************************
Configuring the ORACLE 9i Integration Agent

This patch contains by default the files for ORACLE 9i integration.

Before you can use the Oracle Integration Agent user have to modify
OMNI$ROOT:[LOG]LOGIN.COM accordingly.

User needs to modify location of the orauser.com and oratab. files
provided by the ORACLE
For Example:
$PIPE @DKA0:[ORACLE]orauser.com > NLA0:
Suppose orauser.com present in DKC0:[ORACLE9i],
then change above statement to
$PIPE @DKC0:[ORACLE9i]orauser.com > NLA0:

$DEFINE /NOLOG/JOB ORATAB_LOC
DKA0:[ORACLE]oratab.

Suppose oratab. present in DKC0:[ORACLE9i],
then change above statement to
$DEFINE /NOLOG/JOB ORATAB_LOC
DKC0:[ORACLE9i]oratab.


Note:If you are running MA and DP Oracle agents on the same openVMS system,

Then modify group ID of omniadmin user as DBA using MCR AUTHORIZE utility.

Execute OMNI$ROOT:[LOG]login.com .
********************************************


Please describe the detail problem with error so, I can provide you more help on this.

Thanks,
Ashok

[Jiri Koutnik]

Hello,

I tried to go through the doc you provided me for OpenVMS, started again DP gui, but still I was not able to perform Backup operation. I enclosed error message and also snapshot of DP gui.
thanx for any hint.

Jiri

error message:
It is not possible to connect to Oracle DB server !
It is possible that Oracle DB Server is not running or command "svrmgrl" doesnt exist in the /bin directory on the Oracle host.

but we use Oracle version 9.2.0.5 so :-)))

[ASHOK KUMAR_8]

From the error it seems to be problem with Oracle configuration,not with DP-Integration.
By the way you are using supported version - Oracle version 9.2.0.5 .

Please follow the following steps.
1) To verify Oracle rman ?

execute the following command.

RMAN>run
{
allocate channel d1 type disk;
backup tablespace system;
release channel d1;
}

2) To verify Oracle integration with DP ?

execute the following command. after modifying and executing "login.com" as suggested in previous mail.

RMAN> run
{
allocate channel 'dummy' type 'SBT_TAPE' parms="SBT_LIBRARY=DP_SBT";
release channel 'dummy';
}

Note : For more information you can refer DP ORACLE_INTEGRATION.pdf document.

Section: Configuring the Oracle Server
- Page number 30
Please follow the similar steps as mention for UNIX.


Thanks,
Ashok

[ASHOK KUMAR_8]

I adding one more point:---

Before executing
RMAN>run
{
allocate channel 'dummy' type 'SBT_TAPE'
parms="SBT_LIBRARY=DP_SBT";
release channel 'dummy';
}

Please make sure that the following line should be uncommented from the login.com
- Means DP_SBT should be point to correct
sharable.

DEFINE /NOLOG /SYSTEM DP_SBT
SYS$SHARE:LIBOBK2SHR32.EXE

Thanks
Ashok

[Jiri Koutnik]

RMAN> run {
2> allocate channel 'dummy' type 'SBT_TAPE' parms="SBT_LIBRARY=DP_SBT";
3> release channel 'dummy';
4> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on dummy channel at 02/28/2006 17:27:17
ORA-03113: end-of-file on communication channel

RMAN> exit

I tried several times to LOGON and LOGOFF, but still no success at all. I performed those steps localy on the VMS client, is this correct ? thanx Jiri

[benghezal zakaria]

hello,

i m just searching for dataprotectior for openvms
i have IA server running DP5.5 and i want integrate open vms client ALPHA OpenVMS 7.3.2,

can you please insure me where can i find the DP SofWare

Regards

[Jiri Koutnik]

Hello,

you can find SW here:

http://h18006.www1.hp.com/products/storage/software/dataprotector/index.html

patches are available on www.itrc.com
search for example for DPWIN_00182

best regards,
jiri

[ASHOK KUMAR_8]

Hello Jir,

Now you know the problem area, first of all this command should work fine
then only you can try for Backup.


Please find the result in my environment.

***********************************************************************

ORACLE>$ rman catalog rman/rman@CAT target sys/sys123@TEST

Recovery Manager: Release 9.2.0.5.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: TEST (DBID=1878002656)
connected to recovery catalog database

RMAN> run
2> {
3> allocate channel d1 type disk;
4> backup tablespace system;
5> release channel d1;
6> }
allocated channel: d1
channel d1: sid=18 devtype=DISK

Starting backup at 01-MAR-06
channel d1: starting full datafile backupset
channel d1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00001 name=DKA400:[ORACLE9I.ORADATA.TEST]SYSTEM01.DBF
channel d1: starting piece 1 at 01-MAR-06
channel d1: finished piece 1 at 01-MAR-06
piece handle=DKA400:[ORACLE9I.ORADATA.TEST]4NHCS0PG_1_1. comment=NONE
channel d1: backup set complete, elapsed time: 00:00:46
Finished backup at 01-MAR-06

released channel: d1

RMAN> run
2> {
3> allocate channel 'dummy' type 'SBT_TAPE' parms="SBT_LIBRARY=DP_SBT";
4> release channel 'dummy';
5> }
allocated channel: dummy
channel dummy: sid=18 devtype=SBT_TAPE
channel dummy: Data Protector A.05.50/OpenVMS A.05.50 (74)

released channel: dummy

RMAN> exit

Recovery Manager complete.
ORACLE>$
ORACLE>$ sh log DP_SBT
"DP_SBT" = "SYS$SHARE:LIBOBK2SHR32.EXE" (LNM$SYSTEM_TABLE)

*********************************************************************************


From the error in your environment :::::::

RMAN-03009: failure of allocate command on dummy channel at 02/28/2006 17:27:17
ORA-03113: end-of-file on communication channel

This could be a very small issue with Oracle environment.

like :---
* May be the Target and Catalog database is not running in archive mode.
* May be with ORATAB_LOC .and editing with omni$root:[log]login.com file.
* etc etc !!!!!!!!!!



Benghezal :

You can download latest DP on

http://wtec.cup.hp.com/~wtec_ss/patches/default.htm

and for Open VMS Alpha directly from the

http://wtec.cup.hp.com/patches-bin/parse/patches-info?Patch=DPWIN_00182


Thanks,
Ashok.

[ASHOK KUMAR_8]

Hi Benghezal,

Sorry for the wrong link.. please check with the following link to download DP for Open VMS.

Additional information about this patch and the patch download are available at the
HP OpenView support website:
http://openview.hp.com/sso/ecare/getsupportdoc?docid=DPWIN_00182

Regards,
Ashok