Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

1.1.1 troubleshooting of Oracle problems in NBU backup

2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

1. Create debug folders under the following directories on database client:

All log directories should be created under / usr/openv/netbackup/logs with 777 permissions.

/ usr/openv/netbackup/logs/bphdb

/ usr/openv/netbackup/logs/bpcd

/ usr/openv/netbackup/logs/dbclient

2. Attempt the backup or restore operation

3. Gather the appropriate debug information from the backup client

A. The content of all the error logs at / usr/openv/netbackup/logs

B. The backup script and the output of the backup script with exact error messages

C. / usr/openv/netbackup/bp.conf and bp.conf at home directory of oracle OS user if exists.

D. The oracle database version information

Sqlplus "/ as sysdba"

SQL > select * from v$version

SQL > select * from v$instance

E. In case of oracle report critical errors (e.g. ORA-0600) or backup hang for a long time without response, we also need to collect the oracle alert log at $ORACLE_BASE/admin//bdump.

Commonly used commands

/ / /

Windows OS

Adjust the log level of master server as follows:

Open the NBU Console interface, Host Properties > Master Servers, right-click master server, click Properties, select Logging, check Enable robust logging, and set Global Logging Level to 5.

Create a log directory

Install_path\ netbackup\ logs\ bptm

Install_path\ netbackup\ logs\ bpbrm

Install_path\ netbackup\ logs\ vnetd

Install_path\ netbackup\ logs\ bpcd

Install_path\ netbackup\ logs\ bprd

Install_path\ netbackup\ logs\ bpdbm

=

Adjust the log level of media server as follows:

Open the NBU Console interface, Host Properties > Media Servers, right-click the corresponding media server, click Properties, select Logging, check Enable robust logging, and set Global Logging Level to 5.

Create a log directory

Install_path\ netbackup\ logs\ bptm

Install_path\ netbackup\ logs\ bpbrm

Install_path\ netbackup\ logs\ vnetd

Install_path\ netbackup\ logs\ bpcd

=

Adjust the log level of client server as follows:

On client server, click start > all programs > Symantec NetBackup > Backup Archive & Restore

In the BAR console interface, File > Netbackup Client Properties > Troubleshooting, set General level to 2 and Verbose level to 5.

Create a log directory

Install_path\ netbackup\ logs\ bpbkar

Install_path\ netbackup\ logs\ bpfis

Install_path\ netbackup\ logs\ vnetd

Install_path\ netbackup\ logs\ bpcd

Install_path\ netbackup\ logs\ bphdb

Install_path\ netbackup\ logs\ dbclient

Install_path\ netbackup\ logs\ bpdb2

Install_path\ netbackup\ logs\ backint

/ / /

UNIX/Linux OS

Adjust the log level of master server as follows:

Add VERBOSE = 5 to the / usr/openv/netbackup/bp.conf file.

Create a log directory

/ usr/openv/netbackup/logs/bpcd

/ usr/openv/netbackup/logs/vnetd

/ usr/openv/netbackup/logs/bprd

/ usr/openv/netbackup/logs/bpbrm

/ usr/openv/netbackup/logs/bptm

/ usr/openv/netbackup/logs/bpdbm

The NetBackup service needs to be restarted

/ usr/openv/netbackup/bin/goodies/netbackup stop

/ opt/VRTSpbx/bin/vxpbx_exchanged stop

/ usr/openv/netbackup/bin/bpps-x (there are no NB and MM processes other than pbx_exchange processes)

/ opt/VRTSpbx/bin/vxpbx_exchanged start

/ usr/openv/netbackup/bin/goodies/netbackup start

=

Adjust the log level of media server as follows:

Add VERBOSE = 5 to the / usr/openv/netbackup/bp.conf file.

Create a log directory

/ usr/openv/netbackup/logs/bpcd

/ usr/openv/netbackup/logs/vnetd

/ usr/openv/netbackup/logs/bpbrm

/ usr/openv/netbackup/logs/bptm

The NetBackup service needs to be restarted

/ usr/openv/netbackup/bin/goodies/netbackup stop

/ opt/VRTSpbx/bin/vxpbx_exchanged stop

/ usr/openv/netbackup/bin/bpps-x (there are no NB and MM processes other than pbx_exchange processes)

/ opt/VRTSpbx/bin/vxpbx_exchanged start

/ usr/openv/netbackup/bin/goodies/netbackup start

=

Adjust the log level of client server as follows:

Add VERBOSE = 5 to the / usr/openv/netbackup/bp.conf file.

Create a log directory

/ usr/openv/netbackup/logs/bpbkar

/ usr/openv/netbackup/logs/bpfis

/ usr/openv/netbackup/logs/bpcd

/ usr/openv/netbackup/logs/bpbrm

/ usr/openv/netbackup/logs/bphdb

/ usr/openv/netbackup/logs/dbclient

/ usr/openv/netbackup/logs/bpdb2

/ usr/openv/netbackup/logs/backint

/ usr/openv/netbackup/logs/sybackup

/ / /

Socket connection failed problem

Please follow these steps to test whether the port of NetBackup communication is normal.

On Master Server

Telnet client_name 13724

Telnet client_name 13782

Telnet media_server_name 13724

Telnet media_server_name 13782

Telnet media_server_name 1556

On Media Server

Telnet client_name 13724

Telnet client_name 13782

Telnet master_server_name 13724

Telnet master_server_name 13782

Telnet master_server_name 1556

On Client Server

Telnet master_server_name 13724

Telnet master_server_name 13782

Telnet master_server_name 13720

Telnet media_server_name 13724

Telnet media_server_name 13782

Telnet master_server_name 1556

If the port telnet is not available, check:

Whether it is correct to add the hostname and ip resolution of the peer server to the 1.hosts file.

Ping server_hostname

Ping server_ip_address

two。 Go to the server on the opposite side and check that the port of the telnet is listening.

Netstat-na

Telnet localhost port_number

3. If telnet localhost port_number is successful, check the firewall of the network or OS to see if the port disable

/ / /

Unified logs

= windows OS=

Adjust related unified log level

Install_path\ netbackup\ bin\ vxlogcfg-a-p 51216-o 111-s DebugLevel=6-s DiagnosticLevel=6

Install_path\ netbackup\ bin\ vxlogcfg-a-p 51216-o 116-s DebugLevel=6-s DiagnosticLevel=6

Install_path\ netbackup\ bin\ vxlogcfg-a-p 51216-o 117-s DebugLevel=6-s DiagnosticLevel=6

Install_path\ netbackup\ bin\ vxlogcfg-a-p 51216-o 118-s DebugLevel=6-s DiagnosticLevel=6

Collect log

Install_path\ netbackup\ bin\ vxlogview-p 51216-o 111-t 00:10:00-d all > c:\ 111.txt

= UNIX/Linux OS=

Adjust related unified log level

/ usr/openv/netbackup/bin/vxlogcfg-a-p 51216-o 111-s DebugLevel=6-s DiagnosticLevel=6

Collect log

/ usr/openv/netbackup/bin/vxlogview-p 51216-o 111-t 00:10:00-d all > / tmp/111.txt

/

BMR bmrsaveconfig

Please adjust the log level of bmrsavecfg on this client

Install_path\ netbackup\ bin\ vxlogcfg-a-p 51216-o 121-s DebugLevel=6-s DiagnosticLevel=6

Run the command, and if the command reports an error, send me the error message.

Install_path\ netbackup\ bin\ bmrsavecfg-infoonly

As soon as the above command returns to the prompt, run the command to collect log

Install_path\ netbackup\ bin\ vxlogview-p 51216-o 121-t 00:10:00-d all > c:\ 121.txt

Collect the following files on this host

Install_path\ netbackup\ BareMetal\ client\ data\ bmrcli.xml & bundle.dat

Lower the log level

Install_path\ netbackup\ bin\ vxlogcfg-a-p 51216-o 121-s DebugLevel=1-s DiagnosticLevel=1

=

/ usr/openv/volmgr/bin/tpconfig-emm_dev_list > / tmp/emmdev_1.txt

/ usr/openv/volmgr/bin/vmoprcmd > / tmp/vmoprcmd_1.txt

/ usr/openv/netbackup/bin/admincmd/bppllist-allpolicies-L > / tmp/pol.txt

/ usr/openv/netbackup/bin/admincmd/bpstulist-L > / tmp/stu.txt

/ usr/openv/netbackup/bin/admincmd/bperror-U > / tmp/bperror.txt

/ usr/openv/netbackup/bin/admincmd/bpdbjobs > / tmp/bpdbjobs.txt

/ usr/openv/netbackup/bin/goodies/available_media > / tmp/am.txt

/ usr/openv/netbackup/bin/admincmd/nbemmcmd-listmedia-allrecords > / tmp/emm_media.txt

/ usr/openv/netbackup/bin/admincmd/nbemmcmd-listhosts-verbose > / tmp/nbemmcmd.txt

Adjust the log level of nbemm,nbrb,nbjm

/ usr/openv/netbackup/bin/vxlogcfg-a-p 51216-o 111-s DebugLevel=6-s DiagnosticLevel=6

/ usr/openv/netbackup/bin/vxlogcfg-a-p 51216-o 117-s DebugLevel=6-s DiagnosticLevel=6

/ usr/openv/netbackup/bin/vxlogcfg-a-p 51216-o 118-s DebugLevel=6-s DiagnosticLevel=6

Initiate 4 jobs at the same time to reproduce the phenomenon of two runs & two queues (preferably this phenomenon can last more than 3 minutes)

In the course of this phenomenon,

/ usr/openv/volmgr/bin/tpconfig-emm_dev_list > / tmp/emmdev_2.txt

/ usr/openv/volmgr/bin/vmoprcmd > / tmp/vmoprcmd_2.txt

Collect log

/ usr/openv/netbackup/bin/vxlogview-p 51216-o 111-t 00:10:00-d all > / tmp/111.txt

/ usr/openv/netbackup/bin/vxlogview-p 51216-o 117-t 00:10:00-d all > / tmp/117.txt

/ usr/openv/netbackup/bin/vxlogview-p 51216-o 118-t 00:10:00-d all > / tmp/118.txt

Send me the log and command output files under / tmp/ above.

Copy and paste the detailed status information of the last two queued jobs into the txt text file and send it to me.

And tell me the name of the policy you initiated at the same time.

/

If I encounter the problem of catalog backup failure, I will follow the following procedure

1. Confirm to the user that all previous catalog backups were successful. If successful, you need to check the reason for this failure, or restart NBU, back up catalog, and see the results; if newly configured, check the configuration of catalog policy.

two。 Confirm that there are several jobs in this backup catalog, which should be 4 job. Ask the user to send us the detailed status of the catalog failed job.

3. Preliminary judgment of the problem based on status information, such as 811 in this case

Check it first.

Install_path\ netbackup\ bin\ admincmd\ nbrbutil-dump > c:\ nbrbdump.txt

Install_path\ netbackup\ bin\ admincmd\ bppllist-allpolicies-L > c:\ pol.txt

Install_path\ netbackup\ bin\ admincmd\ bpstulist-L > c:\ stu.txt

Install_path\ netbackup\ bin\ admincmd\ bperror-U > c:\ bperror.txt

Install_path\ netbackup\ bin\ admincmd\ nbemmcmd-listhosts-verbose > c:\ nbemmcmd.txt

Install_path\ netbackup\ bin\ admincmd\ bpminlicense-list_keys-verbose > c:\ nbulic.txt

Install_path\ netbackup\ bin\ admincmd\ bpdbjobs > c:\ job.txt

Install_path\ volmgr\ bin\ vmglob-listall-b > c:\ vmglob.txt

Install_path\ volmgr\ bin\ tpconfig-d > c:\ tpconfig.txt

Install_path\ volmgr\ bin\ vmoprcmd > c:\ vmoprcmd.txt

Install_path\ volmgr\ bin\ tpclean-L > c:\ tpclean.txt

Collect relevant log

Open the NBU Console interface, Host Properties > Master Servers, right-click master server, click Properties, select Logging, check Enable robust logging, and set Global Logging Level to 5.

Create a log directory

Install_path\ netbackup\ logs\ bptm

Install_path\ netbackup\ logs\ bpbrm

Restart the service of NBU and restart the catalog backup of NBU. If it fails, send us the log under bptm and bpbrm.

Still failed, bptm and bpbrm still reported 811 errors.

Need to collect unified log

/ usr/openv/netbackup/bin/vxlogcfg-a-p 51216-o 111-s DebugLevel=6-s DiagnosticLevel=6

Adjust the log level of nbemm,nbrb,nbjm

/ usr/openv/netbackup/bin/vxlogcfg-a-p 51216-o 111-s DebugLevel=6-s DiagnosticLevel=6

/ usr/openv/netbackup/bin/vxlogcfg-a-p 51216-o 117-s DebugLevel=6-s DiagnosticLevel=6

/ usr/openv/netbackup/bin/vxlogcfg-a-p 51216-o 118-s DebugLevel=6-s DiagnosticLevel=6

Re-initiate backup, after failure

Collect log

/ usr/openv/netbackup/bin/vxlogview-p 51216-o 111-t 00:10:00-d all > / tmp/111.txt

/ usr/openv/netbackup/bin/vxlogview-p 51216-o 117-t 00:10:00-d all > / tmp/117.txt

/ usr/openv/netbackup/bin/vxlogview-p 51216-o 118-t 00:10:00-d all > / tmp/118.txt

/ usr/openv/netbackup/bin/admincmd/nbemmcmd-listhost-verbose > / tmp/nbemmcmd.txt

/ usr/openv/netbackup/bin/admincmd/bperror-U > / tmp/bperror.txt

/ usr/openv/netbackup/bin/admincmd/bppllist-allpolicies-L > / tmp/pol.txt

/ usr/openv/netbackup/bin/admincmd/bpstulist-L > / tmp/stu.txt

/ usr/openv/netbackup/bin/bpps-x > / tmp/bpps.txt

/ usr/openv/volmgr/bin/vmoprcmd-d > / tmp/vmoprcmd_me.txt

/ usr/openv/volmgr/bin/tpautoconf-t > / tmp/tpautoconf.txt

/ usr/openv/volmgr/bin/tpconfig-d > / tmp/tpconfig.txt

/ usr/openv/volmgr/bin/scan > / tmp/scan.txt

/ usr/openv/volmgr/bin/vmglob-listall-b > / tmp/vmglob.txt

/ usr/openv/netbackup/bin/admincmd/nbrbutil-dump > / tmp/nbrb.txt

/ usr/openv/volmgr/bin/vmoprcmd > / tmp/vmoprcmd.txt

/ usr/openv/netbackup/bin/admincmd/nbemmcmd-addhost-machinename media_server_name-machinetype media-netbackupversion 7.1-operatingsystem hpux

/ usr/openv/netbackup/bin/admincmd/nbemmcmd-deletehost-machinename media_server_name-machinetype media

Nbemmcmd-deletealldevices-machinename media_server_name-machinetype media

/

Delete the cleaning belt and re-follow the following configuration.

1. Delete cleaning belt

two。 Redo robot inventory, set the type of cleaning tape, and put in NONE pool. The type of cleaning tape is the same as the type of tape drive. If the tape drive is hcart2, then the cleaning tape is 1 cleaning tape 2.

3. Double-click the cleaning belt, set the cleaning times, Number of cleanings remaining > new account, and enter a number, such as 30

4. Check the remaining cleaning times in the cleaning belt, and use the command install_path\ volmgr\ bin\ vmquery-m media_id_cleaning_tape to check the desired cleanings left parameters of the output

/ / /

Nbemmcmd-machinealias-getaliases-machinename server_name-machinetype master

/ / emm startup failed/

1. Please confirm the remaining space on the disk where the NBU master server is located. NBU requires 10% of the total disk space, such as C disk 40GB size, and the remaining space above 4GB is required, otherwise NBU work will be abnormal.

two。 Please run the following command and send me the executed command and output information.

Install_path\ netbackup\ bin\ nbdb_ping > c:\ nbdb_ping.txt

Install_path\ netbackup\ bin\ bpps > c:\ bpps.txt

Install_path\ netbackup\ bin\ ipconfig / all > c:\ ip.txt

Install_path\ netbackup\ bin\ admincmd\ bpgetconfig > c:\ nbuconfig.txt

Install_path\ netbackup\ bin\ admincmd\ bpminlicense-list_keys-verbose > c:\ nbulic.txt

Install_path\ netbackupDB\ data\ dir > c:\ db_dir.txt

Install_path\ netbackupDB\ log\ dir > c:\ log_dir.txt

3. Collect the following documents and send them to me.

C:\ windows\ system32\ drivers\ etc\ hosts

Install_path\ netbackupDB\ log\ server.log

/ / re-configure the devices / /

1. To cancel other current backup jobs, you can execute the following command

/ usr/openv/netbackup/bin/admincmd/nbrbutil-resetAll

/ usr/openv/netbackup/bin/admincmd/nbrbutil-dump (use this command to confirm that there is no output of resource information)

two。 Remove the tape library device on the master server

/ usr/openv/netbackup/bin/admincmd/nbemmcmd-deletealldevices-machinename SZBK52SVC-machinetype media

Check through the command to confirm that there is no device output.

/ usr/openv/volmgr/bin/tpconfig-d

3. Stop the service of NBU

/ usr/openv/netbackup/bin/goodies/netbackup stop

/ usr/openv/netbackup/bin/bpps-x (confirm that there are no NB and MM processes except for the pbx_exchange process)

/ usr/openv/netbackup/bin/goodies/netbackup start

/ usr/openv/netbackup/bin/bpps-x > / tmp/bpps_restart.txt

4. Configure tape library Devic

/ usr/openv/volmgr/bin/tpautoconf-t check the tape drive, it should be able to list the tape drive with 8 tape libraries

/ usr/openv/volmgr/bin/tpautoconf-r check manipulator

/ usr/openv/volmgr/bin/tpautoconf-a configure the discovered devices into the NBU

5. Restart the service of NBU

/ usr/openv/netbackup/bin/goodies/netbackup stop

/ usr/openv/netbackup/bin/bpps-x (confirm that there are no NB and MM processes except for the pbx_exchange process)

/ usr/openv/netbackup/bin/goodies/netbackup start

6. Check the status of the tape drive

/ usr/openv/volmgr/bin/tpconfig-d > / tmp/tpconfig.txt

/ usr/openv/volmgr/bin/vmoprcmd > / tmp/vmoprcmd_1.txt

/ usr/openv/volmgr/bin/vmoprcmd-d > / tmp/vmoprcmd_2.txt

/ / /

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report