-
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 kgshangs@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|