1 查看数据库归档模式
--通过命令查看
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Current log sequence 1
--通过SQL查看
SQL> select name ,log_mode from v$database;
NAME LOG_MODE
--------- ------------
ORCL NOARCHIVELOG--关闭数据库
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
--装载数据库
SQL> startup mount
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 520096848 bytes
Database Buffers 310378496 bytes
Redo Buffers 2371584 bytes
Database mounted.
--切换归档
SQL> alter database archivelog;
Database altered.
--打开数据库
SQL> alter database open;
Database altered.
--查看归档日志
SQL> select name from v$archived_log;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf_1_1_fgfp8m8t_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf_1_2_fgfp8mk9_.arc
--归档日志
SQL> alter system archive log current;
System altered.
SQL> /
System altered.
SQL> select name from v$archived_log;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf_1_1_fgfp8m8t_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf_1_2_fgfp8mk9_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf_1_1_fgfqc2wg_.arc
/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_04_30/o1_mf_1_2_fgfqc4qy_.arc
SQL> alter system archive log current:会对数据库中的所有实例进行日志切换。