oracle 归档日志相关
1.开启归档:
1.1 archive log list;
1.2 shutdown immediate;
1.3 startup mount;
1.4.alter database archivelog;
1.5 alter system set db_recovery_file_dest=' ';
1.6 alter system set log_archive_dest='e:\arch ';
1.7 alter database open;
2.同步需求
2.1 最小附加日志
alter database add supplementallog data;
alter database add supplementallog data (all)columns;
2.2 查看
select supplemental_log_data_min from v$database;
3.手动切换,生成一个归档日志
3.1 alter system switch logfile