Archived Logs

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 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 »

How to Resolve "Can not allocate log, archival required"

by Ed Chen
March 23, 2018December 11, 2022

Can not allocate log, archival required Saw an error-like message in alert log: ORACLE Instance ORCL - Can not allocate log, archival required Actually, this… Read More »

How RMAN Restore Archivelog to Different Location

by Ed Chen
October 15, 2016July 8, 2021

Here is my case, I would like to resolve the gap between the primary and the standby database, but the log_archive_dest_1 is very limited, I… Read More »

When Database is Not Consistent

by Ed Chen
October 2, 2016December 12, 2022

There are several different kinds of situation when you recover a database with inconsistent states among files. In the following, I have to assume that… 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 »

How to Resolve ORA-16055: FAL request rejected

by Ed Chen
January 17, 2014December 11, 2022
3 Comments

In Oracle MAA, data guard plays a very important role to secure our data on the remote location. Since it involves network and interconnection between… Read More »