Home » RDBMS Server » Server Administration » Upgrade Oracle10g to Oracle11g (Oracle 11g 11.2.0.4)
Upgrade Oracle10g to Oracle11g [message #631414] Tue, 13 January 2015 16:21 Go to next message
shrinika
Messages: 298
Registered: April 2008
Senior Member
We recently upgraded from Oracle10g to Oracle 11.2.0.4. 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.

Quote:
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 ='11.1.0.7'.

Currently the compatible parameter is 10.2.0.0

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

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

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: 7699
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: Wed Dec 12 12:27:07 CST 2018