| Rohit Chouhan |
Posted: Dec 28, 2007 11:49:17 PM |
Total Post: 11
Joined: Aug, 2007
|
Hi
I configured data guard in my test server (version 10.2.0.1.0).
Primary database is running on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Standby database is running on Oracle Database 11g Enterprise Edition Release 11.1.0.6.0
After configuration i noticed the following error in alert log file.
Errors in file /u02/testdb/bdump/test_arc1_24607.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC1]: Heartbeat failed to connect to standby 'STANDBY_TEST'. Error is 16191.
------------------------------------------------------------
SQL> SELECT DEST_ID "ID", STATUS "DB_status", DESTINATION "Archive_dest", ERROR "Error" FROM V$ARCHIVE_DEST WHERE DEST_ID <=2;
ID DB_status Archive_dest Error
----- --------- -------------------- ----------
1 VALID /u02/testdb/archive
2 ERROR stdby ORA-16191: Primary log shipping client not logged on standby
Both primary and standby databases are using password file authentication, and password for sys user in both databases is also same.
Primary Database was created manually.
can you help me out....
Regards,
Rohit Chouhan
|
|
|
 Mohammed Taj |
| Posted: Dec 28, 2007 11:51:30 PM |  |
|
Total Post: 694
Joined: Jul, 2007
|
Did you set archive log parameter for standby database ?
|
|
|
|
|
| Rohit Chouhan |
| Posted: Dec 29, 2007 12:10:50 AM | |
|
Total Post: 11
Joined: Aug, 2007
|
Yes,
I have set following parameters in standby database's inittestdb.ora file:
standby_archive_dest='/u02/testdb/stdbyarchive'
standby_file_management=auto
remote_archive_enable=true
and in primary database's inittestdb.ora :
log_archive_dest_1='location=/u02/testdb/archive'
log_archive_dest_2='service=stdby reopen=60'
log_archive_format='arc_%s_%t_%r.arc'
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
Regards,
Rohit Chouhan
|
|
|
|
|
| amarpreet |
| Posted: Jan 02, 2008 02:17:31 AM | |
|
Total Post: 2
Joined: Dec, 2007
|
chk for tnsnames.ora stabdby alias
|
|
|
|
|
| Rohit Chouhan |
| Posted: Jan 02, 2008 11:27:23 PM | |
|
Total Post: 11
Joined: Aug, 2007
|
I have already checked it. It's wotking.
If i try to connect with this net service, i am getting connected to the standby database, that means its working.
|
|
|
|
|
| MOH_DBA |
| Posted: Jan 04, 2008 05:05:40 PM | |
|
Total Post: 123
Joined: Nov, 2007
|
As i know in my working in data guard on Oracle 10g that, if you want a data gaurd the primary and standby databases must be the same (same version) and even must resides on the same platform.
so you cannot do 10g and 11g datagaurd. you can do data gaurd with 10.2.0 and 10.2.0 only.
|
|
|
|
|
| Rohit Chouhan |
| Posted: Jan 05, 2008 03:29:38 AM | |
|
Total Post: 11
Joined: Aug, 2007
|
Hi Moh_DBA
Yes! I came to know the version problem....
Actually previously it was showing different error... i.e.
ORA-16191: Primary log shipping client not logged on standby
PING[ARC1]: Heartbeat failed to connect to standby 'STANDBY_TEST'. Error is 16191.
But today morning only once again i created a new setup on test server and now i am getting the following error:
ORA-16039: RFS request version mismatch
it's clearly showing that version of oracle server must be same.
I put same compatible parameter (i.e. 10.2.0.1.0 ) in primary and standy database but its not working.
That means oracle installation software release must be same on both side.
Thanks for reply.... Have a nice day....
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
