OraFAQ Forum: Data Guard » Create Standby

Home » Server Options » Data Guard » Create Standby (oracle10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create Standby [message #440985]

Thu, 28 January 2010 03:49

salora
Messages: 26
Registered: December 2009
Location: Thailand

Junior Member

hi! alls

I have tryed to create data guard by remote to difference server as following details.

1. Copy the backup ,archive from primary to stand by
2. setting parameter in standby server. everthing is ok.
3. use rman to restore database --> datafile is created in standby site.
4. use rman to recover database --> it's ok;

Then at primary site ,
5. change parameter log_archive_dest_2 from DEFER to ENABLE
to start shif log from primary to standby site

then We faced following issues in alert log
.....
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Thu Jan 28 13:46:44 2010
Error 3135 received logging on to the standby
Thu Jan 28 13:46:44 2010
Errors in file d:\oradata\acssgprd\trc\sys\acssgprd_arc4_2956.trc:
ORA-03135: connection lost contact

**then we check the connection from primary sith to standby site also from standby site to primary site is ok by using command ping.. and tnsping... --> it's ok.

Kindly help .pls.

Report message to a moderator