ORACLE Nologging相关知识

 

1) Nologging跟数据库的运行模式有关，8i和9i的默认安装都是非归档模式，并且自动归档默认是禁用

SQL> archive log list;

Database log mode             No Archive Mode

Automatic archival             Unabled

Archive destination            C:/oracle/ora92/RDBMS

Oldest online log sequence     85

Current log sequence           87

 

2)关闭数据库

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

 

3)

SQL> startup mount

ORACLE instance started.

 

Total System Global Area  135338868 bytes

Fixed Size                   453492 bytes

Variable Size             109051904 bytes

Database Buffers           25165824 bytes

Redo Buffers                 667648 bytes

 

Database mounted.

 

4)修改为归档模式

SQL> alter database archivelog;

Database altered.

 

5)打开数据库

SQL> alter database open;

Database altered.

 

6)

SQL> archive log list;

Database log mode             Archive Mode

Automatic archival             Unabled

Archive destination            C:/oracle/ora92/RDBMS

Oldest online log sequence     85

Next online log sequence     87

Current log sequence           87

 

7)由于Automatic archivalà Unabled

SQL> archive log start;

SQL> archive log list;

Database log mode             Archive Mode

Automatic archival             Enabled

Archive destination            C:/oracle/ora92/RDBMS

Oldest online log sequence     85