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.
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
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????
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
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

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
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

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


Current Time: Thu Mar 28 07:46:00 CDT 2024