Home » Server Options » Data Guard » Create Standby (oracle10g)
Create Standby [message #440985] Thu, 28 January 2010 03:49 Go to next message
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.

Re: Create Standby [message #441079 is a reply to message #440985] Thu, 28 January 2010 09:32 Go to previous message
Messages: 24957
Registered: January 2009
Location: SoCal
Senior Member
>Errors in file d:\oradata\acssgprd\trc\sys\acssgprd_arc4_2956.trc:

post contents d:\oradata\acssgprd\trc\sys\acssgprd_arc4_2956.trc
Previous Topic: rename datafile in physical standby database
Next Topic: [DG Physical] ORA-00368: checksum error in redo log block
Goto Forum:

Current Time: Fri Oct 21 08:45:14 CDT 2016

Total time taken to generate the page: 0.09052 seconds