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