| Change current redo log size in oracle mount stage [message #557108] |
Fri, 08 June 2012 23:46  |
reyazan
Messages: 53
Registered: February 2005
|
Member |
|
|
We have one primary oracle database 10.2 and standby by database with no data guard.
Initially we have 2 redo log group in primary and standby database.
We have recently add 2 more redo log and increase the size of log member from 50m to 200m in primary database.
We don't have any problem in primary database.but in standby database we face a problem because we cannot open it. It always in mount stage in which
How we change the size of current redo log because we can't run
Alter system switch logfile command in mount stage.
Please provide the steps
[Updated on: Fri, 08 June 2012 23:53] Report message to a moderator |
|
|
|
| Re: Change current redo log size in oracle mount stage [message #557117 is a reply to message #557108] |
Sat, 09 June 2012 03:34  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
I see no-one else has answered, so I'll try.
I do not think you will be able to adjust the online logs on the standby, and you shouldn't need to: when you activate the standby, they will be created by OPEN RESETLOGS.
What happens when you try to apply the archivelog files to the standby? If they apply OK, then you need do nothing more. If they do not apply, I would create a new standby controlfile, and try the apply again. If that doesn't work, re-create the standby.
That is what I would do - but I don't know if it will work.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
