To change the non-archive mode of an Oracle database, you must restart the database and modify it in mount mode.
1. Shut down the database in shutdown immediate Mode
2. Start the instance to the mount status.
3. Change the non-running mode and open the database
Procedure:
1. log on to the database to view the archiving status of the database.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 2923
Next log sequence to archive 2925
Current log sequence 2925
2. Shut down the database
SQL> shutdown immediate;
3. Start the database to the mount status.
SQL> startup mount;
4. Start the archive Mode
SQL> alter database noarchivelog; (non-archive mode: alter database noarchivelog)
If an error is reported:
SQL> alter database noarchivelog;
Alter database noarchivelog
*
ERROR at line 1:
ORA-38774: cannot disable media recovery-flashback database is enabled
Close flashback first
SQL> alter database flashback off;
Database altered.
Change to non-archive Mode
SQL> alter database noarchivelog;
Database altered.
5 open the database
SQL> alter database open;