Effect of Creating Tablespace/Datafile on Primary when Logical Standby in Place (ORA-01119) (Doc ID 1390662.1)

Last updated on MARCH 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Data guard environment with Logical standby. SQL APPLY will fail with ORA-01119 when we add a new datafile on primary If Primary and Standby are in different mount point or filesystem system. For Example ASM to filesystem and vice versa.

Thu Dec 22 10:34:57 2011
LOGSTDBY Apply process AS05 started with server id=5 pid=41 OS id=5116
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 118, D:\APP\NSELVAKU\FLASH_RECOVERY_AREA\CHICAGO\FOREIGN_ARCHIVELOG\BOSTON\2011_12_22\O1_MF_1_118_7H5G4RCR_.ARC
LOGMINER: End mining logfile for session 1 thread 1 sequence 118, D:\APP\NSELVAKU\FLASH_RECOVERY_AREA\CHICAGO\FOREIGN_ARCHIVELOG\BOSTON\2011_12_22\O1_MF_1_118_7H5G4RCR_.ARC
create tablespace ts4 datafile 'D:\APP\NSELVAKU\ORADATA\BOSTON\BOSTON\DATAFILE\data04.ora' size 10m
ORA-1119 signalled during: create tablespace ts4 datafile 'D:\APP\NSELVAKU\ORADATA\BOSTON\BOSTON\DATAFILE\data04.ora' size 10m...
LOGSTDBY Apply process AS01 server id=1 pid=37 OS id=5316 stopped
Errors in file d:\app\nselvaku\diag\rdbms\chicago\chicago\trace\chicago_as01_5316.trc:
ORA-01119: error in creating database file 'D:\APP\NSELVAKU\ORADATA\BOSTON\BOSTON\DATAFILE\data04.ora'
Errors in file d:\app\nselvaku\diag\rdbms\chicago\chicago\trace\chicago_lsp0_7628.trc:
ORA-26808: Apply process AS01 died unexpectedly.
ORA-01119: error in creating database file 'D:\APP\NSELVAKU\ORADATA\BOSTON\BOSTON\DATAFILE\data04.ora'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms