Highway Mount System In The Mountains Of Statistical Backup And Recovery, And Other Subsystems To Achieve

The expressway grows very rapidly in our country. By the end of 2004, the expressway has been open to traffic 1442 km in Zhejiang province. However, there is no one perfect supervisory control system on finished expressway. Though some section of expressway has built supervisory control system, its scale is small and function simplex. In 2005, it will build Gate Supervisory Control System (GSCS) on more than 1400 km long expressway in Zhejiang Province. At the same time, Zhejiang Expressway Center Data Management System (ECDMS) based on CDMA1X wireless network will be built depending on which implement all gates of the whole province online and uniform command. This paper mainly focuses on design and implement of ECDMS.The fist job of this paper is design, implement of data Stat. and report forms. Data Stat. includes Passed-Car-Stat, Alarm-Car-Stat, and Flux-Car-Stat. The statistic information of Passed-Car-Stat and Alarm-Car-Stat mainly includes the color of car brand, the province of car, passed time, passed the gate and the types of alarm etc. Flux-Car-Stat includes Day-Flux-Stat, Month-Flux-Stat, Quarter-Flux-Stat and Year-Flux-Stat. Report forms include Day-Report, Month-Report and Year-Report of all kinds of type of passed car.The second job of this paper is design and implement of users operation logs. This part not only implements function of user management logs, black car logs, login and logout logs to automatically produce, but also logs query, logs backup, logs export etc for users.The third job of this paper is design and implement of database backup. To use RMAN to backup Oracle database can implement on-line backup and incremental backup. On-line backup implements database backup when database is open. Incremental backup implements fast and efficiently to backup database.The fourth job of this paper is design and implement of database recovery. Use RMAN can recover completely database when partial data file is been damage on database based on RMAN incremental backup. However, when the whole database is lost we can implement incompletely to recover database by use RMAN.