Oracle Archive Block Size
How to Check Archive Block Size ? To monitor the applying performance of a standby database, we usually make a query on V$MANAGED_STANDBY like this:… Read More »Oracle Archive Block Size
Archived Logs
How to Resolve ORA-00308: cannot open archived log
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 ORA-00308: cannot open archived log
How to Set USE_DB_RECOVERY_FILE_DEST
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 »How to Set USE_DB_RECOVERY_FILE_DEST
Online Archived Logs vs Backup Archived Logs
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 »Online Archived Logs vs Backup Archived Logs
How to Resolve "Can not allocate log, archival required"
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 to Resolve "Can not allocate log, archival required"
How RMAN Restore Archivelog to Different Location
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 »How RMAN Restore Archivelog to Different Location
When Database is Not Consistent
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 »When Database is Not Consistent
How to Check Archive Log Size
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 Check Archive Log Size
How to Resolve ORA-16055: FAL request rejected
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 »How to Resolve ORA-16055: FAL request rejected