Why is RMAN restoring the datafiles out of ASM and how to restore a backup into ASM?
Here is one output. The tablespace triscaltb was restored in /u01/app/oracle/product/12.1.0/dbhome_1/dbs/MISSING00013
RMAN> report schema;
Report of database schema for database with db_unique_name TRISCALDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 780 SYSTEM YES +DATA/TRISCALDB/DATAFILE/system.258.1016190249
3 600 SYSAUX NO +DATA/TRISCALDB/DATAFILE/sysaux.257.1016190057
4 135 UNDOTBS1 YES +DATA/TRISCALDB/DATAFILE/undotbs1.260.1016190491
5 250 PDB$SEED:SYSTEM NO +DATA/TRISCALDB/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/system.267.1016191021
6 5 USERS NO +DATA/TRISCALDB/DATAFILE/users.259.1016190489
7 510 PDB$SEED:SYSAUX NO +DATA/TRISCALDB/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/sysaux.266.1016191021
8 260 TRISCALPDB:SYSTEM NO +DATA/TRISCALDB/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/system.272.1016192445
9 520 TRISCALPDB:SYSAUX NO +DATA/TRISCALDB/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/sysaux.271.1016192441
10 5 TRISCALPDB:USERS NO +DATA/TRISCALDB/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/users.273.1016192445
11 1243 TRISCALPDB:EXAMPLE NO +DATA/TRISCALDB/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/example.270.1016192435
13 0 TRISCALTB NO /u01/app/oracle/product/12.1.0/dbhome_1/dbs/MISSING00013
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 60 TEMP 32767 +DATA/TRISCALDB/TEMPFILE/temp.265.1016190837
2 20 PDB$SEED:TEMP 32767 +DATA/TRISCALDB/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/pdbseed_temp012019-08-13_11-21-09-am.dbf
3 20 TRISCALPDB:TEMP 32767 +DATA/TRISCALDB/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/triscalpdb_temp012019-08-13_11-47-56-am.dbf