Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > Oracle 11g 修改DB为 archivelog 模式

Oracle 11g 修改DB为 archivelog 模式

WBOY
Release： 2016-06-07 17:21:06
Original
951 people have browsed it

Oracle 11g 修改DB为 archivelog 模式，在ORACLE 10G 中设置自动归档有以下三种方法：

Oracle 11g 修改DB为 archivelog 模式，在ORACLE 10G 中设置自动归档有以下三种方法： 

1、在使用DBCA安装数据库时 ， 配置为自动归档模式，既在设置FLASHBACK中定义LOG_ARCHIVE_DEST_1,即可在建库后实现自动归档； 

2、在数据库启动后，，SHUTDOWN，修改INIT.ORA，定义LOG_ARCHIVE_DEST_1， 

  然后STARTUP PFILE=‘ORACLE_HOME/ADMIN/DBID/PFILE/INIT.ORA'，也可以修改为自动归档模式，然后记得重建SPFILE； 

3、在OPEN状态下设置: 

linux

Related labels：
oracle
source：php.cn
Previous article：Oracle EM 常见问题总结 Next article：ORA-12514：RMAN连接报错解决
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
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
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