Oracle 12c 关闭归档模式

Oracle 12c 关闭归档模式:

SQL> archive log list;

Database log mode        Archive Mode

Automatic archival        Enabled

Archive destination        /u01/archive

Oldest online log sequence     1227

Next log sequence to archive   1228

Current log sequence        1228

SQL> shutdown immediate; 

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.


Total System Global Area 2147483648 bytes

Fixed Size     3712904 bytes

Variable Size   486541432 bytes

Database Buffers 1644167168 bytes

Redo Buffers    13062144 bytes

Database mounted.

SQL> alter database noarchivelog;


Database altered.


SQL> alter database open;


Database altered.


SQL> archive log list;

Database log mode        No Archive Mode

Automatic archival        Disabled

Archive destination        /u01/archive

Oldest online log sequence     1228

Current log sequence        1229


请使用浏览器的分享功能分享到微信等