Database security protection, database backup and disaster recovery are important tasks for all colleges and universities to ensure the safe and stable operation of information systems. Based on the operating environment of the Oracle production database in China University of Geosciences (Beijing), combined with the practical operation and maintenance experience, this paper provides a design and implementation case of Oracle database security protection system and disaster recovery architecture. The network security protection architecture of the three-layer firewall and fortress machine, the detection and repair of security vulnerabilities, the management of system accounts and permissions, data encryption and database audit constitute the security protection system of the database. Oracle RAC (Real Application Clusters), Oracle DataGuard, redundant backup management and backup recovery constitute the disaster recovery architecture of the database. The case has practical significance for database operation and maintenance management in other colleges and universities.
References
[1]
Zhang, J.X., Chen, M.L. and Wang, Q. (2010) Analysis of Web Databases-Attacking and Its Protection Strategy. Bulletin of Science and Technology, 26, 769-773. https://doi.org/10.1016/S1005-0302(10)60122-3
[2]
Hu, S.R., Ye, X.J., Peng, Y. and Xie, F. (2009) Design and Development of a Defense-in-Depth Model for Database Security. Journal of Computer Research and Development, 46, 474-479.
[3]
He, B.Y. and Liu, R. (2013) The Security Baseline Verification of Oracle and SQL Server Database. Journal of Yunnan University (Natural Sciences Edition), 35, 63-68.
[4]
He, W.C., Li, S.J., Liu, P.H., Ma, Y.J. and Yang, Y.T. (2020) Overview of Oracle Database Security Protection. Computer Applications and Software, 37, 316-322.
[5]
Chen, C.J. and Yang, Y. (2003) Analysis of Web Databases-Attacking and Its Protection Strategy. Sun Yatsen University Forum, 23, 208-211.
[6]
Zou, X.J. (2017) Research on Database Security Technology Based on Web. Master Thesis, Beijing University of Posts and Telecommunications, Beijing.
[7]
Xu, Y. (2015) Research on the Application of Sensitive Data Encryption Based on Oracle Database. Software Engineer, 18, 54-56.
[8]
Shi, Y.D., Gao, Q. and Hao, W.Q. (2019) Oracle Database 12c Release 2 Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting. Tsinghua University Press, Beijing.
[9]
Wu, B.H., Zhu, S.M. and Wu, X.Z. (2017) Application of Oracle RAC Cluster on the E-Card System of Smart Campus. Journal of Central China Normal University (Natural Sciences), 2017, 17-20.
[10]
Lv, Y.H., Sun, J.H. and Ma, L. (2016) Design and Implementation of Database Cluster System in Campus Network Based on Oracle RAC. Modern Electronics Technique, 39, 72-75.
[11]
Wang, Q., Liu, N.J. and Feng, K. (2011) Research on Application of Cluster and Disaster Recovery in Database of Colleges and Universities. Experimental Technology and Management, 28, 91-93.
[12]
Kiran, C., Abhijeet, S. and Sudhakar, J. (2015) Disaster Recovery and Zero Failover Using Oracle Dataguard. International Journal for Scientific Research and Development, 3, 2048-2051.
[13]
Han, W.J., Xue, J.F., Zhang, F.Q. and Sun, Z.H. (2020) An Effective Remote Data Disaster Recovery Plan for the Space TT&C System. Machine Learning for Cyber Security, 12487, 31-41. https://doi.org/10.1007/978-3-030-62460-6_4
[14]
Yang, F.F., Yang, X. and Ma, Q. (2017) Research on Backup Scheme of Oracle Database Based on Rman and TSM. Computer Technology and Development, 27, 164-169.
[15]
Antonio, R. and Lance, A. (2008) Oracle Backup and Recovery Advanced User’s Guide 10g Release 2(10.2). https://docs.oracle.com/cd/B19306_01/backup.102/b14191/title.htm
[16]
Gao, G.Z., Liu, N.J., Feng, K. and Wang, Q. (2009) Research and Implementation of Oracle Standby Database Based on Backup and Restoration Technology. Experimental Technology and Management, 26, 84-87.
