| drop and create log files [message #434321] |
Tue, 08 December 2009 11:22  |
firefly
Messages: 53
Registered: March 2009
Location: Europe
|
Member |
|
|
Hi,
I would like to increase the size of my redo logs. For this I need to drop & recreate them. I have read the Oracle doc http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm which covers this however :
I have both "normal" and "standby" redo logs (see below) on my primary database - can I drop the standby redo logs? Do these have a link to the redo logs on the standby database?
SQL> SELECt * from v$logfile order by 1;
GROUP# STATUS TYPE MEMBER
---------- ------- ------- ------------------------------------- 1 ONLINE D:\ORACLE\ORADATA\REDO01.LOG
2 ONLINE D:\ORACLE\ORADATA\REDO02.LOG
3 ONLINE D:\ORACLE\ORADATA\REDO03.LOG
4 STANDBY D:\ORACLE\ORADATA\STDBYREDO04.LOG
5 STANDBY D:\ORACLE\ORADATA\STDBYREDO05.LOG
6 STANDBY D:\ORACLE\ORADATA\STDBYREDO06.LOG
|
|
|
|
|
|
|
|
| Re: drop and create log files [message #434599 is a reply to message #434321] |
Wed, 09 December 2009 21:57  |
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
|
Junior Member |
|
|
Hi F,
Quote: my primary database - can I drop the standby redo logs?
Basically, A standby redo log is required for the maximum protection and maximum availability modes. But Yes, you can drop standby redo logs on primary. It require when primary database running in standby role. But Oracle recommended to create standby on Primary site also. So that you can perform Switchover activity smoothly.
Quote: Do these have a link to the redo logs on the standby database?
Only when primary database running in standby role.
Let me know if you have any question.
Regards,
Vish
|
|
|
|
| Re: drop and create log files [message #448374 is a reply to message #434321] |
Tue, 23 March 2010 01:22 |
goldenshot2727
Messages: 6
Registered: March 2010
Location: delhi
|
Junior Member |
|
|
no , no need to drop the standby redo logs file, if you have set the standby_management=auto.
bou if you set this parameter to manual, then you have to do the same steps on the standby which you perform on primary.
Do more reading of oracle documentation.
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
