归档日志迁移--实战篇

--sqlplus sys/Jacjqwl123@JQWLSCL as sysdba
set ORACLE_SID=JQWLSCL
sqlplus /nolog
connect / as sysdba

alter system set log_archive_dest_1='location=E:\app\archivelog\jqwlscl' scope=both;

shutdown immediate;
--再次查看数据库的归档情况
archive log list;
--可以通过切换日志,查看归档路径下是否有归档日志产生来验证归档路径设置是否正确,可以通过下面的命令切换日志。
alter system switch logfile;

show parameter log_archive_format;

startup mount;
alter database open;
-----------------------------------------PCL
--sqlplus sys/Jacjqwl123@JQWLDB as sysdba
set ORACLE_SID=JQWLDB
sqlplus /nolog
connect / as sysdba

alter system set log_archive_dest_1='location=E:\app\archivelog\jqwldb' scope=both;
shutdown immediate;
startup mount;
alter database open;