Home » Server Options » Data Guard » primary standby different patches
primary standby different patches [message #194517] Fri, 22 September 2006 08:23 Go to next message
lokeshonline
Messages: 29
Registered: April 2006
Junior Member
Our production database is Oracle 9.2.0.4. Can I have its standby database on a machine having Oracle 9.2.0.1? OS is same and directory structure is same.

Report message to a moderator

Re: primary standby different patches [message #194522 is a reply to message #194517] Fri, 22 September 2006 08:46 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
It is recommened by oracle to have same version, same patchset and same OS level in order to run standby database.

You may choose to have lower patchset and see how it runs.

Sandeep

Report message to a moderator

Re: primary standby different patches [message #194562 is a reply to message #194522] Fri, 22 September 2006 12:08 Go to previous messageGo to next message
lokeshonline
Messages: 29
Registered: April 2006
Junior Member
Is it mandatory to shutdown the primary database and then copy the datafiles. Will hot backup of datafiles and 'alter database backup standby controlfile to .....' command work????

Report message to a moderator

Re: primary standby different patches [message #194594 is a reply to message #194517] Fri, 22 September 2006 19:48 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
yes. Its mandatory to have primary down and backup files to create secondary. Hot backup will not work.

Sandeep

Report message to a moderator

Re: primary standby different patches [message #194802 is a reply to message #194594] Mon, 25 September 2006 07:06 Go to previous messageGo to next message
anurag078
Messages: 34
Registered: May 2006
Location: West Des Moines
Member

Sorry to say say against...

But I have done Physical Standby setup many times on Oracle 9i releases with Hot Backups...

Take the hot backups with archive logs....

Restore/recover them using the archive logs and the Standby is ready....

Anurag

Report message to a moderator

Re: primary standby different patches [message #194819 is a reply to message #194517] Mon, 25 September 2006 08:55 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
Thanks Anurag.

Thats good to know. I will followup on that and will find out why its not recommended or suggested by oracle.

Sandeep

Report message to a moderator

Re: primary standby different patches [message #194935 is a reply to message #194819] Tue, 26 September 2006 04:39 Go to previous message
lokeshonline
Messages: 29
Registered: April 2006
Junior Member
Do we require to initially give "recover database" command or just start with "alter database recover managed standby .....' ??? and it will work

Report message to a moderator

Previous Topic: Oracle 9i Data guard
Next Topic: Data Guard remote process startup failed
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 28 09:26:55 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.