Data Backup and Recovery

SMSAP - BR*Tools backup DB13

cristiaq
7,782 Views

Hello guys,

Im Cristian  from NetApp Chile, I help about smsap BR*Tools backup, I have a problem with BRBACKUP when it try to do a configuration files backup. I have a case numer#2002992412

AIX environment

Best Regards,

The logs say that:

The Full Backup with BRBACKUP was successfully

but when BR*tooles going  to backup to the follows files:

/oracle/ECP/920_64/dbs/initECP.ora

/oracle/ECP/920_64/dbs/spfileECP.ora

/oracle/ECP/920_64/dbs/initECP_Daily.sap

/oracle/ECP/920_64/dbs/initECP_Daily.utl

/oracle/ECP/sapreorg/spaceECP.log

/oracle/ECP/sapbackup/beidbxyz.anf

/oracle/ECP/sapbackup/backECP.log”

The BR*tools log says full backup was successfully (DB13-BRBACKUP-SMSAP), but above files is not backed

Operation Id [Nc4b211031a2e88e59bdf792eaa78f8cc] succeeded.

BR0280I BRBACKUP time stamp: 2012-03-19 22.50.29

BR0232I 1098 of 1098 files saved by backup utility

BR0230I Backup utility called successfully

BR0280I BRBACKUP time stamp: 2012-03-19 22.50.49

BR0317I 'Alter tablespace PSAPECP end backup' successful

BR0280I BRBACKUP time stamp: 2012-03-19 22.50.49

BR0317I 'Alter tablespace PSAPECP640 end backup' successful

BR0280I BRBACKUP time stamp: 2012-03-19 22.50.50

BR0317I 'Alter tablespace PSAPECPUSR end backup' successful

BR0280I BRBACKUP time stamp: 2012-03-19 22.50.50

BR0317I 'Alter tablespace PSAPUNDO end backup' successful

BR0280I BRBACKUP time stamp: 2012-03-19 22.50.50

BR0317I 'Alter tablespace SYSTEM end backup' successful

BR0280I BRBACKUP time stamp: 2012-03-19 22.50.50

BR0340I Switching to next online redo log file for database instance ECP ...

BR0321I Switch to next online redo log file for database instance ECP successful

BR0117I ARCHIVE LOG LIST after backup for database instance ECP

Parameter                      Value

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /oraarch/ECP/oraarch/ECParch

Archive format                 %t_%s.dbf

Oldest online log sequence     101678

Next log sequence to archive   101693

Current log sequence           101693     SCN: 3304756540169

Database block size            8192       Thread: 1

BR0280I BRBACKUP time stamp: 2012-03-19 22.50.51

BR0229I Calling backup utility with function 'backup'...

BR0278I Command output of '/usr/sap/ECP/SYS/exe/run/backint -u ECP -f backup -i /oracle/ECP/sapbackup/.beidgqlm.lst -t file -p /oracle/ECP/920_64/dbs/initECP_Daily.utl -c':

[ INFO] Backint Interface for SnapManager(R) 1.0

[ INFO] SMSAP-01208: Updating utility profile parameter profile_name, [ECP] -> [ECC]

[ INFO] SMSAP-01208: Updating utility profile parameter fast, [FALLBACK] -> [override]

Backint Interface for SnapManager(R) 1.0

BR0233E Backup utility has reported an error while saving file /oracle/ECP/920_64/dbs/initECP.ora

BR0233E Backup utility has reported an error while saving file /oracle/ECP/920_64/dbs/spfileECP.ora

BR0233E Backup utility has reported an error while saving file /oracle/ECP/920_64/dbs/initECP_Daily.sap

BR0233E Backup utility has reported an error while saving file /oracle/ECP/920_64/dbs/initECP_Daily.utl

BR0233E Backup utility has reported an error while saving file /oracle/ECP/sapreorg/spaceECP.log

BR0233E Backup utility has reported an error while saving file /oracle/ECP/sapbackup/beidgqlm.anf

BR0233E Backup utility has reported an error while saving file /oracle/ECP/sapbackup/backECP.log

Operation Id [Nd7bc82ce81369560f021a873181e7101] failed. Error:

BR0232E 0 of 7 files saved by backup utility

BR0280I BRBACKUP time stamp: 2012-03-19 22.51.18

BR0231E Backup utility call failed

BR0056I End of database backup: beidgqlm.anf 2012-03-19 22.51.18

BR0280I BRBACKUP time stamp: 2012-03-19 22.51.21

BR0054I BRBACKUP terminated with errors

The smsap log say:

2012-03-18 23:26:45,029 [RMI TCP Connection(2)-x.x.x.x] [ERROR]: SMSAP-07810: Error parsing

brtools log tablespace data section.

2012-03-18 23:26:45,030 [RMI TCP Connection(2)-x.x.x.x] [ERROR]: SMSAP-13032: Cannot perform

operation: backint -t backup OLD.  Root cause: SMSAP-07810: Error parsing brtools log tablespace

data section.

com.netapp.dlm.services.vdi.backint.BackintVdiException: SMSAP-07810: Error parsing brtools log t

ablespace data section.

        at com.netapp.dlm.services.vdi.backint.BackintDatabaseSession$BrLogSection$8.process(Back

intDatabaseSession.java:942)

        at com.netapp.dlm.services.vdi.backint.BackintDatabaseSession.loadDatabaseContainerFromBa

ckintLogfile(BackintDatabaseSession.java:731)

        at com.netapp.dlm.process.operation.BackintBackupAppendOperation.doExecute(BackintBackupA

ppendOperation.java:219)

        at com.netapp.dlm.process.common.NonOpCycleOperation.execute(NonOpCycleOperation.java:93)

        at com.netapp.dlm.server.RemoteOperationImpl.execute(RemoteOperationImpl.java:62)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:618)

        at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:309)

        at sun.rmi.transport.Transport$1.run(Transport.java:168)

        at java.security.AccessController.doPrivileged(AccessController.java:274)

        at sun.rmi.transport.Transport.serviceCall(Transport.java:164)

        at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:506)

        at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.handleRequest(TCPTransport.java:8

38)

        at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:912)

        at java.lang.Thread.run(Thread.java:811)

2012-03-18 23:26:45,032 [RMI TCP Connection(2)-x.x.x.x] [INFO ]: SMSAP-13039: Successfully aborted

operation: backint -t backup OLD

2012-03-18 23:26:45,206 [RMI TCP Connection(2)-x.x.x.x] [ERROR]: SMSAP-13048: backint -t bac

kup OLD Operation Status: FAILED

2012-03-18 23:26:45,206 [RMI TCP Connection(2)-x.x.x.x] [INFO ]: SMSAP-13049: Elapsed Time:

0:00:04.770

2012-03-18 23:26:45,232 [RMI TCP Connection(2)-x.x.x.x] [DEBUG]: Operation ENDED

Best Regards,

11 REPLIES 11

thomas_glodde
7,674 Views

hi there,

which version are you using? SM SAP 3.1?

Regards,

Thomas

cristiaq
7,674 Views

Hi Thomas,

yes, SMSAP 3.1

AIX 5300-08-01-0819

SDU 4.2

BRTOOLS 6.40 (52)

Regards,

Cristian

thomas_glodde
7,674 Views

Hi,

you might be struck by a unique constraint violation. NGS provided me with a 3.1D6 release back in the days. I cannot find the BURT id anymore tho :< Maybe 3.2 helps as well.

Regards,

Thomas

thomas_glodde
7,674 Views

Cris, ask support to look into closed case 2002537413 if its the same issue.

sudheerns76
7,674 Views

I am out of the office until 25/03/2012.

I am not available from 23rd to 25th March due to Public Holiday in

Bangalore and I will be out of station . Please reach out to Steve

Lee/India/IBM, for any Solution queries in my absence. For any management

queries please reach out to Sundar Subramanian1/India/IBM.

For emergency I can be reachable on Mobile Numbers - 9900111441 /

9886395241.

I Apologies for any Inconvenience and Thanks in Advance for your

co-operation.

Note: This is an automated response to your message "[Products &

Solutions] - Re: SMSAP - BR*Tools backup DB13" sent on 23/3/12 20:12:15.

This is the only notification you will receive while this person is away.

sudheerns76
7,674 Views

I am out of the office until 25/03/2012.

I am not available from 23rd to 25th March due to Public Holiday in

Bangalore and I will be out of station . Please reach out to Steve

Lee/India/IBM, for any Solution queries in my absence. For any management

queries please reach out to Sundar Subramanian1/India/IBM.

For emergency I can be reachable on Mobile Numbers - 9900111441 /

9886395241.

I Apologies for any Inconvenience and Thanks in Advance for your

co-operation.

Note: This is an automated response to your message "[Products &

Solutions] - Re: SMSAP - BR*Tools backup DB13" sent on 23/3/12 20:09:14.

This is the only notification you will receive while this person is away.

sudheerns76
5,879 Views

I am out of the office until 25/03/2012.

I am not available from 23rd to 25th March due to Public Holiday in

Bangalore and I will be out of station . Please reach out to Steve

Lee/India/IBM, for any Solution queries in my absence. For any management

queries please reach out to Sundar Subramanian1/India/IBM.

For emergency I can be reachable on Mobile Numbers - 9900111441 /

9886395241.

I Apologies for any Inconvenience and Thanks in Advance for your

co-operation.

Note: This is an automated response to your message "[Products &

Solutions] - Re: SMSAP - BR*Tools backup DB13" sent on 23/3/12 19:51:11.

This is the only notification you will receive while this person is away.

sudheerns76
7,674 Views

I am out of the office until 25/03/2012.

I am not available from 23rd to 25th March due to Public Holiday in

Bangalore and I will be out of station . Please reach out to Steve

Lee/India/IBM, for any Solution queries in my absence. For any management

queries please reach out to Sundar Subramanian1/India/IBM.

For emergency I can be reachable on Mobile Numbers - 9900111441 /

9886395241.

I Apologies for any Inconvenience and Thanks in Advance for your

co-operation.

Note: This is an automated response to your message "[Products &

Solutions] - Re: SMSAP - BR*Tools backup DB13" sent on 23/3/12 19:43:10.

This is the only notification you will receive while this person is away.

cristiaq
7,674 Views

Thx Thom,

Already i'll check this case

Regards

sudheerns76
7,674 Views

I am out of the office until 25/03/2012.

I am not available from 23rd to 25th March due to Public Holiday in

Bangalore and I will be out of station . Please reach out to Steve

Lee/India/IBM, for any Solution queries in my absence. For any management

queries please reach out to Sundar Subramanian1/India/IBM.

For emergency I can be reachable on Mobile Numbers - 9900111441 /

9886395241.

I Apologies for any Inconvenience and Thanks in Advance for your

co-operation.

Note: This is an automated response to your message "[Products &

Solutions] - Re: SMSAP - BR*Tools backup DB13" sent on 23/3/12 20:30:07.

This is the only notification you will receive while this person is away.

sudheerns76
5,879 Views

I am out of the office until 25/03/2012.

I am not available from 23rd to 25th March due to Public Holiday in

Bangalore and I will be out of station . Please reach out to Steve

Lee/India/IBM, for any Solution queries in my absence. For any management

queries please reach out to Sundar Subramanian1/India/IBM.

For emergency I can be reachable on Mobile Numbers - 9900111441 /

9886395241.

I Apologies for any Inconvenience and Thanks in Advance for your

co-operation.

Note: This is an automated response to your message "[Products &

Solutions] - SMSAP - BR*Tools backup DB13" sent on 23/3/12 19:04:17.

This is the only notification you will receive while this person is away.

Public