Automatic log backup

[Former Member]

Hello All,

While swtiching automatic log backup on ( which is currently off ),via

dbmcli -d LCA -u control,password autolog_on

Do we have to take data backup or just command will work.

Regards,

Tushar

[Former Member · Accepted solution]

Hello Tushar,

The database forces you to make at least one data backup before taking any log backup (including the automatic ones).

However you should not rely on the initial data backup alone but, should create a data backup from time to time. This will increase your chances for an undamaged data backup to start the restore and it will decrease the number of log backups you need to recover and therefore decreases the restore times.

Best regards,

Tilo Heinrich

[Former Member · Accepted solution]

Hello Tilo,

Thanks a lot. Yes alleast one data backup is prerequisite for automatic log backup .

I have seen many medium names in the systems.

Also if automatic log backup was activated before, while activating system will take last backup template.

so if i execute autolog_on will automatic log backup will be activated or will it need a medium name.Thanks

Regards,

Tushar

Message was edited by:

Tushar Chavan

[former_member229109 · Accepted solution]

Please review the information at MAXDB library in section "autolog_on"

http://maxdb.sap.com/currentdoc/30/f7c7a75be311d4aa1500a0c9430730/content.htm

< http://maxdb.sap.com/currentdoc/default.htm -> Tools -> Database Manager CLI

-> Overview of All DBM Commands -> autolog_on >

To find the Syntax of the dbm command 'autolog_on' run:

dbmcli help autolog_on

or

dbmcli explain autolog_on

Syntax of the dbm command:

autolog_on [<medium_name>]

Or in later releases

autolog_on [<medium_name>] [INTERVAL <interval>]

[<medium_name>]: Name of the backup template

If you are NOT specify the <medium_name> the default backup template is used, the default backup template is the last one used for automatic log backup of the database instance

PS: As SAP customer you could find the helpful information in the SAP note::

869267 FAQ: MaxDB LOG area

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hi Natalia,

Thanks.

Regards,

Tushar

[markus_doehr2]

As you see yourself, this command just make backups of your LOG area, not of the data area.

If you would need to recover, you would need to take you last data backup and apply all logs since then.

--

Markus