NetWorker：v19.6.1.1以降でNMDA接続コードが変更されました

概要: NMDA 19.6.1.1以降、新しいロジック接続コードが導入されました(バグ334835)。 以前はnsrdavは、SYSBACKUPが要求された場合でも「/as sysdba」権限を持つOracleデータベースへの接続を必要としていました。 NMDA 19.6.1.1以降、SYSBACKUP権限を許可するように動作が変更されました。

この記事は次に適用されます： この記事は次には適用されません： この記事は、特定の製品に関連付けられていません。 すべての製品パージョンがこの記事に記載されているわけではありません。
他のリソースを確認する

現象

ログ/nsr/logs/policy/<policy_name/<workflow_name>>/action_jobid.ra

から、午後2:44:47~午後2:48:27の間に3分40秒の遅延が表示されます。 
174898 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Step (1 of 5): nsrjobd has made a request to start this savegrp with PID-6560.
151761 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Action backup traditional 'backup' has initialized as 'backup action job' with job id 4780897
174443 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Step (2 of 5): Querying the group or policy for the configured group of clients with the savegrp PID-6560.
176866 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice NetWorker_Oracle_Client:RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0 requested level=full
174451 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Step (3 of 5): The group or policy information has been successfully returned.
148778 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Action backup traditional will not limit job parallelism
174899 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Step (4 of 5): Creating a savefs job for all the configured clients.
174453 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Creating a 'savefs' job on the host 'NetWorker_Oracle_Client'.
137296 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Policy 'Test', workflow 'Test', action 'backup', group 'Test'.
148784 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Starting action backup traditional 'backup', which has 1 clients.
174444 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Starting a session on the host 'NetWorker_Oracle_Client' to execute the job 'NetWorker_Oracle_Client:savefs', which scans the file system to determine the files for backup.
174448 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice The job 'NetWorker_Oracle_Client:savefs' has been started on the client 'NetWorker_Oracle_Client'.
83643 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice NetWorker_Oracle_Client:savefs                                    started
0 10/2/2023 2:43:06 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice savefs -s NetWorker_Server -c NetWorker_Oracle_Client -g Test -p -l full -R -v -F RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0
128137 10/2/2023 2:43:11 PM  0 0 2 3075942208 6560 0 NetWorker_Server savegrp NSR info Group Test waiting for 1 jobs (0 awaiting restart) to complete.
0 10/2/2023 2:43:11 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice NetWorker_Oracle_Client:RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0 
0 10/2/2023 2:43:11 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice level=full, vers=pools, p=32
174447 10/2/2023 2:43:11 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice The job 'NetWorker_Oracle_Client:savefs' on the host 'NetWorker_Oracle_Client' has been completed.
90491 10/2/2023 2:43:11 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice NetWorker_Oracle_Client:savefs succeeded.
174904 10/2/2023 2:43:11 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice NetWorker_Oracle_Client:savefs The job has successfully scanned the file system on the host 'NetWorker_Oracle_Client'. The main save will now be started.
174905 10/2/2023 2:43:11 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Test:NetWorker_Oracle_Client:savefs See the file '/nsr/logs/policy/Test/Test/backup_4780897_logs/4780898.log' for command output.
174902 10/2/2023 2:43:11 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Step (5 of 5): Creating a save job for all the configured clients.
174901 10/2/2023 2:43:11 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Creating a save job for the save set 'RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0' on the host 'NetWorker_Oracle_Client'.
174903 10/2/2023 2:43:11 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Constructing the save command for the save set 'RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0' on the host 'NetWorker_Oracle_Client': nsrdasv -LL -z /nsr/apps/config/nmda_oracle_DB_NAME_test.cfg -c NetWorker_Oracle_Client -s NetWorker_Server -g Test/Test/backup/Test -a "*policy action jobid=4780897" -a "*policy name=Test" -a "*policy workflow name=Test" -a "*policy action name=backup" -y "1 Days" -w "1 Days" -m NetWorker_Oracle_Client -a "device interface=data domain" -a "Data Domain interface=Fibre Channel" -b POOL_NAME -o REQUESTED_LEVEL:level=full; -l full -q -W 78 -N RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0 RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0.
174896 10/2/2023 2:43:11 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Starting the 'RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0' job on host 'NetWorker_Oracle_Client'.
83643 10/2/2023 2:43:11 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice NetWorker_Oracle_Client:RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0 started
0 10/2/2023 2:43:11 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice nsrdasv -LL -z /nsr/apps/config/nmda_oracle_DB_NAME_test.cfg -c NetWorker_Oracle_Client -s NetWorker_Server -g Test/Test/backup/Test -a "*policy action jobid=4780897" -a "*policy name=Test" -a "*policy workflow name=Test" -a "*policy action name=backup" -y "1 Days" -w "1 Days" -m NetWorker_Oracle_Client -a "device interface=data domain" -a "Data Domain interface=Fibre Channel" -b POOL_NAME -o REQUESTED_LEVEL:level=full; -l full -q -W 78 -N RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0 RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0

174897 10/2/2023 2:44:47 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice The save job for the save set 'RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0' on the host 'NetWorker_Oracle_Client' has been completed.

90491 10/2/2023 2:48:27 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice NetWorker_Oracle_Client:RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0 succeeded.

174905 10/2/2023 2:48:27 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Test:NetWorker_Oracle_Client:RMAN:/var/opt/oracle/rman_DB_NAME_online.inc_0 See the file '/nsr/logs/policy/Test/Test/backup_4780897_logs/4780903.log' for command output.
148758 10/2/2023 2:48:32 PM  1 5 0 3075942208 6560 0 NetWorker_Server savegrp NSR notice Action backup traditional 'backup' with job id 4780897 is exiting with status 'succeeded', exit code 0

原因

「uid & group」の位置と接続に必要な試行回数によっては、バックアップの開始に遅延が生じる場合があります。

次の例では、バックアップが開始されるまでに3分かかります >(1秒あたり約1回の試行)。

変数は次のように表示されます。 
• NSR_DEBUG_LEVEL=9
• NSR_DPRINTF=TRUE
  
nsrdasv: 10/02/23 14:45:55.262568 Calling oci_authentication(OCI_OS_AUTHENTICATION)
nsrdasv: 10/02/23 14:45:55.262945 Calling oci_authentication(OCI_OS_AUTHENTICATION) with uid = 13500, gid = 13500
nsrdasv: 10/02/23 14:45:56.299024 OCISessionBegin(): failure 321nsrdasv: 10/02/23 14:45:56.299053 Error - ORA-01017: invalid username/password; logon denied
nsrdasv: 10/02/23 14:45:56.313673 Calling oci_authentication(OCI_OS_AUTHENTICATION) with uid = 13500, gid = 13500
nsrdasv: 10/02/23 14:45:57.339325 OCISessionBegin(): failure 321nsrdasv: 10/02/23 14:45:57.339376 Error - ORA-01017: invalid username/password; logon denied
nsrdasv: 10/02/23 14:45:57.339417 Calling oci_authentication(OCI_OS_AUTHENTICATION) with uid = 13500, gid = 1005094
nsrdasv: 10/02/23 14:45:58.372146 OCISessionBegin(): failure 321nsrdasv: 10/02/23 14:45:58.372168 Error - ORA-01017: invalid username/password; logon denied
nsrdasv: 10/02/23 14:45:58.372206 Calling oci_authentication(OCI_OS_AUTHENTICATION) with uid = 13500, gid = 1004854
….cut lines….
(pid = 18192) (10/02/23 14:48:16.138034) nwora_orcl_connect: Exiting.
(pid = 18192) (10/02/23 14:48:16.138044) The OS user has SYSBACKUP privilege.

解決方法

NMDA 19.6.1.1以降、接続ロジックは新しいルールに従います。 
NMDA tries to connect to Oracle database using uid and all the groups which the oracle user added to with SYSBACKUP privileges and SYSDBA privileges.
1 uid + all the groups which the oracle user added to with SYSBACKUP privileges
then
1 uid + all the groups which the oracle user added to with SYSDBA privileges.
Oracleユーザーの場合: 
uid=13500(oracle) gid=13500(dba) groups=13500(dba_group_1),1005094(dba_group_2),1004854(dba_group_3),…

NMDA follow try to connect first with SYSBACKUP privileges follow the below rules :
1)             “Oracle + dba_group_1” will try to connect with as SYSBACKUP privilege
2)             “Oracle + dba_group_2” will try to connect with as SYSBACKUP privilege
3)             “Oracle + dba_group_3” will try to connect with as SYSBACKUP privilege
4)             ….

If all the above fails connection fails, NMDA continue with SYSDBA privileges
1)             “Oracle + dba_group_1” will try to connect with as SYSDBA privilege
2)             “Oracle + dba_group_2” will try to connect with as SYSDBA privilege
3)             “Oracle + dba_group_3” will try to connect with as SYSDBA privilege
4)             ….
文書のプロパティ
文書番号: 000218819
文書の種類: Solution
最終更新: 04 12月 2023
バージョン:  2
質問に対する他のDellユーザーからの回答を見つける
サポート サービス
お使いのデバイスがサポート サービスの対象かどうかを確認してください。