Alter database register logfile

[Former Member]

Hi,

I just setup a dr site for our client for R/3 production system.

I had two options to automatically apply the logfiles in standby system.

Option 1: Wrote a script to automate the archive from primary to standby and then apply on standby.

Option 2: Just moved the archive from primary to standby and fired the command alter database managed standby database;

Here i had to fire one more command on different sql session to register the archive on standby system. Registering log file has to be done for all archive logs.

Currently the standby system is running based on option1.

My question is,

why do i need to register these archive files?

Is there any way, this registration can be skipped?

Regards,

Iyyappan

[stefan_koehler]

Hello Iyyappan,

at first we have to clarify: A logical or a physical standby database?

For example:

If the primary database is unavailable, you have to perform the register manually.

It is described by the oracle dataguard concepts:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_transport.htm#i1148216

And take a look at here what a "gap" is:

http://www.dba-oracle.com/t_oracledataguard_37_archive_gap_sequence_.htm

Regards

Stefan

[Former Member]

Hi Stefan,

Thanks for your reply.

I forgot to mention that. It is Physical standby database.

THanks for the site reference.

If i follow the below steps, will i be able to skip the register log file command in standby.

01. On primary, take the backup into tape using "s" i.e. save.

02. copy the archive files to standby database from primary using script.

03. fire the command in standby database "alter database managed standby database"

04.. delete the archive files on primary using "ds" i.e. delete,save

05. delete archive files in standby database which is of primary database once it is applied on standby.

Regards,

Iyyappan MR

[Former Member]

Hi,

As far as my knowledge, there is no need to register logfiles.

If the oracle version is above 9i and even transporting archive log to the standby site also can be automated with this version and above. i.e. no need to write any script.

If you are using version 8i, please look at the following link.

http://www.oracle-base.com/articles/8i/StandbyDatabase.php

Regards,

Abhishek Thota

[stefan_koehler]

Hello

>> If the oracle version is above 9i and even transporting archive log to the standby site also can be automated with this version and above. i.e. no need to write any script.

You are right... that is what is described in my link above (Redo Transport Services)

Regards

Stefan