Enable trace or spool for the RMAN commands

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.