打开和关闭归档模式
关闭数据库
SQL>shutdown immediate;
启动到mount方式
SQL>startup mount;
打开归档模式
SQL>alter database archivelog;
关闭归档模式
SQL>alter database noarchivelog;
查看归档与闪回是否打开
1)查看v$database
SQL> select log_mode,FLASHBACK_ON from v$database;
LOG_MODE FLASHBACK_ON
------------ ------------------
ARCHIVELOG NO
2)
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 24
Next log sequence to archive 26
Current log sequence 26