hi i am getting this error while tacking onling backup useing db13

[Former Member]

Job started

Step 001
started (program RSDBAJOB, variant &0000000000005, user ID RAMSRIDHAR)

  Backup_Dev:Database
Backup to Device

  Backup_Dev:started
by CL_DB6_JOB_BACKUP_DEVICE       on
server EC6DEVQTY

  Backup_Dev:Parameter
TESTMODE has not been set

  Backup_Dev:Parameter
RUNTIME has not been set

  Backup_Dev:Parameter
BACKUP_MODE has been set to "ONLINE"

Backup_Dev:Parameter
PARTITION has not been set

  Backup_Dev:Parameter
BACKUP_TYPE has been set to ""

  Backup_Dev:Parameter
COMPRESS has been set to ""

  Backup_Dev:Parameter
INCLDE LOGS has been set to "INCLUDE LOGS"

  Backup_Dev:Parameter
NUMBER_BUFFERS has been set to " 0"

  Backup_Dev:Parameter
BUFFER_SIZE has been set to " 0"

  Backup_Dev:Parameter
PARALLELISM has been set to " 0"

  Backup_Dev:Parameter
UTIL_IMPACT_PRIORITY has not been set

Backup_Dev:Parameter
FILE_PATH has been set to "E:\"

  Backup_Dev:Command
' BACKUP DATABASE SQT ONLINE TO"E:\" INCLUDE LOGS  'failed

  Exception
CX_DB6_CON in program CL_DB6_JOB_BACKUP=============CP /
CL_DB6_JOB_BACKUP=============CM002 at line ADBC error with r

  Backup_Dev:Exception
CX_DBA_JOB in class CL_DB6_JOB_BACKUP

  Backup_Dev:  Kernel Error ID:

  Backup_Dev:SYSID:

  Backup_Dev:  SY-SUBRC: 1208

  Backup_Dev:  SY-TABIX: 0

  Backup_Dev:  Message: ADBC error

  Backup_Dev:  Database:

  Backup_Dev:caused
by

  Backup_Dev:Exception
CX_DB6_ADMINCMD in class CL_DB6_ADMIN_CMD method EXECUTE_CM

  Backup_Dev:  D line 43

  Backup_Dev:  Kernel Error ID:

  Backup_Dev:  SYSID: SQT

  Backup_Dev:  SY-SUBRC: 1208

  Backup_Dev:  Message: ADBC error

  Backup_Dev:  Command: BACKUP DATABASE SQT ONLINE
TO"E:\" INCLUDE LOGS

  Backup_Dev:  Database:

  Backup_Dev:caused
by

  Backup_Dev:Exception
CX_SQL_EXCEPTION in class CL_SQL_STATEMENT

  Backup_Dev:  Kernel Error ID:

  Backup_Dev:  DB Error: Yes

  Backup_Dev:  SQL Code: 2413-

  Backup_Dev:  SQL Message: SQL2413N Online backup is not
allowed because the dat

  Backup_Dev:  abase is not recoverable or a backup pending
condition is in effect ro

  Backup_Dev:w=1

  Backup_Dev:  DB Object Exists: No

  Backup_Dev:  Duplicated Key: No

  Backup_Dev:  Internal Error: 1

  Backup_Dev:  Invalid Cursor: No

  Backup_Dev:  Unknown Connection: No

  Backup_Dev:  Connection Closed: No

  Exception
CX_DBA_JOB in class CL_DB6_JOB_BACKUP method
line 40

  Backup_Dev:terminated
with error

  REASON=ADBC
error

  Job finished

[Former Member]

Hi,

SQL2413N Online backup is not allowed because the database is not recoverable

or a backup pending condition is in effect.

BKI____E Flashcopy of the database failed with rc 1024.

FMM0020I End of program at: Tue Mar 2 15:32:06 GMT+01:00 2010 .

FMM0021I Elapsed time: 17 sec .

FMM0024I Return code is: 2.

To set LOGREATIN in the DB2 database, enter the db2 update db cfg for <SID> using

LOGRETAIN ON command. Then, run an offline backup of the database so that subsequent online

backups of the database are allowed. The following DB2 command displays that the database can be

used for online backups.

db2t2p> db2 get db cfg for T2P | grep -i retain

Number of frequent values retained (NUM_FREQVALUES) = 10

Number of quantiles retained (NUM_QUANTILES) = 20

Log retain for recovery status = RECOVERY

Log retain for recovery enabled (LOGRETAIN) = RECOVERY

First log archive method (LOGARCHMETH1) = LOGRETAIN

Number of database backups to retain (NUM_DB_BACKUPS) = 12

Check this doc for more details.

http://www-03.ibm.com/support/techdocs/atsmastr.nsf/5cb5ed706d254a8186256c71006d2e0a/31fcf6746b4c552...

Regards,

Vekata S Pagolu.

[MaheshKumar]

Hi Mukesh,

Could you schedule your backup through BRTools..?

Regards

Mahesh Kumar M

[Former Member]

thank for reply

no actualy i m new in sap so, I don,t know about this tool , but i have check for the reason that there is not archivelog configure in our db2 so, it gives the error, so, can u pls. show me that how to enable archive log in my db2

we are using windows 2008 server , SAP ECC6 ,with DB2 9.1

[Former Member]

Hello Mukesh,

First of all please make sure DB backup device configuration is completed successfully in your system. Then after you have make sure the following parameters are set in order to setup archive logging. You should take full offline backup after setup archive logging.

LOGARCHMETH1= <TSM device path for log archiving>

FAILARCHPATH = </db2/<DBSID>/log_archive>

NEWLOGPATH = /db2/<DBSID>/log_dir

You will be able to see DB config parameter values with command db2 get db cfg for <DBSID>.

Hope it answered your query.

Thanks,

Siva Kumar

[Former Member]

Hi,

Have a look the following link. Hope this will help you..

http://scn.sap.com/thread/1265596

http://scn.sap.com/thread/1953317

Regards

[Former Member]

dear bhuban

thanks for quick respond but the link you provided is not working its giving error "no discussion found"

[Former Member]

Hi,

Copy the link and paste in you browser new tab.. It will work..

Rewards if helpfull

Thanks

[Former Member]

hi

thaks

i have check both link its working but i my problem is not solve because both link is releated to tape backup, and I am tacking backup on local hard drive in window 2008 server.

Mukesh

[Former Member]

Hi,

The error: SQL Message: SQL2413N Online backup is not allowed because the dat

               abase is not recoverable or a backup pending condition is in effect ro

You try to  cyclically overwriting your log - and because of that you can´t do an online backup. To change that, you have to configure logging properly and then do an offline backup first. After that you can do online backups

See the link below..

https://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.messages.sql....

http://scn.sap.com/thread/1141746

Regards

Bhuban