archive_stage

[Former Member]

Hello,

We are getting error in back. job scheduled hourly.

Job log overview for job: LIVECACHE_OG2_ARCHIVE_STAGE / 23303304

Date Time Message text Me

29.06.2007 00:30:34 Job started

29.06.2007 00:30:34 Step 001 started

29.06.2007 00:30:34 External command: DBMCLI

29.06.2007 00:30:34 Related parameter: -d OG2 -u control,control archive_stage BACKlog AutoLog

29.06.2007 00:31:00 Failed to receive scheduling status of external program

29.06.2007 00:31:00 Job cancelled

System Details: SCM 5.0.

SCM_BASIS 700 Sp11

Livecache 7.6

Can somebody give a hint.Thanks in advance

Regards,

Tushar

[former_member229109 · Accepted solution]

Hello Tushar,

Could you please update with additional information:

-> Output of the following commands on the liveCache server:

sdbregview -l

dbmcli -d OG2 -u control,control show version

dbmcli -d OG2 -u control,control medium_getall

-> Please post the file dbm.ebp from the liveCache Rundirectory.

-> Please see the SAP notes ::

869267 FAQ: MaxDB LOG area

853135 archive_stage does not save log files

Thank you and best regards, Natalia Khlopina

[Former Member]

Hello Natalia,

Thanks for the hint.

Actually this job appeared on this system due to system copy.

I executed same external command with target rfc dest to server where OG2 Livecache instance is installed.Then it goes successfully.

Thanks for your help.I got more knowledge on BACKINT now because of you.Thanks.

Regards,

Tushar

[Former Member]

Hello Natalia,

I found out following info:

I can see from job details that, It is being executed as exeternal os command.

on host isxu310_LTB_02 having livecache OTB.

<b>1 DBMCLI Ext. command -d OG2 -u control,control archive_stage BACKlog AutoLog BATCHSCHE</b>

with executing server is being isxu310_LTB_02 ( OTB livecache)

while OG2 livecache being on mou159.

Regards,

Tushar

[former_member229109]

Hello Tushar,

1)

The dbm.ebp file of OG2 on mou159 has errors =>

Please check the '/sapdb/OG2/lcbackup/param.cfg' as parameter file for Backint for MaxDB.

Please review the documentation at

http://maxdb.sap.com/currentdoc/default.htm -> Basic Information

-> Concepts of the Database System -> Administration

-> Backing Up and Restoring -> Using Backup Tools from Other Providers

2)

"Job LIVECACHE_OG2_ARCHIVE_STAGE scheduled to run on host isxu310_LTB_02"

Please review the SAP notes:

990602 FAQ: CCMS for MaxDB/SAP liveCache technology

1001874 Incorrect status/name for database structure checks

1064213 No systems to add found in DB13C DB Scheduling Calendar

Please check information/connection settings in the DB Scheduling Calendar.

As of WebAs 7.00, the administration is carried out with transaction

DBACOCKPIT or

DB59 -> < select connection > -> < Double click or 'Assistant' >

-> Tools -> DBA Planning Calendar.

Please create OSS message to be able to logon to your system via OSS & check

how did you schedule the job LIVECACHE_OG2_ARCHIVE_STAGE.

Thank you and best regards, Natalia Khlopina

[Former Member]

Hello Natalia,

We have OG2 livecache on another box.with same version as of OTB.

( OG2 is not on the samebox as of OTB )

I have not raised the OSS message yet.

<b>But is backint able to take backup of livecache which in another host?</b>

Is there any special configuration to take backup of livecache which is on another host through backint.

<b>Following is the dbm.ebp file of OG2 which is on another host:</b>

2007-07-06 03:30:27

Setting environment variable 'TEMP' for the directory for temporary files and pipes to default ''.

Setting environment variable 'TMP' for the directory for temporary files and pipes to default ''.

Using connection to Backint for MaxDB Interface.

2007-07-06 03:30:27

Checking existence and configuration of Backint for MaxDB.

Using configuration variable 'BSI_ENV' = '/sapdb/OG2/lcbackup/apoatlas.env' as path of the configuration file of Backint for MaxDB.

Setting environment variable 'BSI_ENV' for the path of the configuration file of Backint for MaxDB to configuration value '/sapdb/OG2/lcbackup/apoatlas.env'.

Reading the Backint for MaxDB configuration file '/sapdb/OG2/lcbackup/apoatlas.env'.

Found keyword 'BACKINT' with value '/sapdb/OG2/db/bin/backint'.

Found keyword 'INPUT' with value '/tmp/backint4sapdbOG2.in'.

Found keyword 'OUTPUT' with value '/tmp/backint4sapdbOG2.out'.

Found keyword 'ERROROUTPUT' with value '/tmp/backint4sapdbOG2.err'.

Found keyword 'PARAMETERFILE' with value '/sapdb/OG2/lcbackup/param.cfg'.

Found keyword 'TIMEOUT_SUCCESS' with value '1800'.

Found keyword 'TIMEOUT_FAILURE' with value '1800'.

Finished reading of the Backint for MaxDB configuration file.

Using '/sapdb/OG2/db/bin/backint' as Backint for MaxDB program.

Using '/tmp/backint4sapdbOG2.in' as input file for Backint for MaxDB.

Using '/tmp/backint4sapdbOG2.out' as output file for Backint for MaxDB.

Using '/tmp/backint4sapdbOG2.err' as error output file for Backint for MaxDB.

Using '/sapdb/OG2/lcbackup/param.cfg' as parameter file for Backint for MaxDB.

Using '1800' seconds as timeout for Backint for MaxDB in the case of success.

Using '1800' seconds as timeout for Backint for MaxDB in the case of failure.

Using '/sapdb/data/wrk/OG2/dbm.knl' as backup history of a database to migrate.

Using '/sapdb/data/wrk/OG2/dbm.ebf' as external backup history of a database to migrate.

Checking availability of backups using backint's inquire function.

Check passed successful.

2007-07-06 03:30:27

Checking medium.

Check passed successfully.

2007-07-06 03:30:27

Preparing stage backup.

Reading backup histories.

Finished reading backup histories successfully.

Determining stage files in directory '/sapdb/OG2/lcbackup/log'.

Found directory entry '.'. It is not a stage file.

Found directory entry '..'. It is not a stage file.

Did not find any stage files.

Finished determination of stage files successfully.

Prepare passed successfully.

Nothing to do, no stage files found.

LIVECACHE_OG2_ARCHIVE_STAGE this hourly job calls backint:

Meantime I will find more details:

Thanks in advance.

Regards,

Tushar

[Former Member]

Hello All,

Any body has an idea about the failure of this job.

Please let me know your thoughts.

Thanks in advance.

Regards,

Tushar

[former_member229109]

Hello Tushar,

Please let me know how did you schedule the job LIVECACHE_OG2_ARCHIVE_STAGE.

It failed to receive scheduling status of external program to run the command

'DBMCLI -d OG2 -u control,control archive_stage BACKlog AutoLog'

Questions:

-> You provided the information < & dbm.ebp file > about the database instance OTB. Why job is trying to connect to the database OG2? Do you have the OG2 database?

-> Did you create the OSS message concerning this issue?

Thank you and best regards, Natalia Khlopina

[Former Member]

Hello Natalia,

When I executed following command through Lc10->toolsDBMCLI, I got following output:

<b>Show version:</b>

OTB>OK

SERVERDB: OTB

Kernel Version 'Kernel 7.6.01 Build 009-123-141-487'

RTE Version 'X64/HPUX 7.6.01 Build 009-123-141-487'

Console command finished (2007-07-02 04:05:59).

<b>medium_getall</b>

OTB>OK

BACKINT_ONLINE\CompleteData1 /sapdb/OTB/lcbackup/pipe1 PIPE DATA 0 8 NO NO 20061214115429 20061214115429 BACK

BACKINT_ONLINE\CompleteData2 /sapdb/OTB/lcbackup/pipe2 PIPE DATA 0 8 NO NO 20061214115503 20061214115503 BACK

AutoLog /sapdb/OTB/lcbackup/log/autolog FILE AUTO 0 8 NO NO 20061214115631 20061214115650 NONE

BACKLog /sapdb/OTB/lcbackup/pipe1 PIPE LOG 0 8 NO NO 20061214115739 20061214115739 BACK

FILEBACKUP /sapdb/OTB/lcbackup/data.cmd FILE DATA 0 8 YES NO 20070116132909 20070116132909 NONE

Regards,

Tushar

[Former Member]

Hello Natalia,

please check the output of commands given by you.

1> <b>isxu310:otbadm 22> sdbregview -l</b>

Server Utilities /sapdb/programs 7.6.01.09 64 bit valid

DB Analyzer /sapdb/programs 7.6.01.09 64 bit valid

Perl Interface /sapdb/programs 7.4.03.19 32 bit valid

PCR 7300 /sapdb/programs 7.3.00.55 valid

CPC Base /sapdb/programs 7.4.03.19 64 bit valid

PCR 7301 /sapdb/programs 7.3.01.20 valid

PCR 7500 /sapdb/programs 7.5.00.39 64 bit valid

Python Interface /sapdb/programs 7.4.03.19 32 bit valid

Webtools /sapdb/programs/web 7.4.03.19 64 bit valid

SAP Utilities /sapdb/programs 7.6.01.09 64 bit valid

APO LC APPS /sapdb/OTB/db/sap 5.00.010 64 bit valid

Redist Python /sapdb/programs 7.6.01.09 32 bit valid

Base /sapdb/programs 7.6.01.09 64 bit valid

JDBC /sapdb/programs 7.6.02.03 valid

Messages /sapdb/programs MSG 0.4211 valid

ODBC /sapdb/programs 7.6.01.09 64 bit valid

Database Kernel /sapdb/OTB/db 7.6.01.09 64 bit valid

Loader /sapdb/programs 7.6.01.09 64 bit valid

SQLDBC /sapdb/programs 7.6.01.09 64 bit valid

CPC SDK 7403 /sapdb/programs 7.4.03.19 64 bit valid

SQLDBC 76 /sapdb/programs 7.6.01.09 64 bit valid

Fastload API /sapdb/programs 7.6.01.09 64 bit valid

PCR 7403 /sapdb/programs 7.4.03.45 64 bit valid

2> <b>isxu310:otbadm 28> dbmcli -d OGT -u control,control show version</b> Error! Connection failed to node (local) for database OGT: database not found

<b>isxu310:otbadm 31> dbmcli -d OG2 -u control,control show version</b>

Error! Connection failed to node (local) for database OG2:

database not found

Livecache SID is OGT

3> <b>isxu310:otbadm 32> dbmcli -d OG2 -u control,control medium_getall</b>

Error! Connection failed to node (local) for database OG2:

database not found

<b>isxu310:otbadm 35> dbmcli -d OGT -u control,control medium_getall</b>

Error! Connection failed to node (local) for database OGT:

database not found

<b>dbm.ebp file</b>

2007-06-28 13:00:34

Setting environment variable 'TEMP' for the directory for temporary files and pipes to default ''.

Setting environment variable 'TMP' for the directory for temporary files and pipes to default ''.

Using connection to Backint for MaxDB Interface.

2007-06-28 13:00:34

Checking existence and configuration of Backint for MaxDB.

Using configuration variable 'BSI_ENV' = '/sapdb/OTB/lcbackup/apoatlas.env' as path of the configuration file of Backint for MaxDB.

Setting environment variable 'BSI_ENV' for the path of the configuration file of Backint for MaxDB to configuration value '/sapdb/OTB/lcbackup/apoatlas.env'.

Reading the Backint for MaxDB configuration file '/sapdb/OTB/lcbackup/apoatlas.env'.

Found keyword 'BACKINT' with value '/sapdb/OTB/db/bin/backint'.

Found keyword 'INPUT' with value '/tmp/backint4sapdbOTB.in'.

Found keyword 'OUTPUT' with value '/tmp/backint4sapdbOTB.out'.

Found keyword 'ERROROUTPUT' with value '/tmp/backint4sapdbOTB.err'.

Found keyword 'PARAMETERFILE' with value '/sapdb/OTB/lcbackup/param.cfg'.

Found keyword 'TIMEOUT_SUCCESS' with value '1800'.

Found keyword 'TIMEOUT_FAILURE' with value '1800'.

Finished reading of the Backint for MaxDB configuration file.

Using '/sapdb/OTB/db/bin/backint' as Backint for MaxDB program.

Using '/tmp/backint4sapdbOTB.in' as input file for Backint for MaxDB.

Using '/tmp/backint4sapdbOTB.out' as output file for Backint for MaxDB.

Using '/tmp/backint4sapdbOTB.err' as error output file for Backint for MaxDB.

Using '/sapdb/OTB/lcbackup/param.cfg' as parameter file for Backint for MaxDB.

Using '1800' seconds as timeout for Backint for MaxDB in the case of success.

Using '1800' seconds as timeout for Backint for MaxDB in the case of failure.

Using '/sapdb/data/wrk/OTB/dbm.knl' as backup history of a database to migrate.

Using '/sapdb/data/wrk/OTB/dbm.ebf' as external backup history of a database to migrate.

Checking availability of backups using backint's inquire function.

Check passed successful.

2007-06-28 13:00:34

Checking medium.

Check passed successfully.

2007-06-28 13:00:35

Preparing backup.

Setting environment variable 'BI_CALLER' to value 'DBMSRV'.

Setting environment variable 'BI_REQUEST' to value 'NEW'.

Setting environment variable 'BI_BACKUP' to value 'FULL'.

Constructed Backint for MaxDB call '/sapdb/OTB/db/bin/backint -u OTB -f backup -t file -p /sapdb/OTB/lcbackup/param.cfg -i /tmp/backint4sapdbOTB.in -c'.

Created temporary file '/tmp/backint4sapdbOTB.out' as output for Backint for MaxDB.

Created temporary file '/tmp/backint4sapdbOTB.err' as error output for Backint for MaxDB.

Writing '/sapdb/OTB/lcbackup/pipe1 #PIPE' to the input file.

Writing '/sapdb/OTB/lcbackup/pipe2 #PIPE' to the input file.

Prepare passed successfully.

2007-06-28 13:00:35

Creating pipes for data transfer.

Creating pipe '/sapdb/OTB/lcbackup/pipe1' ... Done.

Creating pipe '/sapdb/OTB/lcbackup/pipe2' ... Done.

All data transfer pipes have been created.

2007-06-28 13:00:35

Starting database action for the backup.

Requesting 'SAVE DATA QUICK TO '/sapdb/OTB/lcbackup/pipe1' PIPE,'/sapdb/OTB/lcbackup/pipe2' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'BACKINT_ONLINE'' from db-kernel.

The database is working on the request.

2007-06-28 13:00:35

Waiting until database has prepared the backup.

Asking for state of database.

2007-06-28 13:00:35 Database is still preparing the backup.

Waiting 1 second ... Done.

Asking for state of database.

2007-06-28 13:00:36 Database has finished preparation of the backup.

The database has prepared the backup successfully.

2007-06-28 13:00:36

Starting Backint for MaxDB.

Starting Backint for MaxDB process '/sapdb/OTB/db/bin/backint -u OTB -f backup -t file -p /sapdb/OTB/lcbackup/param.cfg -i /tmp/backint4sapdbOTB.in -c >>/tmp/backint4sapdbOTB.out 2>>/tmp/backint4sapdbOTB.err'.

Process was started successfully.

Backint for MaxDB has been started successfully.

2007-06-28 13:00:36

Waiting for end of the backup operation.

2007-06-28 13:00:36 The backup tool is running.

2007-06-28 13:00:36 The database is working on the request.

2007-06-28 13:00:37 The database has finished work on the request.

Receiving a reply from the database kernel.

Got the following reply from db-kernel:

SQL-Code

Date :20070628

Time :00130035

Database :OTB

Server :isxu310

KernelVersion :Kernel 7.6.01 Build 009-123-141-487

PagesTransfered :1912

PagesLeft

Volumes :2

MediaName :BACKINT_ONLINE

Location :/sapdb/OTB/lcbackup/pipe1

Label :DAT_000000007

IsConsistent :true

FirstLogPageNo :14493

DBStamp1Date :20070628

DBStamp1Time :00130035

BDPageCount :1878

DevicesUsed :2

DatabaseID :isxu310:OTB_20070625_130405

Max Used Data Page

Converter Page Count :16

2007-06-28 13:00:37 The backup tool is running.

2007-06-28 13:00:41 The backup tool is running.

2007-06-28 13:00:51 The backup tool is running.

2007-06-28 13:00:53 The backup tool process has finished work with return code 0.

The backup operation has ended.

2007-06-28 13:00:53

Filling reply buffer.

Constructed the following reply:

OK

Returncode 0

Date 20070628

Time 00130035

Server isxu310

Database OTB

Kernel Version Kernel 7.6.01 Build 009-123-141-487

Pages Transferred 1912

Pages Left 0

Volumes 2

Medianame BACKINT_ONLINE

Location /sapdb/OTB/lcbackup/pipe1

Errortext

Label DAT_000000007

Is Consistent true

First LOG Page 14493

Last LOG Page

DB Stamp 1 Date 20070628

DB Stamp 1 Time 00130035

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 1878

Devices Used 2

Database ID isxu310:OTB_20070625_130405

Max Used Data Page 0

Converter Page Count 16

Reply buffer filled.

2007-06-28 13:00:53

Updating external backup history.

Using '/sapdb/data/wrk/OTB/dbm.knl' as backup history.

Looking for DAT_000000007 with DB Stamp1 2007-06-28 13:00:35.

Found 1 Internal Backup ID. It was 4683E9330008|DAT_000000007.

Got '4683E9330008|DAT_000000007' as Internal Backup ID and '2007-06-28 13:00:35' as start date.

Using '/sapdb/data/wrk/OTB/dbm.ebf' as external backup history.

Found External Backup ID 'OTB OTB___A0F3HHG3BQ /sapdb/OTB/lcbackup/pipe1'.

Found External Backup ID 'OTB OTB___A0F3HHG3BQ /sapdb/OTB/lcbackup/pipe2'.

Wrote '4683E9330008|DAT_000000007|OTB OTB___A0F3HHG3BQ /sapdb/OTB/lcbackup/pipe1|DATA MIGRATION|2007-06-28 13:00:35|BACK|0||BACKINT_ONLINE|vftPipe|NO|0|8|M|/sapdb/OTB/lcbackup/pipe1|0|' to the external backup history.

Wrote '4683E9330008|DAT_000000007|OTB OTB___A0F3HHG3BQ /sapdb/OTB/lcbackup/pipe2|DATA MIGRATION|2007-06-28 13:00:35|BACK|0||BACKINT_ONLINE|vftPipe|NO|0|8|M|/sapdb/OTB/lcbackup/pipe2|1|' to the external backup history.

Have updated external backup history successfully.

2007-06-28 13:00:53

Making a backup of the Backup History files.

2007-06-28 13:00:53 The backup tool is not running.

Copying output of Backint for MaxDB to this file.

-

---

Begin of output of Backint for MaxDB (/tmp/backint4sapdbOTB.out)----

---

Reading parameter file /sapdb/OTB/lcbackup/param.cfg.

Using staging area /sapdb/OTB/lcbackup/file01 with a size of 104857600 bytes.

Using staging area /sapdb/OTB/lcbackup/file02 with a size of 104857600 bytes.

Using 2 file per Backint for Oracle call.

Using /opt/tivoli/tsm/tdp_r3/ora64/backint as Backint for Oracle.

Using /sapdb/OTB/lcbackup/orabackint/initOTB.utl as parameterfile of Backint for Oracle.

Using /sapdb/OTB/lcbackup/backOTB.log as history file.

Using /tmp/backint4oracleOTB.in as input of Backint for Oracle.

Using /tmp/backint4oracleOTB.out as output of Backint for Oracle.

Using /tmp/backint4oracleOTB.err as error output of Backint for Oracle.

Using a maximal delay for a Backint for Oracle call of 30 seconds.

Reading input file /tmp/backint4sapdbOTB.in.

Backing up pipe /sapdb/OTB/lcbackup/pipe1.

Backing up pipe /sapdb/OTB/lcbackup/pipe2.

Found 2 entries in the input file.

Starting the backup.

Starting pipe2file program(s).

Waiting for creation of temporary files.

2 temporary files are available for backup.

Calling Backint for Oracle at 2007-06-28 13:00:37.

Calling '/opt/tivoli/tsm/tdp_r3/ora64/backint -u OTB -f backup -t file -p /sapdb/OTB/lcbackup/orabackint/initOTB.utl -i /tmp/backint4oracleOTB.in -c' .

Backint for Oracle ended at 2007-06-28 13:00:45 with return code 0.

Backint for Oracle output:

Backint for Oracle output: Data Protection for mySAP(R)

Backint for Oracle output:

Backint for Oracle output: Interface between BR*Tools and Tivoli Storage Manager

Backint for Oracle output: - Version 5, Release 3, Modification 2.0 for HP-UX LF 64-bit -

Backint for Oracle output: Build: 275 compiled on Nov 19 2005

Backint for Oracle output: (c) Copyright IBM Corporation, 1996, 2005, All Rights Reserved.

Backint for Oracle output:

Backint for Oracle output: BKI2027I: Using TSM-API version 5.3.3.0 (compiled with 5.3.0.0).

Backint for Oracle output: BKI2000I: Successfully connected to ProLE on port tdpr3ora64.

Backint for Oracle output: BKI0005I: Start of program at: Thu Jun 28 13:00:37 2007 .

Backint for Oracle output:

Backint for Oracle output:

Backint for Oracle output: -- Parameters --

Backint for Oracle output: Input File : /tmp/backint4oracleOTB.in

Backint for Oracle output: Profile : /sapdb/OTB/lcbackup/orabackint/initOTB.utl

Backint for Oracle output: Configfile : /sapdb/OTB/lcbackup/orabackint/initOTB.bki

Backint for Oracle output: Manual sorting file : disabled

Backint for Oracle output: Tracefile : disabled

Backint for Oracle output: Traceflags : disabled

Backint for Oracle output: Parallel sessions : 3

Backint for Oracle output: Multiplexed files : 1

Backint for Oracle output: RL compression : 1

Backint for Oracle output: Exit on error : disabled

Backint for Oracle output: BATCH : enabled

Backint for Oracle output: Buffer size : 131072

Backint for Oracle output: Buffer Copy Mode : SIMPLE

Backint for Oracle output: Redologcopies : disabled

Backint for Oracle output: Versioning : disabled

Backint for Oracle output: Backup Type : unknown

Backint for Oracle output: TSM log server : disabled

Backint for Oracle output: TSM server : ISXU951 with 3 sessions configured, using 3 session

Backint for Oracle output: TSM client node : ISXU310_OTB

Backint for Oracle output: Days for backup : Sun Mon Tue Wed Thu Fri Sat

Backint for Oracle output: Backup mgmt class : MC_DATA_TSM

Backint for Oracle output: Archiv mgmt class : MC_LOG_TSM1 MC_LOG_TSM2

Backint for Oracle output: TSM server : [ISXU952]

Backint for Oracle output:

Backint for Oracle output:

Backint for Oracle output: BKI2017I: Blocksize is set to 131072 bytes

Backint for Oracle output: BKI5016I: Time: 06/28/07 13:00:43 New TSM session created: MGMNT-CLASS: MC_DATA_TSM, TSM-Server: ISXU951, type: SIMPLE

Backint for Oracle output: BKI0027I: Time: 06/28/07 13:00:43 Object: 1 of 2 in process: /sapdb/OTB/lcbackup/file02.0 Size: 7808.000 KB, MGMNT-CLASS: MC_DATA_TSM, TSM-Server: ISXU951 .

Backint for Oracle output: BKI5016I: Time: 06/28/07 13:00:43 New TSM session created: MGMNT-CLASS: MC_DATA_TSM, TSM-Server: ISXU951, type: SIMPLE

Backint for Oracle output: BKI0027I: Time: 06/28/07 13:00:43 Object: 2 of 2 in process: /sapdb/OTB/lcbackup/file01.0 Size: 7616.000 KB, MGMNT-CLASS: MC_DATA_TSM, TSM-Server: ISXU951 .

Backint for Oracle output: BKI0023I: Time: 06/28/07 13:00:43 Done: 7808.000 KB (50.6 %) of 15.062 MB. Estimated end time: 06/28/07 13:00:48.

Backint for Oracle output: BKI0053I: Time: 06/28/07 13:00:43 Object: 1 of 2 done: /sapdb/OTB/lcbackup/file02.0 with: 7808.000 KB saved with description OTB___A0F3HHG3BQ.

Backint for Oracle output: BKI0023I: Time: 06/28/07 13:00:43 Done: 15.062 MB (100.0 %) of 15.062 MB. Estimated end time: 06/28/07 13:00:43.

Backint for Oracle output: BKI0053I: Time: 06/28/07 13:00:43 Object: 2 of 2 done: /sapdb/OTB/lcbackup/file01.0 with: 7616.000 KB saved with description OTB___A0F3HHG3BQ.

Backint for Oracle output:

Backint for Oracle output: #SAVED OTB___A0F3HHG3BQ /sapdb/OTB/lcbackup/file02.0

Backint for Oracle output:

Backint for Oracle output: #SAVED OTB___A0F3HHG3BQ /sapdb/OTB/lcbackup/file01.0

Backint for Oracle output: BKI1215I: Average transmission rate was 8.825 GB/h (2.510 MB/sec).

Backint for Oracle output: BKI1227I: Average compression factor was 1.598.

Backint for Oracle output: BKI0020I: End of program at: Thu Jun 28 13:00:45 2007 .

Backint for Oracle output: BKI0021I: Elapsed time: 08 sec .

Backint for Oracle output: BKI0024I: Return code is: 0.

Backint for Oracle output:

Backint for Oracle error output:

Waiting for creation of temporary files.

0 temporary files are available for backup.

Backing up history file.

Calling Backint for Oracle at 2007-06-28 13:00:46.

Calling '/opt/tivoli/tsm/tdp_r3/ora64/backint -u OTB -f backup -t file -p /sapdb/OTB/lcbackup/orabackint/initOTB.utl -i /tmp/backint4oracleOTB.in -c' .

Backint for Oracle ended at 2007-06-28 13:00:53 with return code 0.

Backint for Oracle output:

Backint for Oracle output: Data Protection for mySAP(R)

Backint for Oracle output:

Backint for Oracle output: Interface between BR*Tools and Tivoli Storage Manager

Backint for Oracle output: - Version 5, Release 3, Modification 2.0 for HP-UX LF 64-bit -

Backint for Oracle output: Build: 275 compiled on Nov 19 2005

Backint for Oracle output: (c) Copyright IBM Corporation, 1996, 2005, All Rights Reserved.

Backint for Oracle output:

Backint for Oracle output: BKI2027I: Using TSM-API version 5.3.3.0 (compiled with 5.3.0.0).

Backint for Oracle output: BKI2000I: Successfully connected to ProLE on port tdpr3ora64.

Backint for Oracle output: BKI0005I: Start of program at: Thu Jun 28 13:00:46 2007 .

Backint for Oracle output:

Backint for Oracle output:

Backint for Oracle output: -- Parameters --

Backint for Oracle output: Input File : /tmp/backint4oracleOTB.in

Backint for Oracle output: Profile : /sapdb/OTB/lcbackup/orabackint/initOTB.utl

Backint for Oracle output: Configfile : /sapdb/OTB/lcbackup/orabackint/initOTB.bki

Backint for Oracle output: Manual sorting file : disabled

Backint for Oracle output: Tracefile : disabled

Backint for Oracle output: Traceflags : disabled

Backint for Oracle output: Parallel sessions : 3

Backint for Oracle output: Multiplexed files : 1

Backint for Oracle output: RL compression : 0

Backint for Oracle output: Exit on error : disabled

Backint for Oracle output: BATCH : enabled

Backint for Oracle output: Buffer size : 131072

Backint for Oracle output: Buffer Copy Mode : SIMPLE

Backint for Oracle output: Redologcopies : disabled

Backint for Oracle output: Versioning : disabled

Backint for Oracle output: Backup Type : unknown

Backint for Oracle output: TSM log server : disabled

Backint for Oracle output: TSM server : ISXU951 with 3 sessions configured, using 3 session

Backint for Oracle output: TSM client node : ISXU310_OTB

Backint for Oracle output: Days for backup : Sun Mon Tue Wed Thu Fri Sat

Backint for Oracle output: Backup mgmt class : MC_DATA_TSM

Backint for Oracle output: Archiv mgmt class : MC_LOG_TSM1 MC_LOG_TSM2

Backint for Oracle output: TSM server : [ISXU952]

Backint for Oracle output:

Backint for Oracle output:

Backint for Oracle output: BKI2017I: Blocksize is set to 131072 bytes

Backint for Oracle output: BKI5016I: Time: 06/28/07 13:00:52 New TSM session created: MGMNT-CLASS: MC_DATA_TSM, TSM-Server: ISXU951, type: SIMPLE

Backint for Oracle output: BKI0027I: Time: 06/28/07 13:00:52 Object: 1 of 1 in process: /sapdb/OTB/lcbackup/backOTB.log Size: 10.215 KB, MGMNT-CLASS: MC_DATA_TSM, TSM-Server: ISXU951 .

Backint for Oracle output: BKI0023I: Time: 06/28/07 13:00:52 Done: 10.215 KB (100.0 %) of 10.215 KB. Estimated end time: 06/28/07 13:00:52.

Backint for Oracle output: BKI0053I: Time: 06/28/07 13:00:52 Object: 1 of 1 done: /sapdb/OTB/lcbackup/backOTB.log with: 10.215 KB saved with description OTB___A0F3HHGA36.

Backint for Oracle output:

Backint for Oracle output: #SAVED OTB___A0F3HHGA36 /sapdb/OTB/lcbackup/backOTB.log

Backint for Oracle output: BKI1215I: Average transmission rate was 0.005 GB/h (0.001 MB/sec).

Backint for Oracle output: BKI1227I: Average compression factor was 1.000.

Backint for Oracle output: BKI0020I: End of program at: Thu Jun 28 13:00:53 2007 .

Backint for Oracle output: BKI0021I: Elapsed time: 07 sec .

Backint for Oracle output: BKI0024I: Return code is: 0.

Backint for Oracle output:

Backint for Oracle error output:

Finished the backup successfully.

#SAVED OTB___A0F3HHG3BQ /sapdb/OTB/lcbackup/pipe1 7798784

#SAVED OTB___A0F3HHG3BQ /sapdb/OTB/lcbackup/pipe2 7995392

-

---

End of output of Backint for MaxDB (/tmp/backint4sapdbOTB.out)----

---

Removed Backint for MaxDB's temporary output file '/tmp/backint4sapdbOTB.out'.

Copying error output of Backint for MaxDB to this file.

-

---

Begin of error output of Backint for MaxDB (/tmp/backint4sapdbOTB.err)----

---

-

---

End of error output of Backint for MaxDB (/tmp/backint4sapdbOTB.err)----

---

Removed Backint for MaxDB's temporary error output file '/tmp/backint4sapdbOTB.err'.

Preparing backup.

Setting environment variable 'BI_CALLER' to value 'DBMSRV'.

Setting environment variable 'BI_REQUEST' to value 'OLD'.

Setting environment variable 'BI_BACKUP' to value 'FULL'.

Constructed Backint for MaxDB call '/sapdb/OTB/db/bin/backint -u OTB -f backup -t file -p /sapdb/OTB/lcbackup/param.cfg -i /tmp/backint4sapdbOTB.in -c'.

Created temporary file '/tmp/backint4sapdbOTB.out' as output for Backint for MaxDB.

Created temporary file '/tmp/backint4sapdbOTB.err' as error output for Backint for MaxDB.

Writing '/sapdb/data/wrk/OTB/dbm.ebf' to the input file.

Writing '/sapdb/data/wrk/OTB/dbm.knl' to the input file.

Prepare passed successfully.

Starting Backint for MaxDB.

Starting Backint for MaxDB process '/sapdb/OTB/db/bin/backint -u OTB -f backup -t file -p /sapdb/OTB/lcbackup/param.cfg -i /tmp/backint4sapdbOTB.in -c >>/tmp/backint4sapdbOTB.out 2>>/tmp/backint4sapdbOTB.err'.

Process was started successfully.

Backint for MaxDB has been started successfully.

Waiting for the end of Backint for MaxDB.

2007-06-28 13:00:53 The backup tool is running.

2007-06-28 13:00:58 The backup tool is running.

2007-06-28 13:01:08 The backup tool is running.

2007-06-28 13:01:09 The backup tool process has finished work with return code 0.

Ended the waiting.

Checking output of Backint for MaxDB.

Have found all BID's as expected.

Have saved the Backup History files successfully.

2007-06-28 13:01:09

Cleaning up.

Removing data transfer pipes.

Removing data transfer pipe /sapdb/OTB/lcbackup/pipe2 ... Done.

Removing data transfer pipe /sapdb/OTB/lcbackup/pipe1 ... Done.

Removed data transfer pipes successfully.

Copying output of Backint for MaxDB to this file.

-

---

Begin of output of Backint for MaxDB (/tmp/backint4sapdbOTB.out)----

---

Reading parameter file /sapdb/OTB/lcbackup/param.cfg.

Using staging area /sapdb/OTB/lcbackup/file01 with a size of 104857600 bytes.

Using staging area /sapdb/OTB/lcbackup/file02 with a size of 104857600 bytes.

Using 2 file per Backint for Oracle call.

Using /opt/tivoli/tsm/tdp_r3/ora64/backint as Backint for Oracle.

Using /sapdb/OTB/lcbackup/orabackint/initOTB.utl as parameterfile of Backint for Oracle.

Using /sapdb/OTB/lcbackup/backOTB.log as history file.

Using /tmp/backint4oracleOTB.in as input of Backint for Oracle.

Using /tmp/backint4oracleOTB.out as output of Backint for Oracle.

Using /tmp/backint4oracleOTB.err as error output of Backint for Oracle.

Using a maximal delay for a Backint for Oracle call of 30 seconds.

Reading input file /tmp/backint4sapdbOTB.in.

Backing up file /sapdb/data/wrk/OTB/dbm.ebf.

Backing up file /sapdb/data/wrk/OTB/dbm.knl.

Found 2 entries in the input file.

Starting the backup.

Starting pipe2file program(s).

Calling Backint for Oracle at 2007-06-28 13:00:54.

Calling '/opt/tivoli/tsm/tdp_r3/ora64/backint -u OTB -f backup -t file -p /sapdb/OTB/lcbackup/orabackint/initOTB.utl -i /tmp/backint4oracleOTB.in -c' .

Backint for Oracle ended at 2007-06-28 13:01:01 with return code 0.

Backint for Oracle output:

Backint for Oracle output: Data Protection for mySAP(R)

Backint for Oracle output:

Backint for Oracle output: Interface between BR*Tools and Tivoli Storage Manager

Backint for Oracle output: - Version 5, Release 3, Modification 2.0 for HP-UX LF 64-bit -

Backint for Oracle output: Build: 275 compiled on Nov 19 2005

Backint for Oracle output: (c) Copyright IBM Corporation, 1996, 2005, All Rights Reserved.

Backint for Oracle output:

Backint for Oracle output: BKI2027I: Using TSM-API version 5.3.3.0 (compiled with 5.3.0.0).

Backint for Oracle output: BKI2000I: Successfully connected to ProLE on port tdpr3ora64.

Backint for Oracle output: BKI0005I: Start of program at: Thu Jun 28 13:00:54 2007 .

Backint for Oracle output:

Backint for Oracle output:

Backint for Oracle output: -- Parameters --

Backint for Oracle output: Input File : /tmp/backint4oracleOTB.in

Backint for Oracle output: Profile : /sapdb/OTB/lcbackup/orabackint/initOTB.utl

Backint for Oracle output: Configfile : /sapdb/OTB/lcbackup/orabackint/initOTB.bki

Backint for Oracle output: Manual sorting file : disabled

Backint for Oracle output: Tracefile : disabled

Backint for Oracle output: Traceflags : disabled

Backint for Oracle output: Parallel sessions : 3

Backint for Oracle output: Multiplexed files : 1

Backint for Oracle output: RL compression : 0

Backint for Oracle output: Exit on error : disabled

Backint for Oracle output: BATCH : enabled

Backint for Oracle output: Buffer size : 131072

Backint for Oracle output: Buffer Copy Mode : SIMPLE

Backint for Oracle output: Redologcopies : disabled

Backint for Oracle output: Versioning : disabled

Backint for Oracle output: Backup Type : unknown

Backint for Oracle output: TSM log server : disabled

Backint for Oracle output: TSM server : ISXU951 with 3 sessions configured, using 3 session

Backint for Oracle output: TSM client node : ISXU310_OTB

Backint for Oracle output: Days for backup : Sun Mon Tue Wed Thu Fri Sat

Backint for Oracle output: Backup mgmt class : MC_DATA_TSM

Backint for Oracle output: Archiv mgmt class : MC_LOG_TSM1 MC_LOG_TSM2

Backint for Oracle output: TSM server : [ISXU952]

Backint for Oracle output:

Backint for Oracle output:

Backint for Oracle output: BKI2017I: Blocksize is set to 131072 bytes

Backint for Oracle output: BKI5016I: Time: 06/28/07 13:00:59 New TSM session created: MGMNT-CLASS: MC_DATA_TSM, TSM-Server: ISXU951, type: SIMPLE

Backint for Oracle output: BKI0027I: Time: 06/28/07 13:00:59 Object: 1 of 2 in process: /sapdb/data/wrk/OTB/dbm.knl Size: 55.824 KB, MGMNT-CLASS: MC_DATA_TSM, TSM-Server: ISXU951 .

Backint for Oracle output: BKI5016I: Time: 06/28/07 13:00:59 New TSM session created: MGMNT-CLASS: MC_DATA_TSM, TSM-Server: ISXU951, type: SIMPLE

Backint for Oracle output: BKI0027I: Time: 06/28/07 13:01:00 Object: 2 of 2 in process: /sapdb/data/wrk/OTB/dbm.ebf Size: 10.570 KB, MGMNT-CLASS: MC_DATA_TSM, TSM-Server: ISXU951 .

Backint for Oracle output: BKI0023I: Time: 06/28/07 13:01:00 Done: 55.824 KB (84.1 %) of 66.395 KB. Estimated end time: 06/28/07 13:01:01.

Backint for Oracle output: BKI0053I: Time: 06/28/07 13:01:00 Object: 1 of 2 done: /sapdb/data/wrk/OTB/dbm.knl with: 55.824 KB saved with description OTB___A0F3HHGG2E.

Backint for Oracle output:

Backint for Oracle output: #SAVED OTB___A0F3HHGG2E /sapdb/data/wrk/OTB/dbm.knl

Backint for Oracle output: BKI0023I: Time: 06/28/07 13:01:01 Done: 66.395 KB (100.0 %) of 66.395 KB. Estimated end time: 06/28/07 13:01:01.

Backint for Oracle output: BKI0053I: Time: 06/28/07 13:01:01 Object: 2 of 2 done: /sapdb/data/wrk/OTB/dbm.ebf with: 10.570 KB saved with description OTB___A0F3HHGG2E.

Backint for Oracle output:

Backint for Oracle output: #SAVED OTB___A0F3HHGG2E /sapdb/data/wrk/OTB/dbm.ebf

Backint for Oracle output: BKI1215I: Average transmission rate was 0.032 GB/h (0.009 MB/sec).

Backint for Oracle output: BKI1227I: Average compression factor was 1.000.

Backint for Oracle output: BKI0020I: End of program at: Thu Jun 28 13:01:01 2007 .

Backint for Oracle output: BKI0021I: Elapsed time: 07 sec .

Backint for Oracle output: BKI0024I: Return code is: 0.

Backint for Oracle output:

Backint for Oracle error output:

Backing up history file.

Calling Backint for Oracle at 2007-06-28 13:01:01.

Calling '/opt/tivoli/tsm/tdp_r3/ora64/backint -u OTB -f backup -t file -p /sapdb/OTB/lcbackup/orabackint/initOTB.utl -i /tmp/backint4oracleOTB.in -c' .

Backint for Oracle ended at 2007-06-28 13:01:08 with return code 0.

Backint for Oracle output:

Backint for Oracle output: Data Protection for mySAP(R)

Backint for Oracle output:

Backint for Oracle output: Interface between BR*Tools and Tivoli Storage Manager

Backint for Oracle output: - Version 5, Release 3, Modification 2.0 for HP-UX LF 64-bit -

Backint for Oracle output: Build: 275 compiled on Nov 19 2005

Backint for Oracle output: (c) Copyright IBM Corporation, 1996, 2005, All Rights Reserved.

Backint for Oracle output:

Backint for Oracle output: BKI2027I: Using TSM-API version 5.3.3.0 (compiled with 5.3.0.0).

Backint for Oracle output: BKI2000I: Successfully connected to ProLE on port tdpr3ora64.

Backint for Oracle output: BKI0005I: Start of program at: Thu Jun 28 13:01:01 2007 .

Backint for Oracle output:

Backint for Oracle output:

Backint for Oracle output: -- Parameters --

Backint for Oracle output: Input File : /tmp/backint4oracleOTB.in

Backint for Oracle output: Profile : /sapdb/OTB/lcbackup/orabackint/initOTB.utl

Backint for Oracle output: Configfile : /sapdb/OTB/lcbackup/orabackint/initOTB.bki

Backint for Oracle output: Manual sorting file : disabled

Backint for Oracle output: Tracefile : disabled

Backint for Oracle output: Traceflags : disabled

Backint for Oracle output: Parallel sessions : 3

Backint for Oracle output: Multiplexed files : 1

Backint for Oracle output: RL compression : 0

Backint for Oracle output: Exit on error : disabled

Backint for Oracle output: BATCH : enabled

Backint for Oracle output: Buffer size : 131072

Backint for Oracle output: Buffer Copy Mode : SIMPLE

Backint for Oracle output: Redologcopies : disabled

Backint for Oracle output: Versioning : disabled

Backint for Oracle output: Backup Type : unknown

Backint for Oracle output: TSM log server : disabled

Backint for Oracle output: TSM server : ISXU951 with 3 sessions configured, using 3 session

Backint for Oracle output: TSM client node : ISXU310_OTB

Backint for Oracle output: Days for backup : Sun Mon Tue Wed Thu Fri Sat

Backint for Oracle output: Backup mgmt class : MC_DATA_TSM

Backint for Oracle output: Archiv mgmt class : MC_LOG_TSM1 MC_LOG_TSM2

Backint for Oracle output: TSM server : [ISXU952]

Backint for Oracle output:

Backint for Oracle output:

Backint for Oracle output: BKI2017I: Blocksize is set to 131072 bytes

Backint for Oracle output: BKI5016I: Time: 06/28/07 13:01:07 New TSM session created: MGMNT-CLASS: MC_DATA_TSM, TSM-Server: ISXU951, type: SIMPLE

Backint for Oracle output: BKI0027I: Time: 06/28/07 13:01:07 Object: 1 of 1 in process: /sapdb/OTB/lcbackup/backOTB.log Size: 10.410 KB, MGMNT-CLASS: MC_DATA_TSM, TSM-Server: ISXU951 .

Backint for Oracle output: BKI0023I: Time: 06/28/07 13:01:07 Done: 10.410 KB (100.0 %) of 10.410 KB. Estimated end time: 06/28/07 13:01:07.

Backint for Oracle output: BKI0053I: Time: 06/28/07 13:01:07 Object: 1 of 1 done: /sapdb/OTB/lcbackup/backOTB.log with: 10.410 KB saved with description OTB___A0F3HHGLWX.

Backint for Oracle output:

Backint for Oracle output: #SAVED OTB___A0F3HHGLWX /sapdb/OTB/lcbackup/backOTB.log

Backint for Oracle output: BKI1215I: Average transmission rate was 0.005 GB/h (0.001 MB/sec).

Backint for Oracle output: BKI1227I: Average compression factor was 1.000.

Backint for Oracle output: BKI0020I: End of program at: Thu Jun 28 13:01:08 2007 .

Backint for Oracle output: BKI0021I: Elapsed time: 07 sec .

Backint for Oracle output: BKI0024I: Return code is: 0.

Backint for Oracle output:

Backint for Oracle error output:

Finished the backup successfully.

#SAVED OTB___A0F3HHGG2E /sapdb/data/wrk/OTB/dbm.ebf

#SAVED OTB___A0F3HHGG2E /sapdb/data/wrk/OTB/dbm.knl

-

---

End of output of Backint for MaxDB (/tmp/backint4sapdbOTB.out)----

---

Removed Backint for MaxDB's temporary output file '/tmp/backint4sapdbOTB.out'.

Copying error output of Backint for MaxDB to this file.

-

---

Begin of error output of Backint for MaxDB (/tmp/backint4sapdbOTB.err)----

---

-

---

End of error output of Backint for MaxDB (/tmp/backint4sapdbOTB.err)----

---

Removed Backint for MaxDB's temporary error output file '/tmp/backint4sapdbOTB.err'.

Removed the Backint for MaxDB input file '/tmp/backint4sapdbOTB.in'.

Have finished clean up successfully.

Thanks in advance.

Regards,

Tushar