####################
开启归档日志:
shutdown immediate; startup mount; alter database archivelog; alter database open; archive log list # 更改归档目录路径log_archive_dest_n alter system set log_archive_dest_1='location=D:\software\arch1\'; #手动切换日志 alter system switch logfile;
关闭归档日志:
shutdown immediate; startup mount; alter database noarchivelog; alter database open;
###################
标签:log,database,archive,归档,oracle,gaurd,data,alter,日志 From: https://www.cnblogs.com/igoodful/p/17287698.html