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

1

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.