Registering archive logfiles on a standby

I’ve been having some issues with a physical standby running Oracle 10.2.0.3. 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
'/var/arch/arch_1_101.arc';

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

2 Comments

  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!

    Reply
  2. Lanre

     /  September 9, 2012

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

    Reply

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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

Follow

Get every new post delivered to your Inbox.

Join 52 other followers

%d bloggers like this: