ORA-1157 by SELECT FROM DBA_DATA_FILES in RAC Iinstances After Move Datafile

(Doc ID 2413277.1)

Last updated on JUNE 20, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

4 node RAC Setup, from Node 1 acccidentally added a datafile to local filesystem instead of ASM disk group

 


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