Effect of Creating Tablespace/Datafile on Primary when Logical Standby in Place ( SQL apply fails with ORA-01119 )
(Doc ID 1390662.1)
Last updated on OCTOBER 08, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |