Home » Server Options » Data Guard » Data Guard (Oracle 10.2.0.4.0 Windows 2007 64 bits)
Data Guard [message #551559] Thu, 19 April 2012 05:42 Go to next message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member

Dear All

My dataguard is not working properly however on both server primary and dataguard tnsping happens properly but I got it ("ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: 'E:\ORACLE\ORADATA\DATA\REDO01.LOG'" ) error in dataguard alter log file so request you to kindly help
Re: Data Guard [message #551570 is a reply to message #551559] Thu, 19 April 2012 06:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Very good title! "Data Guard" posted in "Data Guard" forum, how smart it is.

You know what you have to post...
ORA-19527: physical standby redo log must be renamed
 *Cause:  The CLEAR LOGFILE command was used at a physical standby
          database.  This command cannot be used at a physical standby
          database unless the LOG_FILE_NAME_CONVERT initialization
          parameter is set.  This is required to avoid overwriting
          the primary database's logfiles.
 *Action  Set the LOG_FILE_NAME_CONVERT initialization parameter.

Regards
Michel

[Updated on: Thu, 19 April 2012 06:30]

Report message to a moderator

Re: Data Guard [message #551577 is a reply to message #551570] Thu, 19 April 2012 08:35 Go to previous messageGo to next message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member

Dear Michel,

thank you for your valuable support but believe i have already mentioned the LOG_FILE_NAME_CONVERT parameter in my initialization parameter but issue still persist.



Re: Data Guard [message #551582 is a reply to message #551577] Thu, 19 April 2012 08:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Too bad this does not work you there is surely something else.

Regards
Michel
Re: Data Guard [message #551588 is a reply to message #551582] Thu, 19 April 2012 09:15 Go to previous messageGo to next message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member

Dear Michel

Pls confirm is there any way to find out the root cause of this issue Revert to this reply will be highly appreciated.

Re: Data Guard [message #551603 is a reply to message #551588] Thu, 19 April 2012 10:11 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As root cause maybe one out of hundreds we surely NOT list all of them.
YOU have to post what you did and got from the BEGINNING.

Regards
Michel
Previous Topic: setting up Dataguard
Next Topic: Dataguard is not working properly
Goto Forum:
  


Current Time: Thu Mar 28 18:55:15 CDT 2024