You're assuming a level of knowledge some of us don't yet have
Jean Therese, June 27, 2001 - 10:36 am UTC
What is the command for resizing? I gathered from the response what needs to be done, but still don't know how to do it.
This is why we're here - to learn all these necessary things we don't know. Thanks for the volume of info.
RBS: deleting last valid member of a group?
Aivar, June 20, 2003 - 10:52 pm UTC
Hi Tom.
My question is a bit off topic, I am stuck with a sentence from </code>
http://studyguides.cramsession.com <code>for OCP exams.
It's regarding rbs management: "You cannot drop the last valid member of a group". Can you explain this, does it make sense?
Thanks.
Re: cannot drop the last valid member
Aivar, June 22, 2003 - 6:48 pm UTC
Hi Tom,
Sorry, yes this is regarding redo! But they still have this at </code>
http://studyguides.cramsession.com/cramsession/oracle/oracle8iadmin/guide.asp?pn=9 <code>
It says "You cannot drop the last valid member of a group".
I think this just means you can't drop all members of a redo log file group that contains valid data. You have to use 'alter database drop logfile' and get rid of whole group instead.
Thanks
June 22, 2003 - 9:25 pm UTC
read the link I provided, it basically says exactly the same thing. It is the real documentation (and it is all there for you..)
resizing redo log and sizing log_buffers
Rahul Chaudhari, June 24, 2003 - 7:34 am UTC
Actually we can't resize the redo logfiles we have to drop the redo logfile and then recreate the redo logfile again with the new size what-ever we want. as the log buffers are flushed with each commit, so this option also wont work properly for this case. u'll have to recreate the logfile again and drop the first one.
June 25, 2003 - 8:56 am UTC
what?
it is noted above that you cannot resize log files, but I don't understand your "as the log buffers are flushed ... so this option won't work"
what option?
what wont work?
Dataguard redolog
Marcio Portes, November 26, 2006 - 12:33 am UTC
I have to move off my redologs from a filesystem to another. Currently, we are using Dataguard set to MaxAvailability thus the standby redologs are playing as well. I don't want to move the standby redos, just the online redos.
Question:
Should I consider anything else to create/drop my redolog files?
Regards,
November 26, 2006 - 9:31 am UTC
</code>
http://docs.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm#i1010565 <code>
I can say this - you should minimally have one more group on the standby than the primary, but that is mostly for performance reasons (eg: you don't have parity between standby and production typically, standby just uses it logs in a circular fashion just like production - lgwr is transmitting the bits over the network, it is not an "online redo => standby redo" transfer, it is a lgwr write to standby transfer).
It will likely be "no big deal", you just add new logs on the new device and then switch to them and then drop the old.
What about resizing logfile while standby is on dataguard
Ashish, April 26, 2008 - 4:16 am UTC
Hi Tom,
What about resizing logfile while standby is on dataguard and fast start failover("Log writer sync affirm")?
I am assuming to accomplish this, we need to first create new standby log files on standby, which match the size of new redo logs to be created on primary
April 28, 2008 - 12:53 pm UTC
show me how to resize a log file first.
resize redo logs on primary and standby database
A reader, August 22, 2008 - 1:50 pm UTC
I know how to resize the redo logs without standby database. However, with standby running, I'm not sure the procudures.
For example:
1) Do I need to cancel Redo Apply before I change the log files on primary database?
2) Do I need to set standby_file_management to MANUAL on both primary and standby database?
Thanks,
August 26, 2008 - 7:37 pm UTC
In my opinion the documented way does not work.
Thomas Rieder, September 11, 2008 - 5:03 am UTC
SQL> ALTER DATABASE DROP LOGFILE '/u01/oradata/PLIFLEX01S2/redo_g1m1PLIFLEX01S2.dbf' ;
SQL> alter database recover managed standby database cancel ;
Database altered.
SQL> alter system set standby_file_management=MANUAL ;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------
1 1 29456 262144000 1 YES CLEARING 3.2299E+10 11-SEP-08
4 1 29457 262144000 1 YES CLEARING 3.2299E+10 11-SEP-08
3 1 29457 262144000 1 YES CLEARING_CURRENT 3.2299E+10 11-SEP-08
2 1 29455 262144000 1 YES CLEARING 3.2299E+10 11-SEP-08
ALTER DATABASE DROP LOGFILE '/u01/oradata/PLIFLEX01S2/redo_g1m1PLIFLEX01S2.dbf'
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance PLIFLEX01S2 (thread 1)
ORA-00312: online log 1 thread 1: '/u01/oradata/PLIFLEX01S2/redo_g1m1PLIFLEX01S2.dbf'
SQL> alter database drop logfile group 1;
alter database drop logfile group 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance PLIFLEX01S2 (thread 1)
ORA-00312: online log 1 thread 1: '/u01/oradata/PLIFLEX01S2/redo_g1m1PLIFLEX01S2.dbf'
Oracle states the redolog on the physical standby as clearing. So they should be empty. But it claims, that the files are needed for for recovery.
The dg config is in the maxavailability mode.
to performe a checkpoint is impossible at standby site since the db is not open. Even a restart or the standby db does not change the situation.
A possible solution might be descriped at metalink Note:395146.1 but I am scared, that this solution may corrupt the filesize specified in the controlfile.
September 16, 2008 - 12:11 pm UTC
what documented way, you say the documented way doesn't work but you do not refer us to any documentation.
How to drop and resize an online redo log on the standby databse
Luis Figueira, September 16, 2008 - 12:11 pm UTC
The previous review have almost everything right, even the comment about the metalink note:395146.1. Indeed it's ratter confusing.
The way I use to drop and recreate the online redo logs on the standby, when they are with status CLEARING or CLEARING_CURRENT it's simply to issue an "alter database clear logfile group n;" on the STANDBY.
After clearing the group you can then drop it, and recreate the group with the new size.
Then issue a log switch on the primary database.
This will change the status for the standby online redo group with status "CLEARING_CURRENT" to "CLEARING"
Issue the "alter database clear logfile ..." for the group with status "CLEARING", drop the group, recreate it and issue new log switch on the primary.
Do this for all groups and should be ok.
Obviously, before do any of this you will need to stop the recovery process on the standby database and also temporarily set the standby_file_management to manual. Also, if you are using a Data Guard Broker configuration you need to disable the configuration first.
Hope this helps.
Cheers,
LF
Resizing Redo Log File
Karthickumar Pillaiyarsamy, December 30, 2010 - 3:18 am UTC
> First of all, you can't resizing the redo log files.
> If you want resize the redo log file, you should drop the current log file.
> At the time of drop the redo log file you got error, because till the time archeiver did'n write the redo log file.
> First you should switch the log file using this command
> ALTER SYSTEM SWITCH LOGFILE.
SYSTEM ALTERED.
> Again you got the error(Crash Recovery) while you drop the redo log file.
> ALTER DATABASE CLEAR LOGFILE GROUP 3.
> Now you can drop the redo log file.
> Then create new file with new size.
> Even you have more members in the group, all the members are concurrently, like a multiplexing.