OraFAQ Forum: Data Guard » Manual standby Oracle 11.1 standard edition : cannot register logfile

Home » Server Options » Data Guard » Manual standby Oracle 11.1 standard edition : cannot register logfile (Oracle 11.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Manual standby Oracle 11.1 standard edition : cannot register logfile [message #490427]

Mon, 24 January 2011 23:42

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.

Report message to a moderator

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

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SE does not include Data Guard and so you can't use this command.

Regards
Michel

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

6. alter database open read only;

So it is not a standby database.

Regards
Michel

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1. Not when it is open in read only mode

Regards
Michel

Report message to a moderator

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

jayraj
Messages: 11
Registered: January 2011
Location: Mumbai

Junior Member

Since its Manual

Report message to a moderator

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

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

jayraj wrote on Tue, 25 January 2011 13:08

Since its Manual

What does this mean?

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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.

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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 ?

Report message to a moderator

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

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Same way than in the link.

Regards
Michel

Report message to a moderator

Previous Topic:	Data Guard Manager
Next Topic:	Deleting Logs in Standby

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 31 19:31:10 CDT 2025