-
archives not shipping on standby
Hii all,
I am trying to configure physical standby. Everything was fine but at the end i found that archives from primary db are not shipping to standby..Networking is fine.
Here is the production p file.
db_name=manish
db_unique_name=manish1
#service_name=manish1
remote_login_passwordfile=exclusive
shared_pool_size=102341017
db_block_size=8192
diagnostic_dest=/disk1/oradata/manish
undo_tablespace=undotbs
undo_management=auto
control_files = /disk1/oradata/manish/control.ctl
compatible ='11.2.0'
###################Data guard PARAM's###################
log_archive_dest_1='location=/disk1/oradata/manish/arch
valid_for=(all_logfiles,all_roles)'
log_archive_dest_2='service=stand
valid_for=(online_logfiles,primary_role)
db_unique_name=stand1 lgwr sync affirm reopen=10'
standby_archive_dest=/dsik1/oradata/manish/arch
standby_file_management=auto
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
fal_server=stand
fal_client=manish
here is my standby's p file
db_name=manish
db_unique_name=stand1
remote_login_passwordfile=exclusive
shared_pool_size=102341017
db_block_size=8192
diagnostic_dest=/disk1/oradata/manish
undo_tablespace=undotbs
undo_management=auto
control_files = /disk1/oradata/manish/stand.ctl
compatible ='11.2.0'
###################Data guard PARAM's###################
log_archive_dest_1='location=/disk1/oradata/manish/arch
valid_for=(all_logfiles,all_roles)'
log_archive_dest_2='service=manish lgwr sync affirm reopen=10'
standby_archive_dest=/dsik1/oradata/manish/arch
standby_file_management=auto
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
fal_server=manish
fal_client=stand
archive log list (primary)
archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /disk1/oradata/manish/arch
Oldest online log sequence 198
Next log sequence to archive 199
Current log sequence 199
archive log list(standby)
archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /disk1/oradata/manish/arch
Oldest online log sequence 178
Next log sequence to archive 179
Current log sequence 179
Please help me to get through this ...
Thanks
-
You should take a look at the alert file. With what you have given, you have not provided any information that would narrow down the reasons for a log not shipping to, or applying on the standby. My guess is that everything you want to know is in either the alert log of the primary database or the alert log of the standby database.
-
Hi manish,
After you follow gandolf's suggestion and you do not find anything, try replacing the service name with the full sqlnet identifier (kinda like this):
Code:
*.log_archive_dest_2='service="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost.mydomain.com)
(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=stand)(SERVER=DEDICATED)))"','. . . rest of parameters . . .
We had same problem and now it works...there are a few bugs related to redo transport in 11.2.0.1 and 0.2 fixed in 0.3.
Good luck!
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Please look in to alert log file and find the status of archive destinations. If there any error you will get from there.
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
|