数据库脚本技术在信息系统运维中的应用研究

Research on the Application of Database Script Technology in Information System Maintenance

分析在信息系统运维工作中脚本应用的必要性,介绍脚本的种类,讨论Oracle数据库中的两种脚本SQL脚本和RMAN脚本,结合数据库应用系统运维中的实际工作,给出SQL脚本设计中通过自适应脚本文件提高通用性、适应性的思路和方法,详细分析自动生成脚本命令和脚本文件的方法。

Analyzes the necessity of script application in information system operation and maintenance work, and introduces the SQL script and RMAN script supported in Oracle database. Then, according to actual work, discusses and gives some design ideas and methods to improve SQL script＇s generality and applicability by adaptive script file. Last, describes an example for automatically generating script commands and script files.