zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

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

Oracle模式 如何 启动 关闭 归档
2023-09-27 14:27:17 时间

 

参考文献:

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>
复制代码