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

90 阅读 0 评论 60 点赞

我是靠谱客的博主跳跃菠萝，这篇文章主要介绍如何启动或关闭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 optionsC: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
230SQL> 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.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.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.启动归档模式

复制代码

1
2
SQL> alter database archivelog;

复制代码

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

复制代码

1
SQL> select flashback_on from v$database;

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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.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>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>