Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • 10g oem configuration Oracle
  • Jai Shree Ram Oracle
  • Find average Row Length and other table size calculation. metalink notes Oracle
  • Insert cause enqueue locks Oracle
  • Display the top 5 salaries for each department using single SQL Oracle
  • Oracle Standby Database Library Index from Metalink Oracle
  • Wait.sql Oracle
  • Sending SQLPLUS output in HTML format Oracle
  • Add new columns in dataframe Python/PySpark
  • grep multuple patterns Linux/Unix
  • login.sql Oracle
  • Sample WW22 listener.ora Oracle
  • Export Import with QUERY Oracle
  • Validating ORACLE_SID againt oratab file. Linux/Unix
  • restarting network in linux Linux/Unix

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

  • Database link password in user_db_links Oracle
  • online_bkup.sql Oracle
  • Implementing Listener Security Oracle
  • Find_table_size.sql Oracle
  • Finding Oracle Patches with opatch Oracle
  • Oracle GoldenGate lag monitoring shell script Linux/Unix

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
  • Creating never expiring DB user accounts in Oracle Oracle
  • Find Multiple levels of object dependencies : depen.sql Oracle
  • Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
  • Kill a session dynanically using execute immediate Oracle
  • replace alphabets using sed Linux/Unix
  • telnet listening Linux/Unix
  • DBA_HIST_SQLSTAT contents Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme