1、连接到sysdba
sqlplus / as sysdba
2、手动备份SPFILE
SQL> create pfile from spfile;
3、查看实例是否为归档
SQL> select name,created,log_mode,open_mode from v$database;
4、关闭实例并重新启动至mount状态
SQL> shutdown immediate;
SQL> startup mount;
5、设置非归档模式
SQL> alter database noarchivelog;
6、将实例以open方式打开
SQL> alter database open;