i am posting this question to understand if there is an option in Oracle for the below two conditions.
1. As of now when oracle archive logs get full in archive log dest, end users won't be able to access Oracle. however, do we have an option to overwrite this settings and users will be still able to access Oracle?
2. Overwrite the archive logs: Do we have an option in Oracle to overwrite the existing archive logs in Oracle.
No and no. But if you do not care about being able to recover your database you can disable the creation of archivelogs altogether.