Resize Redolog Groups in Oracle
Dear All,
Here is the procedure to resize the redo log group in SAP/Oracle
To check all Redolog files Run command:
Select * from v$log;
Now add a group, To add a log group
Alter database add logfile group 5 (‘/oracle/SID/origlogA/log_g15m1.dbf’,’/oracle/SID/mirrlogA/log_g15m2.dbf’) size 200M;
alter database add logfile group 6 (‘/oracle/SID/origlogB/log_g16m1.dbf’,’/oracle/SID/mirrlogB/log_g16m2.dbf’) size 200M;
alter database add logfile group 7 (‘/oracle/SID/origlogA/log_g17m1.dbf’,’/oracle/SID/mirrlogA/log_g17m2.dbf’) size 200M;
alter database add logfile group 8 (‘/oracle/SID/origlogB/log_g18m1.dbf’,’/oracle/SID/mirrlogB/log_g18m2.dbf’) size 200M;
After these commands, Force System for log switch
Alter system switch logfile;
Drop Existing Log groups files (Make sure no group has status active or current)
Alter database drop logfile group 1;
Alter database drop logfile group 2;
Alter database drop logfile group 3;
Alter database drop logfile group 4;
Remove these files from OS level
Now again add same Group
alter database add logfile group 1 (‘/oracle/SID/origlogA/log_g11m1.dbf’,’/oracle/SID/mirrlogA/log_g11m2.dbf’) size 200M;
alter database add logfile group 2 (‘/oracle/SID/origlogB/log_g12m1.dbf’,’/oracle/SID/mirrlogB/log_g12m2.dbf’) size 200M;
alter database add logfile group 3 (‘/oracle/SID/origlogA/log_g13m1.dbf’,’/oracle/SID/mirrlogA/log_g13m2.dbf’) size 200M;
alter database add logfile group 4 (‘/oracle/SID/origlogB/log_g14m1.dbf’,’/oracle/SID/mirrlogB/log_g14m2.dbf’) size 200M;
We can drop Log group 5,6,7,8
In case any of these groups are Active or current stage use “Alter system switch logfile”
Alter database drop logfile group 5;
Alter database drop logfile group 6;
Alter database drop logfile group 7;
Alter database drop logfile group 8;
CHEERSSSSSSSS
Regards,
Gagan Deep Kaushal
-
Archives
- August 2009 (2)
- July 2009 (1)
- May 2009 (2)
- April 2009 (10)
- March 2009 (3)
- February 2009 (1)
- January 2009 (21)
- December 2008 (2)
- November 2008 (12)
- October 2008 (28)
- September 2008 (2)
- May 2008 (7)
-
Categories
- ABAP in SAP
- Activate Add-On in ECC 6.0
- Activate WebGui For SAP
- Add Company Logo in SAP Screen
- Apply Opatch procedure in SAP+Oracle
- Back To Action
- BRTOOL IN SAP
- Central User administration Configuration in SAP
- Configure ADS in SAP Netweaver
- Configure CUA in SAP
- Configure Oracle Entripse Manager In SAP
- Configure Printer in SAP
- Configure solution database in SAP CRM 2007/Solution Manager
- Configure SSO in EP
- CUA configuration
- CUA in SAP
- default url in crm web ui
- Difference Between SAP_ALL and SAP_NEW
- Generate Solution Manager Key
- How do you add your company logo in CRM 2007 WEB UI?
- How to change default log-off url in CRM web ui ??
- How To Change Title of SAP Transaction Code
- How To configure CUA in SAP
- How to find sap transaction codes
- How to List All the T-codes For a Role in SAP ?
- How to Lock or Unlock a Client in SAP ?
- How to send a message to a specific user in sap
- How to use Solution database in Service desk
- Install TOP utility for Solaris
- Installing two Oracle databases on a host
- Intersting Piece of information
- Kernel Update On Unix
- Kernel Update Process
- List All T-codes For a Role
- LOG IN TO BR*TOOL STUDIO
- Long running transport in SAP
- Nahi Bhulunga
- OEM
- Oracle DB parameter tuning
- Oracle DB Performance Issue
- Oracle in SAP
- Oracle Optach
- Oracle Upgrade 10.2.0.2 to 10.2.0.4;OEM
- Oracle upgrade 9.2.0.6 o 10.2.0.4
- Oracle Upgrade From 9i To 10g
- Problem in transport
- Registering a program on the Gateway
- Reset Buffers in sap
- Resize Redolog Groups in Oracle
- Run OS Commands from SAP GUI
- SAP Oracle Parameter fine tuning
- SAP BASIS TRICKS
- SAP BR*TOOL STUDIO
- SAP CUA
- SAP GUI FOR HTML
- SAP Interview Questions
- SAP LIBRARY INSTALLATION
- SAP NOTES
- SAP Notes–That help me a lot
- SAP Performance
- SAP_ALL vs SAP_NEW
- Search and reuse existing solution in Service Desk
- Service Desk Configuration
- Setting Up the Help Center in SAP CRM
- SMS Integration in SAP
- SMS Setting in SAP
- Spam/Saint Update
- Step by Step configuration for SMS integration in SAP
- STMS error
- T-Codes
- T-Codes You Need
- Temporary tablespace in Oracle
- Transactions in SAP
- Troubleshoot With SPAM (At Your Own Risk)
- Unable to read Software Component Versions from SLD
- Uncategorized
- Unforgettable
- Unix Commands
- Welcome
- WHAT IS SAP
- What is the difference between a Transport Domain and a Transport group
-
RSS
Entries RSS
Comments RSS