List of Contributions

Thomas Prause

Contact Details

My Content

1 to 12 of 12 total

RE: Question about cleanup/deletion of snapshots when using SPS/FCM on a SVC

Posted By Thomas Prause Mon February 22, 2021 02:40 AM
Found In Egroup: Data Protection Software \ view thread
It is correct that the delete command just marks the objects for deletion. The real delete happens asynchronously by the background monitor. Because this can take quite long as you have observed. Would recommend to open a ticket with support to get this analyzed further. ------------------------------ ...

RE: HANA node occupancy increasing rapidly

Posted By Thomas Prause Mon June 15, 2020 02:36 AM
Found In Egroup: Primary Storage \ view thread
Hi Prem, you can try to improve the dedup rate of the full backups using the instructions found in this document https://www.ibm.com/support/pages/node/275755 The log backups typically do not benefit from dedup. Depending on the change rate of your database it may be really that much. Regards ...

RE: SAP Archive log schedule is returning error Failed1

Posted By Thomas Prause Mon October 14, 2019 10:12 AM
Found In Egroup: Primary Storage \ view thread
May be you can create a script that maps rc 1 from brarchive into 0. So that the SP scheduler considers the action in such case as successful. ------------------------------ Thomas Prause ------------------------------

RE: SAP Archive log schedule is returning error Failed1

Posted By Thomas Prause Fri October 11, 2019 08:28 AM
Found In Egroup: Primary Storage \ view thread
Hi Prem, this matches the SAP documentation https://help.sap.com/SAPHELP_46c/helpdata/RU/0d/d30fdb4a0c11d182b80000e829fbfe/content.htm?no_cache=true Return code 1 means "Backup/restore ended with warnings. All files were backed up/restored.". Seems all you need is to somehow make your schedule command ...

RE: SAP Archive log schedule is returning error Failed1

Posted By Thomas Prause Fri October 11, 2019 05:36 AM
Found In Egroup: Primary Storage \ view thread
Hi Prem, I would assume brarchive does not end with return code 0 in case there is no redo log file ready for archive. Did you check the return code? Regards, Thomas ------------------------------ Thomas Prause ------------------------------

RE: SAP Restore is failing with unknown reason

Posted By Thomas Prause Fri April 12, 2019 08:24 AM
Found In Egroup: Data Protection Software \ view thread
Sorry, I do not know the brrestore command line options by head. You could look them up in the BR*Tools users guide or use brrecover. It offers you to enter the log numbers in some sort of text mode ui and finally composes/executes the brrestore commands. Much more convenient. ------------------------------ ...

RE: SAP Restore is failing with unknown reason

Posted By Thomas Prause Wed April 10, 2019 02:59 AM
Found In Egroup: Data Protection Software \ view thread
> BR0565W Due to running database instance control file cannot be restored during a BRRESTORE run with RMAN > BR0566I Stop the database instance and restore the control file separately ... > RMAN-06403: could not obtain a fully authorized session > ORA-01034: ORACLE not available Looks like the ...

RE: SAP Restore is failing with unknown reason

Posted By Thomas Prause Wed April 10, 2019 02:36 AM
Found In Egroup: Data Protection Software \ view thread
There is nothing wrong with the .utl file. The brrestore command is just missing the '-r'in front of ' initHebdoAMQrestoreAMP.utl'. Have you ever thought about using brrecover? It would guide you through the recovery process and compose all the brrestore commands for you. May be that makes your life ...

RE: SAP RMAN backup is taking too much time to complete

Posted By Thomas Prause Mon March 18, 2019 12:06 PM
Found In Egroup: Data Protection Software \ view thread
If the backup with BR*Tools device type 'util_file' using 4 sessions does complete within 4 hours, then you proved that the performance is not limited by the number of sessions/drives. Adding even more sessions is not going to help. Seems RMAN is spending too much time reading the data. Tuning RMAN ...

RE: Reclamation/Expiration SAP HANA v2.0

Posted By Thomas Prause Thu March 14, 2019 08:46 AM
Found In Egroup: Primary Storage \ view thread
Starting with 8.1.4 you can set profile parameter MAX_VERSIONS to specify how many backup generations (a full database backup and associated redo logs) shall be retained. Obsolete versions will be deleted automatically. See here for details -> https://www.ibm.com/support/knowledgecenter/SSER83_8.1.4 ...

RE: SAP RMAN backup is taking too much time to complete

Posted By Thomas Prause Thu March 14, 2019 08:31 AM
Found In Egroup: Data Protection Software \ view thread
You can specify parameter rman_channels in .sap file. But again: average throughput of 50 MB/s will not keep two drives in streaming mode. You better consider to tune the disk reads. ------------------------------ Thomas Prause ------------------------------

RE: SAP RMAN backup is taking too much time to complete

Posted By Thomas Prause Thu March 14, 2019 03:02 AM
Found In Egroup: Data Protection Software \ view thread
For each RMAN channel a session to the server or STA is opened. If you have more drives you could try increasing the number of channels. Don't forget to increase MAX_SESSIONS. But I agree that 3.5 T in 18 hours is rather slow. Even for a single drive. Probably you are limited by read performance. ...