Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Index Range Scan Oracle
  • Adding Datafile on Primary Server and Impact on Standby Server Oracle
  • handling filenname with space Linux/Unix
  • The most important Tuning Notes Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • note id 373303.1 Linux/Unix
  • Rename Oracle Instance Name Oracle
  • plan10g.sql Oracle
  • Key Management in Oracle: The Core Issue: Missing Master Key Oracle
  • sesswait.sql Oracle
  • checking connectivity between two servers Linux/Unix
  • setting prompt display with .profile Linux/Unix
  • For Search and replace unix command. Linux/Unix
  • How to connect to Oracle Database with Wallet with Python. Oracle
  • Mutating Table Error while using database trigger Oracle

Category: rman-dataguard

Adding Datafile on Primary Server and Impact on Standby Server

Posted on 28-Oct-2005 By Admin No Comments on Adding Datafile on Primary Server and Impact on Standby Server

When u add a datafile in Primary then those changes are not immediately propagated to standby. Once Log with this changes applied to standby, standby database create a filename in $ORACLE_HOME/dbs. This is just a file name and does not have physical file. After this even all log apply service will fail as this is…

Read More “Adding Datafile on Primary Server and Impact on Standby Server” »

Oracle, rman-dataguard

OPENING A STANDBY DATABASE IN READ-ONLY MODE

Posted on 30-Sep-2005 By Admin No Comments on OPENING A STANDBY DATABASE IN READ-ONLY MODE

OPENING A STANDBY DATABASE IN READ-ONLY MODE ——————————————— In order to perform queries on a read-only standby database, the database needs to be able to perform on-disk sorting operations. Locally managed temporary tablespaces do not record transactions in the data dictionary. Steps to create a locally managed temporary tablespace 1. Create a temporary tablespace on…

Read More “OPENING A STANDBY DATABASE IN READ-ONLY MODE” »

Oracle, rman-dataguard

Oracle Standby Database Library Index from Metalink

Posted on 30-Sep-2005 By Admin No Comments on Oracle Standby Database Library Index from Metalink

267931.1

Oracle, rman-dataguard

Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT

Posted on 23-Sep-2005 By Admin No Comments on Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT

========================================== Adding a Datafile or Creating a Tablespace ========================================== The initialization parameter, STANDBY_FILE_MANAGEMENT, enables you to control whether or not adding a datafile to the primary database is automatically propagated to the standby database, as follows: * If you set the STANDBY_FILE_MANAGEMENT initialization parameter in the standby database server parameter file (SPFILE) to AUTO, any…

Read More “Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT” »

Oracle, rman-dataguard

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

Oracle, rman-dataguard

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

Oracle, rman-dataguard

Posts pagination

Previous 1 2 3

Categories

  • AMC10 (0)
  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (9)
  • Videos (0)

Recent Posts

  • Tutornet.US — Source of excellent learning14-Oct-2026
  • OCI Infrastructure Patching14-Oct-2026
  • Free API credits for AI models14-Oct-2026
  • AMC1020-Sep-2026
  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • ipcs -l Linux/Unix
  • Find Multiple levels of object dependencies : depen.sql Oracle
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
  • oracle Dba site Oracle
  • How to analyze statspack or AWR report. Oracle
  • Database logon trigger issue Oracle
  • Sample WW22 listener.ora Oracle
  • ORACLE_SID in sqlplus Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme