首先我们执行下面的代码:
SQL> shutdown immediate;
Database closed. Database dismounted. ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.Total System Global Area 205520896 bytes Fixed Size
1218532 bytes Variable Size
71305244 bytes Database Buffers
130023424 bytes Redo Buffers
2973696 bytes Database mounted.
SQL> alter database archivelog;Database altered.
SQL> alter database open;Database altered.
SQL> archive log list; Database log mode
Archive Mode Automatic archival
Enabled Archive destination
/oracle/app/oradata/LARRY/arch1 Oldest online log sequence
184 Next log sequence to archive
186 Current log sequence
186 切换归档模式查看存档模式
SQL> archive log list;
数据库日志模式
非存档模式
此时为非存档模式
自动存档
禁用 存档终点
c:\oracle\ora92\RDBMS 最早的概要日志序列