Oracle 设立归档模式

Oracle 设置归档模式
登录Sqlplus，查看数据库归档状态

SQL> sqlplus /nolog
SQL> conn / as sysdba

查看当前数据库的归档状态

SQL> archive log list;
Database log mode	       No Archive Mode
Automatic archival	       Disabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     9
Current log sequence	       11

关闭数据库，并以装载方式启动

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1.3362E+10 bytes
Fixed Size		    2217952 bytes
Variable Size		 6777997344 bytes
Database Buffers	 6576668672 bytes
Redo Buffers		    4960256 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     9
Next log sequence to archive   11
Current log sequence	       11