How do I get to "noarchivelog" mode?

Answer by  AnilaDS (23)

1. Login to SQL plus -sqlplus/nolog -connect/as sysdba 2. The db must be mounted exclusively and not open for operation -startup mount; 3.Check the log mode status of the data base -select log_mode from v$database; 4. Setting it to noarchivelog mode -alter database noarchivelog;

Answer by  nimesh217 (4)

In noarchivelog mode the database must be shutdown. You must take the backup of whole database. you can only restore the full database only.