Archived Log File

How to Resolve ORA-00308: cannot open archived log

by Ed Chen
August 13, 2021June 5, 2022

ORA-00308 Found ORA-00308: cannot open archived log during performing a database point-in-time recovery (DBPITR) by RMAN. ORA-00308: cannot open archived log '/oradata/ORCL/ARCH/ORCL_1_294150.arc' ORA-27037: unable to… Read More »

How to Resolve RMAN-06059: expected archived log not found

by Ed Chen
July 11, 2019December 10, 2022

RMAN-06059 RMAN-06059 means that the archived logs you expect to use are missing from where they should be. In my case, when I tried to… Read More »

How to Resolve ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST

by Ed Chen
April 16, 2018December 11, 2022

ORA-16018 Got an error "ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST" when I tried to set the parameter like this: SQL> alter system set… Read More »

How to Set USE_DB_RECOVERY_FILE_DEST

by Ed Chen
April 15, 2018December 11, 2022
2 Comments

USE_DB_RECOVERY_FILE_DEST What is USE_DB_RECOVERY_FILE_DEST? The keyword is a constant value which indicates that we would like to use Fast Recovery Area (FRA) space as the… Read More »

Online Archived Logs vs Backup Archived Logs

by Ed Chen
April 14, 2018December 11, 2022

Let me make it short first. If you can tell the difference between the following two RMAN statements, then you have already know the difference.… Read More »

When Oracle Software Directory Is Full

by Ed Chen
April 3, 2018April 1, 2018

What will happen if the mount point of oracle software is 100% used or full? I guess you may feel panic due to a potentially… Read More »

How to Check Archive Log Size

by Ed Chen
June 30, 2016January 24, 2023

In this post, I will talked about the following 3 topics. How to Define Archive Log Size? Are all Archive Logs the Same Size? How… Read More »

2 Unawared Cases May Produce Large Amount of Archived Logs

by Ed Chen
June 29, 2014December 11, 2022

At times, you may notice that the destination of archived logs was growing so fast unreasonably, and it could be worse, it grew too fast… Read More »

How to Archive Redo Logs to Respective Local Destinations of RAC

by Ed Chen
December 4, 2012March 29, 2018

For a RAC database, we may want to archive the redo logs to local destinations of instances rather than ASM. That is, put instance #1,… Read More »