用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 25
Current log sequence 27
rac 修改归档模式，需要关闭所有的实例
rac1 上执行
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 1266512 bytes
Variable Size 83889328 bytes
Database Buffers 100663296 bytes
Redo Buffers 2924544 bytes
Database mounted.
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any instance
rac2 上
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
rac1 上继续
SQL> alter database archivelog;
Database altered.
SQL> alter database open ;
Database altered.
SQL>
rac2 上 open 数据库