alter system switch logfile只是切换在线日志,而并不归档。
以下都可用:
alter system archive log sequence lognumber
alter system archive log all
alter system archive log current
------------------------------------------------------------------------------华丽分割线-----------------------------------------------------------------------
如果归档日志为自动归档,则切换日志(alter system switch logfile)会自动归档;
如果为手动归档模式,则不会归档,除非你执行下列命令手动归档:
alter system archive log sequence lognumber
alter system archive log all
alter system archive log current
查看归档日志模式:select log_mode from v$database;
NOARCHIVELOG-- 为不归档
ARCHIVELOG-- 为自动归档
MANUAL --手动归档模式
修改归档日志模式:
alter database noarchivelog;
alter database archivelog;
alter database archivelog manual;
------------------------------------------------------------------------------华丽分割线------------------------------------------------------------------------