RMAN信息
<ul>
<li>
<p>生产系统的RMAN信息</p>
<pre><code>RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name NVTDB02 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 30 G;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_SERV=NVT-Master,NB_ORA_CLIENT=nvtbisdb1)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/NVTDB02/snapcf_nvtdb02.f';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/nvtdb02/snapcf_nvtdb02.f';</code></pre>
</li>
<li>查看数据文件</li>
</ul>
<pre><code>RMAN> report schema;
Report of database schema for database with db_unique_name RACDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 910 SYSTEM YES +DATA/RACDB/DATAFILE/system.256.1089477103
2 200 TJDATA NO +DATA/RACDB/DATAFILE/tjdata.261.1089483283
3 580 SYSAUX NO +DATA/RACDB/DATAFILE/sysaux.257.1089477137
4 340 UNDOTBS1 YES +DATA/RACDB/DATAFILE/undotbs1.258.1089477153
5 200 TJDATA NO +DATA/RACDB/DATAFILE/tjdata.262.1089483247
7 5 USERS NO +DATA/RACDB/DATAFILE/users.259.1089477153
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 128 TEMP 32767 +DATA/RACDB/TEMPFILE/temp.264.1089477217</code></pre>