rman report schema

Quickly identify the datafiles /tempfiles in the database that you need to backup when using rman.

we could drop into sqlplus and do the following:

SQL>select FILE_NAME, FILE_ID, TABLESPACE_NAME
from dba_data_files;

FILE_NAME FILE_ID TABLESPACE_NAME
----------------------------------------- -------- ---------------
+DATA/prod/datafile/users.259.653866897 4 USERS

or the same from dba_temp_files.

But we can just do a 'report schema' from rman itself.

RMAN> report schema;

Report of database schema for database with db_unique_name PROD

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 700 SYSTEM *** +DATA/prod/datafile/system.256.653866897
2 568 SYSAUX *** +DATA/prod/datafile/sysaux.257.653866897
3 40 UNDOTBS1 *** +DATA/prod/datafile/undotbs1.258.653866897
4 5 USERS *** +DATA/prod/datafile/users.259.653866897
5 100 EXAMPLE *** +DATA/prod/datafile/example.269.653867209

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 121 TEMP 32767 +DATA/prod/tempfile/temp.268.653867197

Then i can just cut and paste the datafile name...

RMAN> backup datafile '+DATA/prod/datafile/system.256.653866897';

****************************************
keywords: report schema rman
Version: 11g
****************************************