Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > Oracle在NOARCHIVELOG模式下冷备份还原数据库

Oracle在NOARCHIVELOG模式下冷备份还原数据库

WBOY
Release： 2016-06-07 17:05:48
Original
953 people have browsed it

冷备就是把数据库的相关文件复制一份，它只能做还原操作，不能做恢复操作。现在登录到数据库中，把数据文件、控制文件、日志文件

冷备就是把数据库的相关文件复制一份，它只能做还原操作，不能做恢复操作。现在登录到数据库中，把数据文件、控制文件、日志文件存放路径找到，然后关闭数据库，备份列出的文件。

临时文件可以不备份，实际中还应该备份参数文件。这里我把上面所有的文件复制到/u01/datafile/下面，，然后删除备份前的所有文件，模拟磁盘故障。

可以看见数据库不能正常启动

linux

Related labels：
Oracle教程 Oracle在NOARCHIVELOG模式
source：php.cn
Previous article：MySQL数据库备份和还原实践记录 Next article：PowerDesigner的物理数据模型PDM
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Regular expression filter for MERN stack search boxes and checkboxes I'm trying to understand how the MERN stack works together by learning by doing, and I'm f...
From 2024-04-06 14:53:12
0
1
425
How to render data through DOM instead of through table I have a question about an application I'm creating, I'm using an Oracle database and I'm ...
From 2024-04-04 18:17:27
0
1
3567
Prestashop installation issue: Unable to install custom module I am new to Prestashop module development. I'm trying to build Amy's first prestashop modu...
From 2024-04-03 19:24:44
0
1
402
PHP Tutorial: How to upload text and images to Linkedin using PHP? I try to upload text, images and links using LinkedinsRestAPI (https://learn.microsoft.com...
From 2024-04-03 18:42:29
0
1
420
Unable to receive information from my mySQL database despite having seen tutorials doing the exact same thing So I'm trying to make a program that reads and writes to a MySQL database, which led me to...
From 2024-04-03 14:46:04
0
1
298
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template