Data Protector - Passion for Data Protection

data-protector.org

Category Archives: HowTo

Wie geht das? Knowledgebase, HowTo, RTFM, …

Access the Data Protector WebUI

Posted on by 1 Comment

Data Protector 10 features the new WebUI integrated in the Home context of the legacy MFC GUI. The WebUI in Data Protector A.10.03 includes the Dashboard, Telemetry, Scheduler, Missed Job Executions and Global Option Tuning. Did you know that it is possible to access the WebUI from outside the MFC GUI? The following quick guide demonstrates how to make it work.

Prepare a Web User

Connect to the MFC GUI. In the Users context select an existing user or create a new user. In A.10.03 and later each user also has a Web User Name based on the Name, Group and Domain. Select Reset Password for the user that should be used.

omniusers -add -type W -usergroup admin -name USER -group DOMAIN -client client.domain.com -setpass to create a new user and reset the password.

IMPORTANT: Starting with A.10.03 and later editing the UserList file manually with a text editor is no longer supported and may cause issues to the KeyCloak service.

Continue reading “Access the Data Protector WebUI” »

AppServer issues when upgrading to 10.x

Posted on by

The AppServer has become an integral part of Data Protector. When it fails neither user authentication, scheduling or reporting will work. A critical issue has been identified that may cause upgrades to fail and/or run-time issues caused by invalid data stored in the jce_service_description and jce_service_property tables in the Data Protector JCE database.

Symptoms

During or after the upgrade from 8.1x or 9.x to 10.x you notice some or all of the following:

  • AppServer is unresponsive or slowly responding when running omnidbutil -migrate_schedules
    • Java process is causing very high CPU load on Cell Manager
    • The progress is slow and only returns errors (e.g. pausing quartz scheduler…failed)
  • Java Exceptions and stack overflow getting logged in AppServer server.log
  • Backup sessions not getting executed while scheduler is active and jobs are scheduled
  • Data Protector JCE database (part of IDB, used by Advanced and Consolidated Scheduler) is very large
    • Check the file size of dpjce-data.idb generated by omnidbutil -writedb prior to the upgrade

Continue reading “AppServer issues when upgrading to 10.x” »

Optimize MSSQL backup performance

Posted on by

Optimizing performance has always been a hot topic. This post contains information on how to optimize your MSSQL backup performance with the Data Protector. As always, with this kind of advice, this MAY be helpful in most environments but is not a general solution for any environment. Please test any of the changes and consult your SQL Server administrator if you have any doubts.

  1. General recommendations
    1. Tuning using omnirc
    2. Database integrity check
    3. SQL backup compression
  2. Parallel database backup
  3. Multi-stream database backup

Parallel database and Multi-stream database backup for Microsoft SQL is available since Data Protector A.09.08.

Continue reading “Optimize MSSQL backup performance” »

SYSBACKUP for Oracle 12c

Posted on by

Starting with Oracle 12c three new administrative roles and users have been introduced to conform the principle of access to the least privilege. The users and roles named SYSBACKUP, SYSDG and SYSKM will be created when the database is created with their account in expired and locked status. SYSBACKUP is used to perform backup and recovery operations from either Oracle Recovery Manager (RMAN) and or through SQL*Plus – you can see all privileges within the Oracle documentation.

If a Oracle 12c is detected on the client system, Data Protector A.10.01 and later now automatically uses sqlplus user/password@SID AS SYSBACKUP as the connection string to the database. As a result you may encounter the following backup issue after a Data Protector client or a Oracle database upgrade.

ORA-01031: insufficient privileges
CONNECT: sys/*****@SID
[Major] From: ob2rman@oracle.domain.lan "" Time: 05/15/18 18:15:21
Backup of target database failed.

Older Oracle databases (10g, 11i) do not require changes as they will continue to use SYSDBA. Continue reading “SYSBACKUP for Oracle 12c” »

Complex Schedules in Data Protector

Posted on by 6 Comments

Transitioning to the new Consolidated Scheduler, introduced with Data Protector A.10.00, can be a challenge. Especially when customized schedules have been used in the Legacy Scheduler to overcome former product limitations. A common example are manually modified schedule files to execute jobs at the last weekend of the month.

Data Protector A.10.03 improves the overall upgrade experience from previous versions such as 8.1x and 9.x. During the upgrade existing Legacy- and Advanced Scheduler schedules are migrated into the new Consolidated Scheduler. Once the upgrade is complete a summary is displayed by the installer. Details on schedule migration are logged into the file migration.log on the Cell Manager.

Successfully migrated schedule files (Legacy Scheduler) are kept in the corresponding directories on the Cell Manager but are renamed to SpecName.migrate. Empty schedule files are skipped. This allows manual modifications to any non-successfully migrated schedule files and re-run the schedule migration at a later point in time using omnidbutil -migrate_schedules.

Continue reading “Complex Schedules in Data Protector” »