How to Add/Drop/Resize Redo Log with Physical Standby in place. [ID 473442.1]
|
|
|
Modified12-AUG-2009TypeHOWTOStatusREVIEWED
|
|
In this Document
Goal
Solution
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.5
Information in this document applies to any platform.
Goal
To Add/Drop/Resize online redo logs in the primary site with physical standby database in place. What are the steps to be done on standby if any?
Solution
Changing the size of redo involves adding the new sized log and dropping the unwanted old log. There is no resize command as such. You can add or drop online redo log file groups or members to the primary database without affecting the standby database.
Similarly, you can drop log file groups or members from the primary database without affecting your standby database. However, these changes do affect the performance of the standby database after a role transition. So it is best advised whenever you add an
online redo log file to the primary database, you should add corresponding online and standby redo
log files to the standby database.
To resize redo logs the steps are as follows:
At the primary site
=============
1. Set STANDBY_FILE_MANAGEMENT to MANUAL.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL';
2. Add the new redo logfile groups of the required sizes.
SQL> ALTER DATABASE ADD LOGFILE GROUP 4 ('/U01/oracle/modg1/redo04.log') SIZE 50M;
3. Drop the old groups, this may involve performing log switches to ensure the old logs have been archived correctly or could be performed later once oracle has finished with the logs.
SQL>ALTER DATABASE DROP LOGFILE GROUP 2;
4. Set STANDBY_FILE_MANAGEMENT to AUTO.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';
At the standby site
=============
1. Stop Redo apply:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
2. Set STANDBY_FILE_MANAGEMENT to MANUAL.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL';
3. Add Redolog File Group:
SQL> ALTER DATABASE ADD LOGFILE GROUP 4 ('/U01/oracle/modg1/redo04.log') SIZE 50M;
Add as many Redo Logfile Groups (or Members) you want to add.
4. Set STANDBY_FILE_MANAGEMENT to AUTO.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';
5. Check the Status of the Online Redolog Group.
SQL> SELECT GROUP#, STATUS FROM V$LOG;
GROUP# STATUS
---------- ----------------
1 CLEARING_CURRENT
3 CLEARING
2 CLEARING
If Status is CLEARING_CURRENT then you cannot drop Online Redolog Group. You will get ORA-01623 if you try to drop a Redolog Group with Status CLEARING_CURRENT.
For Status CLEARING, UNUSED, INACTIVE please follow below steps.
6. Clear the Online Redo Logfile Group:
SQL> ALTER DATABASE CLEAR LOGFILE GROUP 2;
7. Drop the Online Redo Logfile Group:
SQL>ALTER DATABASE DROP LOGFILE GROUP 2;
If you have skipped Step 4 then you will get ORA-01624 while droping the Online Redolog Group with Status CLEARING.
8. Set STANDBY_FILE_MANAGEMENT to AUTO.
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';
9. Start Redo Apply:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
------------------------------------------------------------------------------
分享到:
相关推荐
quill.min.js image-resize.min.js
*Fix problem in DatetimePicker when it resize. News in 4.50 01/03/2007 *Fix problem work with Billenium Effects. News in 4.42 12/06/2006 *skindata.skincontrols option work in window common dialog. ...
resizeWindow.txt resizeWindow.txt resizeWindow.txtresizeWindow.txtresizeWindow.txt resizeWindow.txt resizeWindow.txt resizeWindow.txt
先执行“nomount”,然后执行“mount”,再打开包括Redo log文件在内的所有数据库文件, 这种方式下可访问数据库中的数据。 4、startup,等于以下三个命令 startup nomount alter database mount alter database ...
In Lesson 1 you learn how to organize columns and rows of data into a range so that you can effectively sort, filter, subtotal, and outline the data. Then you learn how to protect the data from ...
Now it is possible to define is the drawing take place via WMPaint or via the PaintTo direct call (if rcPaint contain non-empty rectangle then WMPaint in progress). - FIX: The TFlexPanel.FPaintCache ...
用于DOM元素变化,当元素变化时,用户需要做出什么操作
范例1 单元格的引用方法 1-5 使用Resize属性返回调整后的单元格区域.xlsm
resize figure on screen according to papersize. in matlab
1 What Is a GUI? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2 How Does a GUI Work? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4 Where Do I Start? . . . ...
Image Resize Guide可以自由调整图片大小,当前能够修改图片大小软件很多很多,基本上图片处理软件都能修改图片大小。 你只需点击几次鼠标,软件会自动帮你完成余下的工作。对雪景,水或绿树背景的图片效果出众,重要...
How_To_Resize_RAID_Partitions.pdf
CKFinderPlugin-ImageResize-2.3.1.jar
Commit 'undoable' redolog to base image 8.21.5. Disk image info 9. Guest operating systems 9.1. Knoppix 9.1.1. Getting Knoppix 9.1.2. Preparing Bochs 9.1.3. Using Knoppix 9.2. FreeBSD 5.2.1 9.2.1. ...
1)GETTING STARTED WITH VISUAL BASIC .NET An Introduction to Visual Basic .NET ................................................................................2 Install Visual Studio .NET.................
智能图像物体移除Image处理 Image Resize Guide? ...2009 - 2010 Two Pilots All Rights Reserved 1. THE PURPOSE OF THE PROGRAM Image Resize Guide is a...5. HOW TO CONTACT US http://tintguide.com/en/support.html
•How to add Drop zone effects. •How to display Extended progress information. •Drag and drop uploads from another web page •Fixing Safari hanging on very high speed connections (1Gbps) •Direct ...
安装步骤:安装后,先别立刻运行Image Resize Guide,将ChineseSimplified.ini复制到C:\Program Files\Image Resize Guide\Languages目录下,将“破解补丁.exe”复制到C:\Program Files\Image Resize Guide...
News in 3.06*Fix bug in C++Builder.*Fix bug in scrollbar resize.*Fix bug in Delphi7 XPmanifest component.News in 3.05*Fix bug when move controls in different forms.*Fix problem in TStatusbar that is ...
jquery的resize()事件,直接调用没有起作用引入该文件来实现resize()方法。