Registering archive logfiles on a standby

I’ve been having some issues with a physical standby running Oracle This has caused us to have to manually register logfiles to bridge gaps in the archive sequence on the physical standby.

One way of registering a logfile is via the following:

SQL> alter database register logfile

So this is a straightforward way of registering a logfile giving the full path to the logfile. However, what if you have a very large number of logfiles to register, the above does not really scale all that well. Thankfully there is an rman command that enables you to register all logfiles within a directory:

rman> catalog start with '/var/arch';

This can save you a lot of time if you need to register a large number of files.


4 thoughts on “Registering archive logfiles on a standby

  1. Wow! Thanks for this tip. I was asked to verify that a standby database was current and discovered that the dba responsible had not been monitoring it for almost a year, and there were a lot of gaps in the archive logs. This was a total time saver as opposed to restoring the missing logs to production and letting the standby request them!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s