How to Enable Archive log in oracle Database ?

 Greetings from Hamid Blog. :)

WARNING:

You must ensure that there is sufficient disk space at all times for archived log file destinations. If the database encounters a disk full error as it attempts to archive a log file, a fatal error occurs and the database stops responding. 

You can check the alert log for a disk full message by executing the bellow SQL.

SELECT LOG_MODE FROM V$DATABASE;

Please follow

1. SHUTDOWN IMMEDIATE;

2. STARTUP MOUNT;

3. ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=</u02/oracle/logfiles>';

4. (Optional) ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 = 'LOCATION=</u03/oracle/logfiles>';

5. ALTER DATABASE ARCHIVELOG;

6. ALTER DATABASE OPEN;

7. SHUTDOWN IMMEDIATE;

8. STARTUP;

To get the list by executing following SQL

archive log list

Thanks,

🔗FOLLOW also: 

 Facebook: https://www.facebook.com/ariderseye 

Website: www.ariderseye.com

YouTube: https://www.youtube.com/c/ariderseye