How to again bring back the database in NOARCHIVELOG mode?

@ : Home > > Interview Room

STEP 1: Shutdown the database if it is running.

STEP 2: reset the following parameters.

SQL> alter system reset LOG_ARCHIVE_DEST_1
SQL> alter system reset LOG_ARCHIVE_FORMAT

STEP 3: Startup and mount the database.

SQL> STARTUP MOUNT;

STEP 4: Give the following Commands to disable ARCHIVELOG MODE.

SQL> ALTER DATABASE NOARCHIVELOG;
SQL> alter database open;
Alert me