rman report schema in 12c

The "report schema" command has been around a long time in rman but has been enhanced (slightly) to support pdb/cdb. It's quite a useful utility for just listing datafiles/tempfiles without having to write any sql.

The summary it gives for pdb/cdb is also very handy (perhaps more useful than it was for a 'normal' database)

[oracle@server-name]:ED12G:[~]# rman target=/

Recovery Manager: Release 12.1.0.1.0 - Production on Wed Aug 7 17:35:11 2013

Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1347757411)

RMAN> report schema;

using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORCL

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 800 SYSTEM *** /oracle/ED12G/oradata/orcl/system01.dbf
3 1530 SYSAUX *** /oracle/ED12G/oradata/orcl/sysaux01.dbf
4 300 UNDOTBS1 *** /oracle/ED12G/oradata/orcl/undotbs01.dbf
5 260 PDB$SEED:SYSTEM *** /oracle/ED12G/oradata/orcl/pdbseed/system01.dbf
6 5 USERS *** /oracle/ED12G/oradata/orcl/users01.dbf
7 640 PDB$SEED:SYSAUX *** /oracle/ED12G/oradata/orcl/pdbseed/sysaux01.dbf
8 270 ORA12GCONTAINER:SYSTEM *** /oracle/ED12G/oradata/orcl/ORA12GCONTAINER/system01.dbf
9 690 ORA12GCONTAINER:SYSAUX *** /oracle/ED12G/oradata/orcl/ORA12GCONTAINER/sysaux01.dbf
10 7 ORA12GCONTAINER:USERS *** /oracle/ED12G/oradata/orcl/ORA12GCONTAINER/ORA12GCONTAINER_users01.dbf
26 270 TEST:SYSTEM *** /oracle/ED12G/oradata/orcl/test/system01.dbf
27 700 TEST:SYSAUX *** /oracle/ED12G/oradata/orcl/test/sysaux01.dbf
28 7 TEST:USERS *** /oracle/ED12G/oradata/orcl/test/ORA12GCONTAINER_users01.dbf
29 300 TEST2:SYSTEM *** /oracle/TEST2/oradata/TEST2/datafile/o1_mf_system_8zzjsosr_.dbf
30 300 TEST2:SYSAUX *** /oracle/TEST2/oradata/TEST2/datafile/o1_mf_sysaux_8zzjsqvc_.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 155 TEMP 32767 /oracle/ED12G/oradata/orcl/temp01.dbf
2 87 PDB$SEED:TEMP 32767 /oracle/ED12G/oradata/orcl/pdbseed/pdbseed_temp01.dbf
3 20 ORA12GCONTAINER:TEMP 32767 /oracle/ED12G/oradata/orcl/ORA12GCONTAINER/temp01.dbf
4 20 TEST:TEMP 32767 /oracle/ED12G/oradata/orcl/test/temp01.dbf


We can easily see which files belong to which PDB as they are displayed in PDB:TABLESPACE format.

0 comments:

Post a Comment