Question by  Paul87 (13)

How do I get to "noarchivelog" mode?

I need to make some changes.


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.

You have 50 words left!