1. sysdba登录数据库

sqlplus / as sysdba

2. 备份spfile文件

show parameter spfile

create pfile=‘/home/oracle/pfile20190920.ora‘ from spfile=‘/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/dbs/spfileorcl.ora‘;

3. 查看归档路径及状态

sql> archive log list

4. 关闭数据库，以mount状态运行

shutdown immediate

startup mount

5. 开启归档模式

alter database archivelog;

6. 查看状态

archive log list

alter pluggable database all open;

show pdbs;