How To Enable Archivlelog Mode In Oracle Datbase 11g

How To Enable Archivlelog Mode In Oracle Datbase 11g

for enabling archive log mode in oracle 11g

steps are:-

1. SQL> ARCHIVE LOG LIST;
   Database log mode NoArchive Mode
   Automatic archival Disabled
   Archive destination /Database/archivelog/
   Oldest online log sequence 1129
   Next log sequence to archive 1131
   Current log sequence 1131
2. Database is in noarchive log mode to change it to archivelog mode the first requirement is that database must be mounted not opened for mounting the database shutdown the database and then mount it for this issue the following command
   SQL> SHUTDOWN IMMEDIATE
   SQL> STARTUP MOUNT

after putting the database to mount stage issue the following command

ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
now issue the command to check whether database is in archivelog mode or not
2. SQL> ARCHIVE LOG LIST;
   Database log mode NoArchive Mode
   Automatic archival Disabled
   Archive destination /Database/archivelog/
   Oldest online log sequence 1132
   Next log sequence to archive 1133
   Current log sequence 1134