OraFAQ Forum: Data Guard » Urgent ! problem with data guard

Home » Server Options » Data Guard » Urgent ! problem with data guard

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

Urgent ! problem with data guard [message #236756]

Thu, 10 May 2007 21:07

chara
Messages: 81
Registered: April 2005
Location: th

Member

Dear all,

I tried to set up a physical standby database with oracle9i.I 'm not sure what 's
the step am i wrong !.After setup completed i tried to insert any rows on primary db and i saw archive log file on primary and standby db are the same size and same up to-date and then i tried to shutdown primary db and activate standby database with following cmd:
SQL> RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
SQL> RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
every cmd didn't error after i tried to shutdown and startup standby db and then
i tried to select to saw the row that i insert the latest row on primary db but it didn't have the latest row .It show the last row that i copied archive from primary db to stand by db .
What happend ?

Thanks for advance !
Chara

Report message to a moderator

Re: Urgent ! problem with data guard [message #236857 is a reply to message #236756]

Fri, 11 May 2007 02:55

Frank Naude
Messages: 4590
Registered: April 1998

Senior Member

Your updates were still in the redo log file - not yet archived, not yet shipped to the standby site and not yet applied.

Report message to a moderator

Re: Urgent ! problem with data guard [message #236899 is a reply to message #236857]

Fri, 11 May 2007 04:17

chara
Messages: 81
Registered: April 2005
Location: th

Member

Could you pls suggest me how to shipped to the standby site and applied.?

Regards

Report message to a moderator

Re: Urgent ! problem with data guard [message #236925 is a reply to message #236899]

Fri, 11 May 2007 06:11

Frank Naude
Messages: 4590
Registered: April 1998

Senior Member

It depends on your setup. For example, if you use remote archiving, you can simply do a -

SQL> ALTER SYSTEM SWITCH LOGFILE;

and wait for the log to be applied to the standby site.

Report message to a moderator

Re: Urgent ! problem with data guard [message #237331 is a reply to message #236925]

Mon, 14 May 2007 03:10

chara
Messages: 81
Registered: April 2005
Location: th

Member

Thank you for your replied

Is there anyway to automatically switch log file on primary db after update any rows?

Report message to a moderator

Re: Urgent ! problem with data guard [message #237463 is a reply to message #237331]

Mon, 14 May 2007 10:20

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

Your performance might suffer if you switch log files after every transaction. You can force a log file switch after x number of minutes (if there's anything in the online redo log). Ref: archive_lag_target parameter

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96653/init_params.htm#85235

Report message to a moderator

Re: Urgent ! problem with data guard [message #237555 is a reply to message #237463]

Mon, 14 May 2007 20:55

chara
Messages: 81
Registered: April 2005
Location: th

Member

Thank you for all

Report message to a moderator

Previous Topic:	Logical Standby DB
Next Topic:	Data-Guard configuration details

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 18:17:30 CST 2025