Set Oracle database to archive mode and non-archive Mode

Set Oracle database to archive mode and non-archive Mode

1. Set 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 is used to view the location where archived logs are stored.

2. Set the Oracle database to non-archive Mode
1) shut down the database
Shutdown immediate
2) Start the database to the mount mode later.
Startup mount
3), disable flash back to the database mode, if not closed, in the back of the archive log close will appear annoying ora-38774 error.
Alter database flashback off
4) change the database to non-archive mode.
Alter database noarchivelog;
5) after the changes are made, open the database.
Alter database open;
6) Check the space for archiving logs.
Select * from v $ recovery_file_dest;
Next, let's take a look at the log status.
Select * from v $ log;
Check the usage of the flash back log.
Select * from v $ flash_recovery_area_usage;