Home » Server Options » Data Guard » Manual standby Oracle 11.1 standard edition : cannot register logfile (Oracle 11.1)
Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490427] Mon, 24 January 2011 23:42 Go to next message
jvyt
Messages: 4
Registered: January 2011
Junior Member
I have set up a standby DB for Oracle 11.1 standard edition.
Everything is done manually by using batchfiles and scripts.
Logiles are copied from the primary server to the standby server but when I try to register those I get an error ORA-00439: featue not enabled : managed standby
Do I need enterprise edition for this ? I thoguht it was possible to set up a physical standby if you do the logshipping yourself without using data guard.



Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490431 is a reply to message #490427] Tue, 25 January 2011 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SE does not include Data Guard and so you can't use this command.

Regards
Michel
Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490477 is a reply to message #490431] Tue, 25 January 2011 04:54 Go to previous messageGo to next message
jayraj
Messages: 11
Registered: January 2011
Location: Mumbai
Junior Member
You can build Physical Standby database with SE. All these activities are manual

Primary DB
1. Genrate standby control file in mount mode.
2. Shutdown DB
3. Take a cold backup including logfiles,datafiles and p/sp file

Transfer this backup on destination box
Secondary DB
1. copy generated standby control file to the control file location. (If multiple - make a copy of the same and place it on those locations)
2. copy datafiles to the respective locations.
3. copy p/spfile to respective location.
4. startup nomount
5. alter database mount standby database;
6. alter database open read only;

Assumption:
1. You have same directory structure available at destination.

Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490489 is a reply to message #490477] Tue, 25 January 2011 05:12 Go to previous messageGo to next message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
6. alter database open read only;


So it is not a standby database.

Regards
Michel


Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490493 is a reply to message #490489] Tue, 25 January 2011 05:21 Go to previous messageGo to next message
jayraj
Messages: 11
Registered: January 2011
Location: Mumbai
Junior Member
Its a standby database. Because
1. You can apply archive logs generated by primary database to this database.
2. This is open by standby control file.
Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490504 is a reply to message #490493] Tue, 25 January 2011 05:41 Go to previous messageGo to next message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. Not when it is open in read only mode

Regards
Michel
Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490512 is a reply to message #490504] Tue, 25 January 2011 06:08 Go to previous messageGo to next message
jayraj
Messages: 11
Registered: January 2011
Location: Mumbai
Junior Member
Since its Manual
Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490513 is a reply to message #490512] Tue, 25 January 2011 06:10 Go to previous messageGo to next message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
jayraj wrote on Tue, 25 January 2011 13:08
Since its Manual

What does this mean?

Regards
Michel

Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490517 is a reply to message #490427] Tue, 25 January 2011 06:59 Go to previous messageGo to next message
jvyt
Messages: 4
Registered: January 2011
Junior Member
All these steps are done.

A batchfile is triggered on the standby server which does following :

- login to primary and force logswitch
- compare seqnr and get filenames from newer logfiles
- copy these logfiles to the server where the standby db is
- regsiter these logfiles

On the standby DB I have issued :

startup mount;
alter database recover managed standby database disconnect from session;


Register logfile : alter database register physical logfile

Error : ORA-00439: featue not enabled : managed standby

I have been able to get this working on Oracle V10.2 btw
Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490526 is a reply to message #490517] Tue, 25 January 2011 07:42 Go to previous messageGo to next message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 25 January 2011 07:51
SE does not include Data Guard and so you can't use this command.

Regards
Michel

Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490553 is a reply to message #490526] Tue, 25 January 2011 09:44 Go to previous messageGo to next message
jvyt
Messages: 4
Registered: January 2011
Junior Member
Ok so it seems that from V11 it is not possible anymore to apply your logfiles unless you have enterprise edition.
Too bad because most of my customers have Oracle V10 SE and I won't be able to convince them to upgrade to V11 SE if that means they will lose the updating of the standby database.
Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490556 is a reply to message #490553] Tue, 25 January 2011 09:58 Go to previous messageGo to next message
BlackSwan
Messages: 26730
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B10500_01/server.920/a96653/create_ps.htm

Nothing prevents anyone from rolling out own solution that mimics Data Guard.
Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490558 is a reply to message #490553] Tue, 25 January 2011 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/mv/msg/139482/490232/102589/#msg_490232
http://www.youtube.com/watch?v=6uekQo_OZ10

Regards
Michel
Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490598 is a reply to message #490558] Wed, 26 January 2011 00:19 Go to previous messageGo to next message
jvyt
Messages: 4
Registered: January 2011
Junior Member
Again this is all about Oracle 10 where I already have a standby in place and in sync.

But has anyone else tried to set this up on an Oracle V11 db yet ?
Re: Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490604 is a reply to message #490598] Wed, 26 January 2011 00:57 Go to previous message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same way than in the link.

Regards
Michel
Previous Topic: Data Guard Manager
Next Topic: Deleting Logs in Standby
Goto Forum:
  


Current Time: Wed Aug 12 05:04:19 CDT 2020