How To Change Database In ArchiveLog Mode

          1.  Check Database is In Archive Log Mode Or Not

                                                        SQL > select name,log_mode from v$database;

                                                        NAME                                       LOG_MODE
                                                      ----------------------                          -----------------------------
                                                                 MYDB                                     NOARCHIVELOG

       2. To enable ARCHIVELOG mode status, enter the following SQL commands:              

            SQL> Shutdown immediate
 SQL> Startup mount
                    SQL> Alter database archivelog;
            SQL> alter database open;

3. To check the ARCHIVELOG mode status, enter the following SQL command:

             SQL> archive log list;       

For Learn More About Oracle :- Click Here

For Learn More About Oracle :- Click Here