归档日志文件需要增加
SQL>alter system set db_recovery_file_dest_size=40g scope=both;
SQL>show parameter db_recovery_file_dest_size;
SQL> shutdown immediate;
SQL> startup mount;
开启或关闭归档日志
SQL> alter database noarchivelog;
或
SQL> alter database archivelog;
Database altered.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 228
Current log sequence 230
开启数据库
SQL> alter database open;