Enable spool or trace for RMAN commands
Example 1:
RMAN> spool log to C:\rman\trace.out
RMAN> report schema;
RMAN> spool trace off;
Example 2:
spool trace to 'C:\rman\rman_trace.out';
report schema;
list backup summary;
list backup of datafile 1;
list copy of datafile 1;
spool trace off;
Example 1 output:
Spooling started in log file: C:\rman\trace.out
Recovery Manager18.4.0.0.0
RMAN>
Report of database schema for database with db_unique_name XE
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 910 SYSTEM YES C:\ORACLE\ORADATA\XE\SYSTEM01.DBF
3 660 SYSAUX NO C:\ORACLE\ORADATA\XE\SYSAUX01.DBF
4 65 UNDOTBS1 YES C:\ORACLE\ORADATA\XE\UNDOTBS01.DBF
5 250 PDB$SEED:SYSTEM NO C:\ORACLE\ORADATA\XE\PDBSEED\SYSTEM01.DBF
6 370 PDB$SEED:SYSAUX NO C:\ORACLE\ORADATA\XE\PDBSEED\SYSAUX01.DBF
7 5 USERS NO C:\ORACLE\ORADATA\XE\USERS01.DBF
8 100 PDB$SEED:UNDOTBS1 NO C:\ORACLE\ORADATA\XE\PDBSEED\UNDOTBS01.DBF
13 260 PDB1:SYSTEM NO C:\ORACLE\ORADATA\XE\PDB1\SYSTEM01.DBF
14 400 PDB1:SYSAUX NO C:\ORACLE\ORADATA\XE\PDB1\SYSAUX01.DBF
15 100 PDB1:UNDOTBS1 NO C:\ORACLE\ORADATA\XE\PDB1\UNDOTBS01.DBF
16 5 PDB1:USERS NO C:\ORACLE\ORADATA\XE\PDB1\USERS01.DBF
17 290 PDB2:SYSTEM NO C:\ORACLE\ORADATA\XE\PDB2\SYSTEM01.DBF
18 470 PDB2:SYSAUX NO C:\ORACLE\ORADATA\XE\PDB2\SYSAUX01.DBF
19 425 PDB2:UNDOTBS1 NO C:\ORACLE\ORADATA\XE\PDB2\UNDOTBS01.DBF
20 5 PDB2:USERS NO C:\ORACLE\ORADATA\XE\PDB2\USERS01.DBF
22 100 PDB2:TEST_TB NO C:\ORACLE\ORADATA\XE\PDB2\TEST_TB01.DBF
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 129 TEMP 32767 C:\ORACLE\ORADATA\XE\TEMP01.DBF
2 62 PDB$SEED:TEMP 32767 C:\ORACLE\ORADATA\XE\PDBSEED\TEMP012019-09-18_15-38-03-475-PM.DBF
4 62 PDB1:TEMP 62 C:\ORACLE\ORADATA\XE\PDB1\TEMP012019-09-18_15-38-03-475-PM.DBF
5 62 PDB2:TEMP 62 C:\ORACLE\ORADATA\XE\PDB2\TEMP012019-09-18_15-38-03-475-PM.DBF
RMAN>
Spooling for trace turned off