-
Hi friends,
I have a standby database to which archive log files are applided automatically by setting the appropriate parametes in the init.ora file of the primary database.
Now my standby database archive log is not in sync with the primary database.
Now do i need to manually apply the archive logs from the primary database to standby database and perform recovery.
please help me
regards
anandkl
-
I would like to know. This was working before and now its not working OR first time you are keeping standby in auto recovery mode ?
-
It was working before and now its not in sync with the primary database
regards
anandkl
-
You have to sync up manually until the most recent log from primary and then you can keep it back in auto recovery. You do not have any other alternative other than following this when its outta sync.
Do switch a log on primary before you start applying logs manually on standby, that way by that time you apply all the logs, it will not generate another log.(I'm assuming here few logs, minimum time for log switch and applying recovery).
And make sure that before keeping it in Auto mode, log_arch_dest_state_n is 'enabled' not 'defer'.
-
Also i would like to mention that we are using scripts to copy archive logs from primary database to standby database.
regards
anankl
-
What do you mean? Is this scripts copying logs is for auto recovery/manual recovery whenever its outaa sync. I'm little confused... give me little more details version of the database, OS etc.,
-
Hi if already archive log files are in place meaning ...in correct archive directory...
Then manually run.....
RECOVER STANDBY DATABASE;
it checks for the files in archive directory and try to apply all the required files...
already the database is in managed recovery mode then you have to stop it...by
alter database recover managed standby database cancel;
please post if you have any problem.
Thanks.
Thanigaivasan.
-
Its is in manual recover mode..
regards
anandkl
-
You mean the script copies logs to STANDBY location and STANDBY is in manual recovery mode. Usually RFS process copies the logs to standby if you configure the service in init.ora and tnsnames.ora Right ? Which Command you use to apply recovery to STBY?
alter database recover managed standby database (auto)
OR
recover standby database (manual)
If its manual what happens when your session dies, after you leave your session with that command on (Say your script make sure that it copies the logs from primary).
[Edited by sreddy on 06-21-2002 at 06:06 PM]
-
reddy,
i dint get what u mean by session dies..can u please be more clear on this...
regards
anandkl
-
standby soloution
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 [email protected]
-
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.
-