Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • 10g oem configuration Oracle
  • Export Oracle data and Compress at same time Oracle
  • How to specify 2 arch location to avoid any kind of DB hanging. Oracle
  • create a folder in multiple places Linux/Unix
  • Restoring a user’s original password 1051962.101 Oracle
  • Removing Ctrl-M from end of line using vi Linux/Unix
  • find_pk.sql /* Find Primary Key */ Oracle
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • New Latest Param.sql for finding all hidden parameters also Oracle
  • cache buffer chain latch Oracle
  • Virtual Indexes in Oracle Oracle
  • Wait Based Tuning Step by step with SQL statement Oracle
  • GSQ.sql Oracle
  • Find Multiple levels of object dependencies : depen.sql Oracle
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle

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 an unknown file for oracle. So You need to apply following command for creaating approprote file on your syandby server.

alter database create datafile ‘/oracle/app/oracle/product/10.1/dbs/UNNAMED00012’ as ‘/uocdb5/oradata/CIF/CIF_TEMP_TPF_LOAD_002.dbf’;

Oracle, rman-dataguard

Post navigation

Previous Post: USER_TABLES.Freelists
Next Post: Mutating Table Error while using database trigger

Related Posts

  • V$transaction notes for finding XID composition. Oracle
  • SYSOPER Mystery Oracle
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • UNderstand and eliminate Latch contention. Oracle
  • How to calculate PROCESSES parameter Oracle
  • Good links for x$ tables in oracle. 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 (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • 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

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • Library cahe Latches and internal explaination Oracle
  • Physical Standby switchover with session active Oracle
  • Import and export statements Oracle
  • Monitor Long Running Job Oracle
  • Jai Shree Ram Oracle
  • How to know current SID Oracle
  • UTL_FILE test program Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme