Set the Oracle database to archive mode and non-archive mode

first, set the Oracle database to archive mode

1) Sql>shutdown normal/immediate;
2) Sql>startup Mount;
3) Sql>alter database archivelog;
4) Sql>alter database open;
5) archive log list;

Note: Show parameter log_archive_dest see where the archive logs are stored.

Second, set the Oracle database to non-archive mode
1), Close the database
Shutdown immediate
2), and then back up the database to mount mode
Startup Mount
3), turn off Flash Flash database mode, if not closed, when you close the archive log when there will be a nasty ora-38774 error.
ALTER DATABASE Flashback off
4), then change the database to non-archive mode
ALTER DATABASE Noarchivelog;
5), all modified later, and then open the database
ALTER DATABASE open;
6), look at the size of the archive log space
SELECT * from V$recovery_file_dest;
Then look at the status of log logs
SELECT * from V$log;
And look at the flashback log usage.
SELECT * from V$flash_recovery_area_usage;

Set the Oracle database to archive mode and non-archive mode