Question

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

Answer 1

1、启动归档模式
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

2、关闭归档模式
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>

Answer 2

　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>