Home » Server Options » Data Guard » Resolving Archivelog Gap on Physical Standby Database (Oracle 10g R2 on linux)
Resolving Archivelog Gap on Physical Standby Database [message #414732] Thu, 23 July 2009 05:48 Go to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi,

Referring the link http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#i1032254

Archive gap can happen in following conditions

1)Creation of Physical Standby Database
2)Shutdown of the Standby Database When the Primary Database Is Open
3)Network Failure

To resolve this the solution described is

1) copy the files from Primary database to Standby database
2) startup mount pfile=..              {Assuming that Standby database was shutdown}
3)alter database recover automatic standby database
4)after "Specify log: {<RET>=suggested | filename | AUTO | CANCEL}"
CTL+C 
5)alter database recover managed standby database disconnect from session


However in the link http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_transport.htm#i1268351
It is mentioned that after copying the files to Standby Database execute following on Standby Database and "restart" Redo Apply
alter database register logfile '/physical_standby1/thread1_dest/arcr_1_7.arc';


Now in case both above methods are compatible to each other which is better?
OR
Both above methods are to be used on some specfic situations?

Thanks and Regards,
OraKaran


Re: Resolving Archivelog Gap on Physical Standby Database [message #414739 is a reply to message #414732] Thu, 23 July 2009 06:05 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


You can select any method.
Re: Resolving Archivelog Gap on Physical Standby Database [message #414740 is a reply to message #414732] Thu, 23 July 2009 06:18 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Thanks gentlebabu...that was quick

one more query

what is mean by "Restart" Redo apply?
Do I need to "cancel recovery" and again "start recovery"?

Regards,
OraKaran
Re: Resolving Archivelog Gap on Physical Standby Database [message #414756 is a reply to message #414740] Thu, 23 July 2009 07:01 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
Provides a physically identical copy of the primary database, with on disk database structures that are identical to the primary database on a block-for-block basis. The database schema, including indexes, are the same. A physical standby database is kept synchronized with the primary database, though Redo Apply, which recovers the redo data received from the primary database and applies the redo to the physical standby database.


Ref: http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/concepts.htm

Ref: http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_apply.htm#i1023371

Thanks

[Updated on: Thu, 23 July 2009 07:03]

Report message to a moderator

Re: Resolving Archivelog Gap on Physical Standby Database [message #414867 is a reply to message #414732] Thu, 23 July 2009 22:13 Go to previous message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Many Thanks gentlebabu

Regards,
OraKaran
Previous Topic: DATAGUARD
Next Topic: Database cloning.
Goto Forum:
  


Current Time: Thu Mar 28 07:45:56 CDT 2024