In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
This article mainly introduces "NBU different machine how to recover ORACLE ORA-19511 error". In daily operation, I believe many people have doubts about how to recover ORACLE from NBU machine. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt of "how to recover ORACLE from NBU machine". Next, please follow the editor to study!
Recently, an ORA-19511 error occurred when using NBU to recover the parameter files of the ORACLE database. After various causes and methods were tried, the cause of the error was finally found. Make a record here so that you can solve the same problem more quickly. The error message is as follows:
Channel C1: reading from backup piece T191023F102620_spfile_25529_1_1022409268channel C1: ORA-19870: error while restoring backup piece T191023F102620_spfile_25529_1_1022409268ORA-19507: failed to retrieve sequential file, handle= "T191023F102620_spfile_25529_1_1022409268", parms= "ORA-27029: skgfrtrv: sbtrestore returned errorORA-19511: Error received from media manager layer, error text: Failed to process backup file failover to previous backup1. Related environment 1.1 Source-database environment
Database version: ORACLE 11.2.0.3.0
Backup method: CATALOG mode
1.2 backup server
Operating system version: Redhat 7.4
Software version: Netbackup 8.0
Description: the NBU master server and the media server of the environment are installed on the same operating system
1.3 off-machine environment
Operating system version: ORACLE LINUX 5.8
Database software version: 11.2.0.4.0
NBU software version: Netbackup 8.0
two。 Troubleshooting ideas 2.1 NBU installation configuration 1) Network Connectivity
Inspection method:
PING testing on the primary server and the recovery machine (using the hostname in / etc/hosts)
Use telnet to test the server's ports 1556, 13724 and 13782 on the recovery machine.
2) parameters of off-machine recovery
Check method: use bpgetconfig on the master server to check the relevant parameters
# NBUInstallPath/NetBackup/bin/admincmd/bpgetconfig | grep "DISALLOW_CLIENT" DISALLOW_CLIENT_LIST_RESTORE = NODISALLOW_CLIENT_RESTORE = NO
Solution: if the above two parameters are YES, off-machine recovery is prohibited, and the two parameters need to be changed to NO. To ensure the validity of the parameters, it is recommended to restart the NBU service on the master server after modification.
# NBUInstallPath/NetBackup/bin/bp.kill_all# NBUInstallPath/NetBackup/bin/bp.start_all3) restore files off-machine
Check method: whether the file No.Restrictions exists under the NBUInstallPath/NetBackup/db/altnames path on the master server
Solution: if it is not in the file, manually create a file with the same name (no need to fill in the file)
2.2 ORACLE database configuration
Is the oracle account & group name in the source database consistent with the oracle account & group name in the different machine?
At this point, the study of "how to recover ORACLE from NBU" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.