RE: How can I clear Logvolumes in SAPDB?
"Heinrich, Tilo" <[email protected]>
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
Hello Raja, >1) Can I backup these 3 "LOGVolumes" LOG001, LOG002 and LOG003 (each 4 GB) on a disk, instead of tape? You can backup them only onto disk, or into external backup tools, not onto tapes (at least not directly). 2) How can I clear these LOG files? dbmcli -d ... -u ...,... db_admin dbmcli -d ... -u ...,... -uUTL -c util_execute clear log But be sure, that you can deal with the loss of data that would occur if a crash happened. 3) Is there a way to turn the archive log OFF in SAPDB just like in Oracle? That is depending on your SAP DB version. Please note that you are loosing security if you switch the log volume off. A start would be the document http://www.sapdb.org/7.4/pdf/logsettings_eng.pdf . Just ask if something remains unclear. Best Regards Tilo Heinrich SAP Labs Berlin