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

 

posted @ 2022-03-23 16:00  疾风泣影  阅读(38)  评论(0)    收藏  举报