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

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:

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