NetWorker: NMDA-forbindelseskode ændret startende v19.6.1.1

概要: Der er blevet introduceret en ny logisk forbindelseskode siden NMDA 19.6.1.1 (Bug 334835). Tidligere krævede nsrdav en forbindelse til Oracle-databasen med "/ som sysdba"-rettigheder, selv SYSBACKUP blev anmodet om. Fra NMDA 19.6.1.1 er adfærden blevet ændret, så sysbackup-rettigheder tillades. ...

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

現象

Fra logfilen /nsr/logs/policy/<policy_name>/<workflow_name>/action_jobid.ra

Vi kan se en forsinkelse på 3 minutter og 40 sek. mellem 14:44:47 og 02:48:27. 
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

原因

Afhængigt af placeringen af "uid > group" og antallet af forsøg, der kræves for at oprette forbindelse, kan der være en forsinkelse ved start af sikkerhedskopier.

I eksemplet nedenfor tager >det 3 minutter, før sikkerhedskopieringen starter (ca. ét forsøg pr. sekund).

Variablerne viser: 
• 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.

解決方法

Fra og med NMDA 19.6.1.1 følger forbindelseslogikken nye regler: 
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.
For en Oracle-bruger: 
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ユーザーからの回答を見つける
サポート サービス
お使いのデバイスがサポート サービスの対象かどうかを確認してください。