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 […]
RMAN

How to Restore Archivelog to Different Location

Posted on
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 can’t restore all of required archived log to the destination. So I decided to restore them to another location. RMAN> run {   allocate channel c1 type ‘sbt_tape’;   set […]
Backup and Recovery

When Database is Not Consistent

Posted on
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 you can mount the database without question.Data files are consistent, but controlfile is advanced.Do you have all required logs? If you have both archived logs and redo logs, then you […]
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 […]
Data Guard

How to Resolve ORA-16055: FAL request rejected

Posted on
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 two databases, it is pretty complicated to do troubleshooting. That’s why you might see ORA-16055: FAL request rejected at times. The network problem could include host, router, firewall, LAN, VPN, […]