CONSULTA DATAFILE CON ERRORES

 SQL> startup

ORACLE instance started.

Total System Global Area  835104768 bytes

Fixed Size     2293880 bytes

Variable Size   658509704 bytes

Database Buffers   171966464 bytes

Redo Buffers     2334720 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '+DATA/ACME/DATAFILE/system.258.848598015'

SQL> select name, error from v$datafile join v$recover_file using(file#);

NAME

--------------------------------------------------------------------------------

ERROR

-----------------------------------------------------------------

+DATA/ACME/DATAFILE/system.258.848598015

FILE NOT FOUND

+DATA/ACME/DATAFILE/auditoria.269.1056056241

FILE NOT FOUND

SQL>