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