on 11-16-2007 12:10 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.