• 备份spfile

Create pfile='d:pfileSID.ora' from spfile;

• OS上创建归档目录：+DATA_DG/arch

• 设置归档路径：alter system set log_archive_dest_1='location=+DATA_DG/arch' scope=spfile sid='*';

• 设置归档日志名称（看需要）：alter system set log_archive_format=‘fix_name%s_%R.%T’

• 停库之后启动到mount状态 : startup mount

开归档： alter database archivelog;

• archive log list; -- 查看归档开启状态

• alter database open; -- 启库到open状态

• --切归档检测下

alter system switch logfile;

1. 库启动到mount状态: statup mount

2. 关闭归档：alter database noarchivelog;

3. alter database open;