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
