1、开启强制写日志: alter database force logging; 2、查看归档状态 archive log list; 3、开启归档: 3.1、查看参数: show parameter recover 3.2、修改参数 alter system set db_recovery_file_dest_size=2g scope=both; alter system set db_recovery_file_dest='/opt/oracle' scope=spfile; (scope就是both、spfile两个选项) 3.3、关闭数据库,并启动到mount状态 shutdown immediate; startup mount; alter database archivelog; alter database open; 3.4、切换一下日志,查看有无归档产生 alter system switch logfile; exit; ls /opt/oracle/CDECDB1/archivelog/2020_02_09/ |