Home > database >  Oracle12.2 version with the DB INSTANCE query V $ASM_FILE problem
Oracle12.2 version with the DB INSTANCE query V $ASM_FILE problem

Time:09-20

Using database instance login, datafile found out there is a file, but found out through asm_file view to empty,
If use the ASM instance login, asm_file is can check out all of the files,
In the 11 g, whether the database instance and ASM instance, query asm_file are the same,

SQL> Select the name from v $datafile;
The NAME
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
286.970958433 + DATA/former/DATAFILE/system.
+ DATA/former/DATAFILE/sysaux. 287.970958473
+ DATA/former/DATAFILE/undotbs1.288.970958499
+ DATA/former/DATAFILE/undotbs2.299.970959001
289.970958501 + DATA/former/DATAFILE/users.

SQL> Select * from v $asm_file;
No rows selected
  • Related