How To Register Archive Logs On Standby Manually

Register Data Baby-sit standby redo log file tips

Oracle Database Tips by Donald BurlesonJune 23, 2015

Question: How do you annals standby redo log files in Oracle? I have verified that the redo log exist in the archived redo log file destination (LOG_ARCHIVE_DEST), but they do non appear in Data Guard. What is the process for registering redo logs in Oracle?

Answer: One manner of registering a logfile is via the following command:

SQL> alter database register logfile 'u01/app/oracle/arch/arch_101.arc';

So this is a straightforward way of registering a logfile giving the full path to the logfile. Nevertheless, what if you have a very large number of logfiles to register, the above does non really calibration all that well. Thankfully in that location is an RMAN command that enables you lot to annals all logfiles inside the standby redo log file directory:

rman> itemize start with 'u01/app/oracle/arch';

This will same yous a considerable amount of piece of work if you utilise the RMAN version of the command.