Hello,
I noticed very strange to me datafiles pathnames for SYSAUX and UNDOTBS1 tablespaces .
Is this normal ? or maybe I have made an unnoticed mistake somewhere ?
It seems like the tablespace names and the physical files were replaced ....
Lok below
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name XE
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 360 SYSTEM *** C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
2 730 SYSAUX *** C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF <---------------- SYSAUX
3 25 UNDOTBS1 *** C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF <----------------- UNDOTBS1
4 0 USERS *** F:\ORACLE_EXPRESS\D\ZM_DB_TSUSERS\USERS.DBF
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\TEMP.DBF