TWI719609B - Remote backup system - Google Patents
Remote backup system Download PDFInfo
- Publication number
- TWI719609B TWI719609B TW108130757A TW108130757A TWI719609B TW I719609 B TWI719609 B TW I719609B TW 108130757 A TW108130757 A TW 108130757A TW 108130757 A TW108130757 A TW 108130757A TW I719609 B TWI719609 B TW I719609B
- Authority
- TW
- Taiwan
- Prior art keywords
- database
- data
- log
- backup
- remote
- Prior art date
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
本發明係關於一種異地備援系統,特別係關於一種可於異地操作、應用之異地備援系統。The present invention relates to a remote backup system, in particular to a remote backup system that can be operated and applied in a remote location.
一般企業或公部門皆具有大量資料儲存於資料庫,為了防止資料庫因不可預期之重大災難損壞,導致企業運作停擺,進而產生無法估量的損失,因此,企業為了將損害降至最低,便於異地建置一副資料庫,並將主資料庫的內容備份至副資料庫,以能夠在主資料庫損壞的第一時間,即能夠透過副資料庫備份的內容持續進行作業;Generally, enterprises or public departments have a large amount of data stored in the database. In order to prevent the database from being damaged by an unexpected major disaster, the business operation will be shut down, which will cause immeasurable losses. Therefore, in order to minimize the damage, the enterprise is convenient for remote locations. Build a secondary database and back up the contents of the main database to the secondary database, so that the first time the primary database is damaged, it can continue to work through the backup contents of the secondary database;
目前異地備援機制可分為復原點目標(Recovery Point Objective,RPO)以及復原時間目標(Recovery Time Objective,RTO),目前復原點目標為常見的衡量指標,其係用來評量備份系統可容許最大的資料損失時間、損失量來評估多久進行一次備份。The current remote backup mechanism can be divided into Recovery Point Objective (RPO) and Recovery Time Objective (RTO). The current recovery point objective is a common measurement index, which is used to evaluate the tolerance of the backup system The maximum data loss time and amount of loss are used to evaluate how often a backup should be performed.
而習知的備援機制往往只能夠將主資料庫的內容備份至異地確保資料不會損壞、滅失,然而卻無法在主資料庫停擺後第一時間從異地的副資料庫中接手服務,是以,需要一種能夠於異地進行運作、應用及管理的異地備援系統。The conventional backup mechanism can only back up the contents of the main database to a remote location to ensure that the data will not be damaged or lost. However, it cannot take over the service from the remote secondary database immediately after the main database is shut down. Therefore, there is a need for a remote backup system that can operate, apply, and manage remotely.
本發明提供一種異地備援系統,其主要目的在於提供一種能夠於異地進行運作、應用及管理的異地備援系統。The present invention provides a remote backup system, and its main purpose is to provide a remote backup system that can be operated, applied and managed in a remote location.
為達前述目的,本發明異地備援系統,包括:To achieve the foregoing objectives, the remote backup system of the present invention includes:
一本地資料庫,具有資訊連接之一第一文字檔資料庫、一第一記錄檔資料庫及一第一作業目錄資料庫,該第一文字檔資料庫供以儲存檔案之實質資料,該第一記錄檔資料庫供以儲存檔案之驗證資料,各該驗證資料與實質資料係相互對應,該第一作業目錄資料庫則儲存作業系統之目錄,該作業系統之目錄供以讓使用者能夠應用程式查看、異動、編輯資料;A local database with a first text file database, a first log file database and a first working directory database with information connections, the first text file database is used to store the substantial data of the file, the first record The file database is used to store the verification data of the file. Each verification data corresponds to the actual data. The first working directory database stores the directory of the operating system. The directory of the operating system is available for users to view by the application. , Change, edit data;
一第一異地資料庫,具有資訊連接之一第二文字檔資料庫、一第二記錄檔資料庫,該第二文字檔資料庫供以儲存檔案之實質資料,該第二記錄檔資料庫供以儲存檔案之驗證資料,各該驗證資料與實質資料係相互對應;A first remote database, a second text file database with information connections, a second log file database, the second text file database is used to store the actual data of the file, and the second log file database is for To store the verification data of the file, each verification data and the actual data correspond to each other;
一檔案備份裝置,供以將本地資料庫的資料備份至該第一異地資料庫,檔案備份系統具有資訊連接之一驗證系統、一同步系統、及一執行佇列,該驗證系統與該第一記錄檔資料庫、第二記錄檔資料庫資訊連接,該驗證系統係反覆比對備份範圍內該第一記錄檔資料庫之驗證資料與第二記錄檔資料庫之驗證資料是否存在備份差異,若存在差異,則將備份差異存入執行佇列,該執行佇列為供以存放備份差異的暫存裝置,該同步系統與該第一文字檔資料庫、第二文字檔資料庫資訊連接,該同步系統供以執行備份差異使該第一異地資料庫的資料與本地資料庫的驗證資料一致,該同步系統將位於該第一文字檔資料庫之實質資料備份至該第二文字檔資料庫;以及A file backup device for backing up data from the local database to the first remote database. The file backup system has an information connection: a verification system, a synchronization system, and an execution queue. The verification system is connected to the first remote database. The log file database and the second log file database information are connected. The verification system repeatedly compares the verification data of the first log file database and the verification data of the second log file database within the backup range to see if there is a backup discrepancy. If there is a difference, the backup difference is stored in the execution queue, which is a temporary storage device for storing the backup difference. The synchronization system is connected with the information of the first text file database and the second text file database, and the synchronization The system is used to perform a backup difference to make the data of the first remote database consistent with the verification data of the local database, and the synchronization system backs up the actual data located in the first text file database to the second text file database; and
一第二異地資料庫,具有一第三文字檔資料庫、一第三記錄檔資料庫、一第二作業目錄資料庫,該第三文字檔資料庫與該第二文字檔資料庫資訊連接,該第三記錄檔資料庫與該第二記錄檔資料庫資訊連接,該第三文字檔資料庫供以備份並接收該第二文字檔資料庫的實質資料,該第三記錄檔資料庫供以備份並接收該第二記錄檔資料庫的驗證資料,該第二作業目錄資料庫接收自該第一作業目錄資料庫備份之作業系統之目錄。A second remote database has a third text file database, a third log file database, and a second work directory database. The third text file database is connected to the second text file database. The third log file database is connected to the information of the second log file database, the third text file database is used for backing up and receiving the actual data of the second text file database, and the third log file database is provided for Back up and receive the verification data of the second log file database, and the second work directory database is received from the operating system directory backed up by the first work directory database.
較佳的,該第二異地資料庫另具有一查詢單元,與該檔案備份裝置之驗證系統資訊連接,該查詢單元供以讓使用者查詢該第一記錄檔資料庫之驗證資料與第二記錄檔資料庫之驗證資料是否存在備份差異。Preferably, the second remote database further has a query unit connected to the verification system information of the file backup device, and the query unit allows the user to query the verification data and the second record of the first log file database Whether there are backup discrepancies in the verification data of the file database.
藉由前述可知,本發明異地備援系統主要係透過先將資料備份至該第一異地資料庫、再轉備份至該第二異地資料庫,並透過該第二異地資料庫之作業系統之目錄讓使用者能夠於異地及時執行應用程式查看、異動、編輯資料。From the foregoing, it can be seen that the remote backup system of the present invention is mainly performed by first backing up data to the first remote database, then backing up to the second remote database, and through the directory of the operating system of the second remote database Allow users to execute the application in a remote place to view, change, and edit data in a timely manner.
另外,更可藉由第二異地資料庫另該查詢單元,以讓使用者觀察同步的狀況。In addition, the query unit can be added to the second remote database to allow the user to observe the synchronization status.
本發明提供一種異地備援系統,如圖1至圖3所示,包括:The present invention provides a remote backup system, as shown in Figures 1 to 3, including:
一本地資料庫10,具有資訊連接之一第一文字檔資料庫11、一第一記錄檔資料庫12、一第一稽核日誌13及一第一作業目錄資料庫14,該第一文字檔資料庫11供以儲存檔案之實質資料,該第一記錄檔資料庫12供以儲存檔案之驗證資料,各該驗證資料與實質資料係相互對應,各該資料的異動紀錄由驗證資料儲存於該第一稽核日誌13,該第一作業目錄資料庫14則儲存作業系統之目錄,該作業系統之目錄供以讓使用者能夠執行應用程式查看、異動、編輯資料;A
一第一異地資料庫20,具有資訊連接之一第二文字檔資料庫21、一第二記錄檔資料庫22、一第二稽核日誌23,該第二文字檔資料庫21供以儲存檔案之實質資料,該第二記錄檔資料庫22供以儲存檔案之驗證資料,各該驗證資料與實質資料係相互對應,各該資料的異動紀錄由驗證資料儲存於該第二稽核日誌23;A first
一檔案備份裝置30,供以將本地資料庫10的資料備份至該第一異地資料庫20,檔案備份裝置30具有資訊連接之一驗證系統31、一同步系統32、及一執行佇列33,該驗證系統31與該第一記錄檔資料庫12、第二記錄檔資料庫22資訊連接,該驗證系統31係反覆比對備份範圍內該第一記錄檔資料庫12之驗證資料與第二記錄檔資料庫22之驗證資料是否存在備份差異,若存在差異,則將備份差異存入執行佇列33,該執行佇列33為存放備份差異的暫存裝置,該同步系統32與該第一文字檔資料庫11、第二文字檔資料庫21資訊連接,該同步系統32供以執行備份差異動作,以使該第一異地資料庫20的驗證資料與本地資料庫10的驗證資料一致,該同步系統32另將位於該第一文字檔資料庫11之實質資料備份至該第二文字檔資料庫21;A
一第二異地資料庫40,具有一第三文字檔資料庫41、一第三記錄檔資料庫42、一第二作業目錄資料庫43,該第三文字檔資料庫41與該第二文字檔資料庫21資訊連接,該第三記錄檔資料庫42與該第二記錄檔資料庫22資訊連接,該第三文字檔資料庫41供以備份並接收該第二文字檔資料庫21的實質資料,該第三記錄檔資料庫42供以備份並接收該第二記錄檔資料庫22的驗證資料,該第二作業目錄資料庫43與該第一作業目錄資料庫14資訊連接,該第二作業目錄資料庫43接收自該第一作業目錄資料庫14備份之作業系統之目錄,以讓使用者同樣的能夠在第二異地資料庫40執行應用程式查看、異動、編輯資料;A second
於較佳實施例中,該檔案備份裝置30另具有一稽核日誌檢核系統34,稽核日誌檢核系統34與該第一稽核日誌13、第二稽核日誌23資訊連接,該稽核日誌檢核系統34持續觀察該本地資料庫10的第一稽核日誌13及/或該第一異地資料庫20的第二稽核日誌23,以監控備份範圍內之異動紀錄,確認近期有無異動,若有則將異動的差異存入該執行佇列33。In a preferred embodiment, the
於較佳實施例中,請參照圖2,該第二異地資料庫40另具有一查詢單元44,與該檔案備份裝置30之驗證系統31資訊連接,該查詢單元44供以讓使用者查詢該第一記錄檔資料庫12之驗證資料與第二記錄檔資料庫22之驗證資料是否存在備份差異,換言之,該查詢單元44供以讓使用者觀看同步的狀況;In a preferred embodiment, referring to FIG. 2, the second
該查詢單元44與該稽核日誌檢核系統34資訊連接,該查詢單元44供以讓使用者查詢該本地資料庫10及/或該第二異地資料庫40之異動狀況。The query unit 44 is connected to the audit
於其他實施例中,該本地資料庫10亦具有該查詢單元15。In other embodiments, the
於較佳實施例中,如圖3所示,該第二異地資料庫40另具有一警示系統45,與該檔案備份裝置30之驗證系統31資訊連接,該警示系統45另與一預設資料庫46資訊連接,該預設資料庫46內預儲存一閥值,該警示系統45供以比對該第一記錄檔資料庫12之驗證資料與第二記錄檔資料庫22之驗證資料差異的筆數,若差異的數量大於該閥值則發出一警示通知予使用者,以讓使用者能夠及時察覺備份的異常情況。In a preferred embodiment, as shown in FIG. 3, the second
10:本地資料庫 11:第一文字檔資料庫 12:第一記錄檔資料庫 13:第一稽核日誌 14:第一作業目錄資料庫 20:第一異地資料庫 21:第二文字檔資料庫 22:第二記錄檔資料庫 23:第二稽核日誌 30:檔案備份裝置 31:驗證系統 32:同步系統 33:執行佇列 34:稽核日誌檢核系統 40:第二異地資料庫 41:第三文字檔資料庫 42:第三記錄檔資料庫 43:第二作業目錄資料庫 15、44:查詢單元 45:警示系統 46:預設資料庫 10: Local database 11: The first text file database 12: The first log file database 13: The first audit log 14: First job directory database 20: The first remote database 21: The second text file database 22: The second log file database 23: The second audit log 30: File backup device 31: Verification System 32: Synchronization system 33: Execution Queue 34: Audit log review system 40: The second remote database 41: The third text file database 42: The third log file database 43: The second job directory database 15, 44: query unit 45: warning system 46: Default database
圖1 為本發明異地備援系統之示意圖。 圖2 為本發明異地備援系統之較佳實施例之示意圖。 圖3 為本發明異地備援系統之較佳實施例之示意圖。 Figure 1 is a schematic diagram of the remote backup system of the present invention. Figure 2 is a schematic diagram of a preferred embodiment of the remote backup system of the present invention. Figure 3 is a schematic diagram of a preferred embodiment of the remote backup system of the present invention.
10:本地資料庫 10: Local database
11:第一文字檔資料庫 11: The first text file database
12:第一記錄檔資料庫 12: The first log file database
13:第一稽核日誌 13: The first audit log
14:第一作業目錄資料庫 14: First job directory database
20:第一異地資料庫 20: The first remote database
21:第二文字檔資料庫 21: The second text file database
22:第二記錄檔資料庫 22: The second log file database
23:第二稽核日誌 23: The second audit log
30:檔案備份裝置 30: File backup device
31:驗證系統 31: Verification System
32:同步系統 32: Synchronization system
33:執行佇列 33: Execution Queue
34:稽核日誌檢核系統 34: Audit log review system
40:第二異地資料庫 40: The second remote database
41:第三文字檔資料庫 41: The third text file database
42:第三記錄檔資料庫 42: The third log file database
43:第二作業目錄資料庫 43: The second job directory database
Claims (7)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
TW108130757A TWI719609B (en) | 2019-08-28 | 2019-08-28 | Remote backup system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
TW108130757A TWI719609B (en) | 2019-08-28 | 2019-08-28 | Remote backup system |
Publications (2)
Publication Number | Publication Date |
---|---|
TWI719609B true TWI719609B (en) | 2021-02-21 |
TW202109297A TW202109297A (en) | 2021-03-01 |
Family
ID=75745876
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
TW108130757A TWI719609B (en) | 2019-08-28 | 2019-08-28 | Remote backup system |
Country Status (1)
Country | Link |
---|---|
TW (1) | TWI719609B (en) |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6934877B2 (en) * | 2000-04-12 | 2005-08-23 | Annex Systems Incorporated | Data backup/recovery system |
JP4624829B2 (en) * | 2004-05-28 | 2011-02-02 | 富士通株式会社 | Data backup system and method |
CN103761162A (en) * | 2014-01-11 | 2014-04-30 | 深圳清华大学研究院 | Data backup method of distributed file system |
TW201719402A (en) * | 2015-11-27 | 2017-06-01 | Chunghwa Telecom Co Ltd | Data warehouse remote backup method and system improving poor efficiency of synchronous backup and restore point of data warehouse remote backup of distributed computing |
US9824108B2 (en) * | 2010-04-19 | 2017-11-21 | Salesforce.Com, Inc. | Methods and systems for performing transparent object migration across storage tiers |
-
2019
- 2019-08-28 TW TW108130757A patent/TWI719609B/en active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6934877B2 (en) * | 2000-04-12 | 2005-08-23 | Annex Systems Incorporated | Data backup/recovery system |
JP4624829B2 (en) * | 2004-05-28 | 2011-02-02 | 富士通株式会社 | Data backup system and method |
US9824108B2 (en) * | 2010-04-19 | 2017-11-21 | Salesforce.Com, Inc. | Methods and systems for performing transparent object migration across storage tiers |
CN103761162A (en) * | 2014-01-11 | 2014-04-30 | 深圳清华大学研究院 | Data backup method of distributed file system |
TW201719402A (en) * | 2015-11-27 | 2017-06-01 | Chunghwa Telecom Co Ltd | Data warehouse remote backup method and system improving poor efficiency of synchronous backup and restore point of data warehouse remote backup of distributed computing |
Also Published As
Publication number | Publication date |
---|---|
TW202109297A (en) | 2021-03-01 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8019727B2 (en) | Pull model for file replication at multiple data centers | |
US7672979B1 (en) | Backup and restore techniques using inconsistent state indicators | |
US8327098B2 (en) | Data recovery systems and methods | |
KR101150025B1 (en) | Method, system, and apparatus for creating an architectural model for generating robust and easy to manage data protection applications in a data protection system | |
KR101149975B1 (en) | Method, system, and apparatus for providing alert synthesis in a data protection system | |
US20070244996A1 (en) | Web enabled exchange server standby solution using mailbox level replication | |
US7069278B2 (en) | System for archive integrity management and related methods | |
US7543125B2 (en) | System and method for performing time-flexible calendric storage operations | |
US7627776B2 (en) | Data backup method | |
US20070094533A1 (en) | System and method for data backup | |
US20130080394A1 (en) | Data Mirroring Method | |
JP2005538467A (en) | Method and apparatus for managing data health of backup data and disaster recovery data | |
CN110704242B (en) | Continuous data protection system and method | |
US20060294421A1 (en) | Isolating and storing configuration data for disaster recovery | |
US20110137865A1 (en) | Method for managing storage service | |
CN108932432A (en) | Data guard method and host server system | |
Muthalagu | PLM (Product Lifecycle Management) System Administrator Process for Document Management System (DMS) in Energy Devices Domain | |
US10621048B1 (en) | Method and system for implementing a backup validation engine | |
KR101050476B1 (en) | Storage management server-based script management method and a computer-readable recording medium recording a program for realizing the same | |
TWI719609B (en) | Remote backup system | |
US7685460B1 (en) | Multiple concurrent restore using same user interface | |
US20080288559A1 (en) | Exchange server standby solution using mailbox level replication with crossed replication between two active exchange servers | |
US10296517B1 (en) | Taking a back-up software agnostic consistent backup during asynchronous replication | |
KR20160004721A (en) | Method for Replicationing of Redo Log without Data Loss and System Thereof | |
KR101182692B1 (en) | Method and system for presrving digital information evidence for computer of retired or inspection object |