Home » RDBMS Server » Server Administration » Upgrade Oracle10g to Oracle11g (Oracle 11g
Upgrade Oracle10g to Oracle11g [message #631414] Tue, 13 January 2015 16:21 Go to next message
Messages: 298
Registered: April 2008
Senior Member
We recently upgraded from Oracle10g to Oracle This is data guard database.

This is siebel database and upgrade went well and no issues.

Only issue is, we are not able open the standby database with READ ONLY WITH APPLY mode.

We opened the standby database with below command.

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

The standby is in managed recovery mode. but it is not applying online redo replication.

The DB is in MOUNT mode now..

We found that we forgot to set the compatible =''.

Currently the compatible parameter is

Now to fix this issue, i guess, we need to change the compatible parameter to

My question is, does it break any thing if we set the compatible parameter to

Any input is highly appreciated.
Re: Upgrade Oracle10g to Oracle11g [message #631422 is a reply to message #631414] Wed, 14 January 2015 00:57 Go to previous message
John Watson
Messages: 8644
Registered: January 2010
Location: Global Village
Senior Member
If you want READ ONLY WITH APPLY then you have the wrong method. You must first open the standby (not mount it) and then start managed recovery with the USING CURRENT LOGFILE option.
Assuming, of course, that you have bought the active Data Guard option. It isn't free.
Previous Topic: Cannot Use DBMS_SCHEDULER.CREATE_PROGRAM even as owner
Next Topic: About an Oracle's Isolation Levels and lock mode
Goto Forum:

Current Time: Sat Dec 04 16:08:09 CST 2021