How Do I Clear a Redo Log

If you want to clear an unarchived redo log that is needed to bring an offline tablespace online, use the UNRECOVERABLE DATAFILE clause in the ALTER DATABASE CLEAR LOGFILE statement. If you clear a redo log needed to bring an offline tablespace online, you will not be able to bring the tablespace online again.

What are the archived redo log used for?

Archived redo logs are used to recover a database or update a standby database. Before you restore, you must locate the file. When you locate the files, ensure that the database is in the Open state.

What is the difference between archive log and redo 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.