Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Sending SQLPLUS output in HTML format Oracle
  • Running select from V$ views from remote server Linux/Unix
  • SAN Linux/Unix
  • .profile Linux/Unix
  • Oracle 11g Training on 29JAN1010 Oracle
  • How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) Oracle
  • When to rebuld B-tree index Oracle
  • proper cpu stats Linux/Unix
  • Vivek Tuning for Row Locks. Oracle
  • Implementing Listener Security Oracle
  • 751131.1 New Article Error 2819 While Requesting a Systemstate Dump Oracle
  • sql_plan9i.sql Oracle
  • Jai Shree Ram Oracle
  • Import and export statements Oracle
  • To see mem usage and CPU usage system wide. Linux/Unix

Adding or Dropping Online Redo Log Files When Physical Standby in place

Posted on 09-Nov-2005 By Admin No Comments on Adding or Dropping Online Redo Log Files When Physical Standby in place

Changing the size and number of the online redo log files is sometimes done to tune the database. You can add 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 switchover.

Caution:

Whenever you add an online redo log file to the primary database, you must add a corresponding standby redo log file to the standby database.

For example, if the primary database has 10 online redo log files and the standby database has 2, and then you switch over to the standby database so that it functions as the new primary database, the new primary database is forced to archive more frequently than the original primary database.

Consequently, when you add or drop an online redo log file at the primary site, it is important that you synchronize the changes in the standby database by following these steps:

(1) If Redo Apply is running, you must cancel Redo Apply before you can change the log files.

(2) If the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO, change the value to MANUAL.

(3) Add or drop an online redo log file:

(3-1) To add an online redo log file, use a SQL statement such as this:

SQL> ALTER DATABASE ADD LOGFILE

‘/disk1/oracle/oradata/payroll/prmy3.log’ SIZE 100M;

(3-2) To drop an online redo log file, use a SQL statement such as this:

SQL> ALTER DATABASE DROP LOGFILE

‘/disk1/oracle/oradata/payroll/prmy3.log’;

(4) Repeat the statement you used in Step 3 on each standby database.

(5) Restore the STANDBY_FILE_MANAGEMENT initialization parameter and the Redo Apply options to their original states.

Ref : http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10823/manage_ps.htm#1010567

Oracle, rman-dataguard

Post navigation

Previous Post: Example of How To Resize the Online Redo Logfiles Note:1035935.6
Next Post: create database link syntax

Related Posts

  • First Entry in RAC Oracle
  • Updated LCK.SQL file. Oracle
  • tblwopk.sql /* Find Tables Without PK */ Oracle
  • find_idle_cpu.sql Oracle
  • database trigger failing Oracle
  • create user with unlimited quota Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • currwait.sql Oracle
  • handling filenname with space Linux/Unix
  • Optimizer SORT Operations Oracle
  • move_arch_files.ksh Linux/Unix
  • DBMS_Shared_pool pinning triggers Oracle
  • before_trunc.sql Before Truncate table needs to execute following: Oracle
  • Finding Oracle Patches with opatch Oracle
  • Alter procedure auditing Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme