NetWorker: v19.6.1.1부터 NMDA 연결 코드 수정

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

• 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 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.

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)             ….