Proceedings of the 2015 International Conference on Electrical, Computer Engineering and Electronics

The Study of Backup Method based on RMAN and Streams

Authors
Bo Chen, Ningyu Hu, Shaoming Qiu
Corresponding Author
Bo Chen
Available Online June 2015.
DOI
10.2991/icecee-15.2015.109How to use a DOI?
Keywords
Real-time backup; Database backup; physical backup
Abstract

For the problems of big backup files and long recovery time after traditional real-time backup method has been backup for a long time, A new method base on RMAN and Streams technology is presented in this paper. This method uses the Streams technology to make real-time backup for database. in the meantime, Timing detect the busy degree of the database system. When the database system is not busy and real-time backup file is larger than the preset threshold, using RMAN for a physical backup. In the recovery, this method implements physical recovery at first, and then, real-time backup file’s SQL acts on database. This method avoids the disadvantages of real-time backup file growing over time, recovering from the beginning, and effectively solves the problems of big real-time backup files and long recovery time.

Copyright
© 2015, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

Volume Title
Proceedings of the 2015 International Conference on Electrical, Computer Engineering and Electronics
Series
Advances in Computer Science Research
Publication Date
June 2015
ISBN
978-94-62520-81-3
ISSN
2352-538X
DOI
10.2991/icecee-15.2015.109How to use a DOI?
Copyright
© 2015, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Cite this article

TY  - CONF
AU  - Bo Chen
AU  - Ningyu Hu
AU  - Shaoming Qiu
PY  - 2015/06
DA  - 2015/06
TI  - The Study of Backup Method based on RMAN and Streams
BT  - Proceedings of the 2015 International Conference on Electrical, Computer Engineering and Electronics
PB  - Atlantis Press
SP  - 527
EP  - 532
SN  - 2352-538X
UR  - https://doi.org/10.2991/icecee-15.2015.109
DO  - 10.2991/icecee-15.2015.109
ID  - Chen2015/06
ER  -