Where can I find the archive log?
- Issue the archive log list command: SQL> archive log list.
- Issue the show parameter command: SQL> show parameter db_recovery_file_dest.
- Query the v$archive_dest view: SQL> select dest_name, status, destination from v$archive_dest;
Hereof, where are Oracle archive logs stored?
To get started, from the last article, remember that Oracle placed archive logs in a default directory of $ORACLE_HOME/dbs and, if flash recovery was enabled during installation, in the USE_DB_RECOVERY_FILE_DEST, which equated to the init. ora parameter db_recovery_file_dest.
Beside above, what is the difference between redo log and archive log? Archive logs are archived redo(online) log files. In redo log files are all changes that happened to your data. If your database is in archivelog mode, than redo logs can't be overwritten, they are archived in some other location when they are full. Redo and archive logs are used in various database recovery scenarios.
One may also ask, what is archive log?
Oracle Database lets you save filled groups of redo log files to one or more offline destinations, known collectively as the archived redo log, or more simply the archive log. The process of turning redo log files into archived redo log files is called archiving.
What if archive log destination is full?
What happens if a archive log destination is filled up in oracle. log destination disk space becomes full, the automatic archiving will stop. When this happens we will get errors like ORA-00257. ORA-00257: archiver error.