standby database not in sync with primary database

Hi Anand,

This is shankar from Bangalore.
You just verify your production init.ora file
log_archive_start=true
log_archive_format="arch_%s_%t.arc"
log_archive_dest_1 = 'LOCATION=/d3_s1/test/archive/ MANDATORY REOPEN=60'
log_archive_dest_2 = 'SERVICE=standbytest OPTIONAL REOPEN=60'
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE

Then Check your standby init.ora file for the following:

#log_archive_start=true
log_archive_format="arch_%s_%t.arc"
standby_archive_dest=/d3_s1/test/archive
log_archive_dest=/d3_s1/test/archive


Primary tnsnames.ora file you should be configure the standby m/c for the following:

standbytest =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.19.7)(PORT = 1521))
)
(CONNECT_DATA =
(SID = HLLRSNET)
)
)



first time you have to copy the archive log files to standby archive log destination
Then
you have start the standby database in nomount state using following command:
set oracle_sid
svrmgr>connect internal
svrmgr>startup nomount
svrmgr>alter database mount standby database;
svrmgr>recover standby database
type auto

Automatically will apply the archive logs
finally it will give error, because that will not exist in the primary itself .

Then immediately do the following command
svrmgr>recover managed standby database;

The above command will do auto matic recovery.


Regards,

G.Shankar.


My id is kgshangs@yahoo.com

in Oracle 9i, if you use RECOVER MANAGED STANDBY DATABASE, it will automatically resolve archive gaps.

anandkl ,
can u send me an exact procedure for creating a standby db.

http://otn.oracle.com/doc/oracle8i_8...a76995/toc.htm