-- 查看当前模式 archive log list -- 改为归档模式 shutdown immediate startup mount alter database archivelog; alter database open;-- 修改归档位置 alter system set log_archive_dest_1='LOCATION=D:\movie' scope=both alter system set log_archive_dest_2='LOCATION=D:\' scope=both alter system set log_archive_dest_2='' scope=both-- 自动归档 archive log start; -- 下次启动时自动归档 alter system set log_archive_start=true scope=spfile
archive log list
-- 改为归档模式
shutdown immediate
startup mount
alter database archivelog;
alter database open;-- 修改归档位置
alter system set log_archive_dest_1='LOCATION=D:\movie' scope=both
alter system set log_archive_dest_2='LOCATION=D:\' scope=both
alter system set log_archive_dest_2='' scope=both-- 自动归档
archive log start;
-- 下次启动时自动归档
alter system set log_archive_start=true scope=spfile