Home » Server Options » Data Guard » logs are not in sync (sync problem) (oracle9i, windows)
logs are not in sync (sync problem) [message #328633] Sat, 21 June 2008 00:35 Go to next message
dba_01
Messages: 8
Registered: January 2008
Junior Member
i had created the standby db as procedure given.
it was working fine for fine
as 'm observing from few months, the logs are not getting applied. ( i mean it won't be the sync.)
every time, i was manually copying and register the log.
After manually applying the log on DR side, It will be in sync for days. ( i mean for 15 days).
later again, It won't be in sync.
can you please guide me..
plzz help

Re: logs are not in sync (sync problem) [message #328675 is a reply to message #328633] Sat, 21 June 2008 09:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above

Every time a redo logfile is shipped from the primary, this action is recorded in the alert_SID.log file of the primary.

Every time a redo log file is applied at the standby, this action is recorded in the alert_SID.log file of the secondary.

When a problems occurs (shipping, receiving,applying) redo logfiles, these errors are also written to the alert_SID.log files.

Since only YOU can read these files, You're On Your Own (YOYO)!
Re: logs are not in sync (sync problem) [message #339546 is a reply to message #328675] Thu, 07 August 2008 17:00 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
In parameter file of Primary you need

standby_file_management = auto

Re: logs are not in sync (sync problem) [message #339547 is a reply to message #339546] Thu, 07 August 2008 17:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
sunil_v_mishra wrote on Thu, 07 August 2008 15:00
In parameter file of Primary you need

standby_file_management = auto



WHY? As far as I know this parameter has NOTHING to do with redo log files themselves

Quote:

STANDBY_FILE_MANAGEMENT =

can be set to MANUAL or AUTO. If AUTO is specified, Oracle will automatically create files and
drop tablespaces on the standby database as the redo log stream is applied to the standby database.

Re: logs are not in sync (sync problem) [message #339549 is a reply to message #339547] Thu, 07 August 2008 17:38 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Sorry my previous post was related to Datafile not related to Redo

Actually OP has to do

SQL>alter database recover managed standby database;
Re: logs are not in sync (sync problem) [message #339753 is a reply to message #339549] Fri, 08 August 2008 06:33 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

As per Mr.Ana,

Check your alert_SID.log file in your primary database

Babu
Re: logs are not in sync (sync problem) [message #339764 is a reply to message #339753] Fri, 08 August 2008 07:11 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
What ana is saying is correct but the problem what OP is facing is ...

He/She has to do manual recovery of DR & thats working fine....
Previous Topic: not get archivelog in v$archived_log view
Next Topic: Logical Standby Apply became TOO SLOW !!
Goto Forum:
  


Current Time: Thu Mar 28 03:59:26 CDT 2024