Archived Log File

LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST are Mutually Exclusive

Posted on
LOG_ARCHIVE_DEST 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 log_archive_dest=’/backup08/archivelog’; alter system set log_archive_dest=’/backup08/archivelog’ * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST Rationale This […]
Archived Log File

How to Set USE_DB_RECOVERY_FILE_DEST

Posted on
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 destination for storing online archived logs in ARCHIVELOG mode. You can also regard it as a pointer which points to the real path of FRA. Before you point the archived […]
Archived Log File

Online Archived Logs vs Backup Archived Logs

Posted on
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. RMAN> list archivelog all; RMAN> list backup of archivelog all; Of course, I can also explain the difference much longer. Online Archived Logs Online archived logs are derived from online […]
Archived Log File

When Oracle Software Directory Is Full

Posted on
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 stopping database. Check Archived Log Destination At this moment, you should make sure the destinations of archived logs and data files are in the same directory with software or not. […]
Archived Log File

How to Determine Archived Log Size

Posted on
Archived Log Size Before determining archived log size, you have to know that archived logs are derived (retired) from online redo logs switching. That is, you are not determining archived log size, in fact you are determining online redo log size. But now the question is: How to set a proper and optimal size for […]
Archived Log File

How to Archive Redo Logs to Respective Local Destinations of RAC

Posted on
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, #2 archive thread #1, #2 redo logs to their respective local destinations. To achieve this goal, LOG_ARCHIVE_DEST_1 should be setup more granularly by sid like this way:SQL> alter system set log_archive_dest_1=’location=/oracle/oradata/arch1′ […]