Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Database logon trigger issue Oracle
  • oracle Dba site Oracle
  • How to Use DBMS_STATS to Move Statistics to a Different Database Oracle
  • secure crt settings Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • arch_configUOCIOTTO.ora Oracle
  • VIvek Encryption Package and Its Usage Oracle
  • Export Import with QUERY Oracle
  • How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) Oracle
  • In Addition to previous note, following grants needed on PERFSTAT user. Oracle
  • Goldengate Tutorial Oracle
  • Transfer SQL Profiles from One database to other database. Oracle
  • how to find VIP from ifconfig Linux/Unix
  • handling filenname with space Linux/Unix
  • kill all processes from specific user in solaris. 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

  • How to know current SID Oracle
  • Create type and Grant on it. Oracle
  • Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
  • In Addition to previous note, following grants needed on PERFSTAT user. Oracle
  • block_ident.sql Oracle
  • USER_TABLES.Freelists 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 (387)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (336)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Add new columns in dataframe30-Sep-2023

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • oradebug ipcrm ipcs Oracle
  • Clean up Oracle
  • How to choose Driver table in SQL statement Oracle
  • switchover for primary database Oracle
  • how to find VIP from ifconfig Linux/Unix
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) Oracle
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme