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.

About these ads
Previous Post
Leave a comment


  1. Debbie

     /  April 13, 2012

    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!

  2. Lanre

     /  September 9, 2012

    Thanks !!! You just saved me about 5hrs of manually registering logfiles

  3. Shiva

     /  October 9, 2014

    Thanks !! You have saved few hours for me ..


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s


Get every new post delivered to your Inbox.

Join 60 other followers

%d bloggers like this: