set archivelog .txt

来自「Oracle培训专题3-数据库配置.ppt Oracle培训专题4-备份和恢复」· 文本 代码 · 共 27 行

alter system set log_archive_dest_1='LOCATION=d:\Oracle\archivelog\arc MANDATORY' Scope=SPFILE;
alter system set log_archive_dest_state_1=Enable Scope=SPFILE;
alter system set LOG_ARCHIVE_START=true scope=spfile;

Sql>shutdown immediate

Sql>startup mount

Sql>alter database archivelog;

Sql>alter database open;

--alter system archive log start;

alter system switch logfile;

Sql>Archive Log List

select * from v$archive_dest;
select * from v$archived_log;
select * from v$archive_processes;
select * from v$log;
select * from v$logfile;

alter system archive log all; [to path]