| Upgrade Oracle10g to Oracle11g [message #631414] |
Tue, 13 January 2015 16:21  |
shrinika
Messages: 306
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  |
John Watson
Messages: 8963
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
