Shulou(Shulou.com)06/01 Report--

Files that need to be backed up by report

RMAN > report need backup

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

Report of files with less than 1 redundant backups

File # bkps Name

A redundancy of 1 means that 1 backup is sufficient.

Report unrecoverable files

Data that has been operated by nologging cannot be recovered

RMAN > report unrecoverable

Report of files that need backup due to unrecoverable operations

File Type of Backup Required Name

Backup of report obsolete

RMAN > report obsolete

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

Report of obsolete backups and copies

Type Key Completion Time Filename/Handle

--

Backup Set 1 2017-07-23 22:28:56

Backup Piece 1 2017-07-23 22:28:56 / u01/app/oracle/product/11.2/dbs/01sa3qgt_1_1

Datafile Copy 2 2017-07-23 23:50:01 / home/oracle/c1.bakset

Backup Set 2 2017-07-23 22:29:01

Backup Piece 2 2017-07-23 22:29:01 / u01/app/oracle/product/11.2/dbs/02sa3qhc_1_1

...

Report schema

RMAN > report schema

Report of database schema for database with db_unique_name TEST

List of Permanent Datafiles

= =

File Size (MB) Tablespace RB segs Datafile Name

1 920 SYSTEM * / u01/app/oracle/oradata/test/system01.dbf

2 640 SYSAUX * / u01/app/oracle/oradata/test/sysaux01.dbf

3 90 UNDOTBS1 * / u01/app/oracle/oradata/test/undotbs01.dbf

4 408 USERS * / u01/app/oracle/oradata/test/users01.dbf

List of Temporary Files

=

File Size (MB) Tablespace Maxsize (MB) Tempfile Name

-

2 500 TEMP 500 / u01/app/oracle/oradata/test/temp02.dbf

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.