如何启动或关闭oracle的归档(ARCHIVELOG)模式

68 阅读 0 评论 45 点赞

我是靠谱客的博主跳跃菠萝，最近开发中收集的这篇文章主要介绍如何启动或关闭oracle的归档(ARCHIVELOG)模式，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

1.管理员身份连接数据库

C:UsersAdministrator>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;

注：如果这里报错、需要把闪回日志关了。

SQL> select flashback_on from v$database;

SQL> alter database flashback off;
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>