Home » Server Options » Data Guard » Urgent ! problem with data guard
icon5.gif  Urgent ! problem with data guard [message #236756] Thu, 10 May 2007 21:07 Go to next message
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
Re: Urgent ! problem with data guard [message #236857 is a reply to message #236756] Fri, 11 May 2007 02:55 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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.
Re: Urgent ! problem with data guard [message #236899 is a reply to message #236857] Fri, 11 May 2007 04:17 Go to previous messageGo to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Could you pls suggest me how to shipped to the standby site and applied.?

Regards
Re: Urgent ! problem with data guard [message #236925 is a reply to message #236899] Fri, 11 May 2007 06:11 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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.
Re: Urgent ! problem with data guard [message #237331 is a reply to message #236925] Mon, 14 May 2007 03:10 Go to previous messageGo to next message
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?


Re: Urgent ! problem with data guard [message #237463 is a reply to message #237331] Mon, 14 May 2007 10:20 Go to previous messageGo to next message
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

Re: Urgent ! problem with data guard [message #237555 is a reply to message #237463] Mon, 14 May 2007 20:55 Go to previous message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Thank you for all
Previous Topic: Logical Standby DB
Next Topic: Data-Guard configuration details
Goto Forum:
  


Current Time: Fri Mar 29 06:06:19 CDT 2024