oracle归档模式和非归档模式切换
oracle启动顺序简述
上一篇说到oracle的日志文件有联机重做日志和归档重做日志,只有在归档模式下,系统才会去写归档重做日志。
使用archive log list查看是否在归档模式下:
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 176
Current log sequence 177
一、非归档模式改为归档模式
1、命令:
shutdown;
startup mount;
alter database archivelog;
alter database open;
archive log list;
2、执行过程:
SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2231096 bytes
Variable Size 624952520 bytes
Database Buffers 205520896 bytes
Redo Buffers 2400256 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 USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 176
Next log sequence to archive 177
Current log sequence 177
继续阅读oracle入门(3) →