如何启动或关闭oracle的归档(ARCHIVELOG)模式
2024-09-24 04:07:03
参考文献:
http://www.eygle.com/archives/2004/10/oracle_howtoeci.html
1.管理员身份连接数据库
C:\Users\Administrator>sqlplus sys/sys@prjdb as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 17 23:50:55 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
2.查看当前归档模式,是归档还是非归档
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 228
Current log sequence 230
3.关闭数据库
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
4.启动数据库到mount状态
SQL> startup mount;
ORACLE instance started. Total System Global Area 3423965184 bytes
Fixed Size 2180544 bytes
Variable Size 2013268544 bytes
Database Buffers 1392508928 bytes
Redo Buffers 16007168 bytes
Database mounted.
5.启动归档模式
SQL> alter database archivelog; Database altered. SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 228
Next log sequence to archive 230
Current log sequence 230
6.启动数据库
SQL> alter database open;
Database altered.
7.关闭归档模式
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started. Total System Global Area 3423965184 bytes
Fixed Size 2180544 bytes
Variable Size 2013268544 bytes
Database Buffers 1392508928 bytes
Redo Buffers 16007168 bytes
Database mounted.
SQL> alter database noarchivelog; Database altered. SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 228
Current log sequence 230
SQL>
最新文章
- 【小白的CFD之旅】17 需要编程?
- webservice调用服务端数据时给soapenv:Envelope 添加自定义的命名空间
- python time
- STM32/GD32上内存堆栈溢出探测研究
- 爆破vcrkme01(已补上注册机)
- PMP考试--挣值如何计算?
- Form验证(转)
- SQL技巧之排名统计
- 完全卸载oracle
- GetClientRect()和GetWindowRect()
- [Jobdu] 题目1511:从尾到头打印链表——单链表的倒置输出
- WEB和APP谁是互联网未来
- mysql之数据类型
- asp.net core 中灵活的配置方式
- Spark Standalone Mode Configuration
- jsp页面固定页面为绝对路径
- Linux常用shell命令
- cv2.error: openCV报错
- rabbitMQ常用方法说明 – 6中工作模式及关键点
- 使用git命令push到自己的仓库,显示Unknown且没有贡献记录的解决方案
热门文章
- 解决方法:64位系统-未在本地计算机上注册“Microsoft.Jet.OLEDB.4.0”提供程序
- Google Chrome 扩展程序开发
- 【转】基于CXF Java 搭建Web Service (Restful Web Service与基于SOAP的Web Service混合方案)
- Inkpad中文翻译已合并到官方项目
- .NET中TextBox控件设置ReadOnly=true后台取不到值的解决方法
- STL中的算法小结
- c# File 操作
- SQL Server里如何随机记录集
- Win10 + VS2015 下编译 Qt5.6.0
- [C#] 语法之Attribute