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 Log File
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 Resolve RMAN-06059: expected archived log not found
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 RMAN-06059: expected archived log not found
How to Resolve ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST
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 Resolve ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST
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
When Oracle Software Directory Is Full
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 »When Oracle Software Directory Is Full
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
2 Unawared Cases May Produce Large Amount of Archived Logs
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 »2 Unawared Cases May Produce Large Amount of Archived Logs
How to Archive Redo Logs to Respective Local Destinations of RAC
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 »How to Archive Redo Logs to Respective Local Destinations of RAC