Oracle9i Recovery Manager Reference Release 1 (9.0.1) Part Number A90136-02 |
|
RMAN Commands , 45 of 60
reportObject::=
atClause::=
To perform detailed analyses of the RMAN repository. Oracle writes the output from the REPORT
command to standard output or the message log file.
Use the REPORT
command to answer questions such as the following:
REPORT
SCHEMA
command with the AT
TIME
, AT
SCN
, or AT
SEQUENCE
options. Otherwise, a recovery catalog is not required for the REPORT
command.
The information that appears in the output is shown in the following tables:
Table 2-16 Report of Database Schema
Column | Indicates |
|
The absolute datafile number of a datafile with less than n redundant backups. |
|
The number of backups that exist for this file. |
|
The name of the file. |
This example reports the names of all datafiles and tablespaces in the database one week ago:
REPORT SCHEMA AT TIME 'SYSDATE-7'; Report of database schema File K-bytes Tablespace RB segs Name ---- ---------- -------------------- ------- ------------------- 1 47104 SYSTEM YES /vobs/oracle/dbs/tbs_01.f 2 978 SYSTEM YES /vobs/oracle/dbs/tbs_02.f 3 978 TBS_1 NO /vobs/oracle/dbs/tbs_11.f 4 978 TBS_1 NO /vobs/oracle/dbs/tbs_12.f 5 978 TBS_2 NO /vobs/oracle/dbs/tbs_21.f 6 978 TBS_2 NO /vobs/oracle/dbs/tbs_22.f 7 500 TBS_3 NO /vobs/oracle/dbs/tbs_31.f 8 500 TBS_3 NO /vobs/oracle/dbs/tbs_32.f 9 5120 SYSTEM YES /vobs/oracle/dbs/tbs_03.f
This example reports all datafiles in the database that require the application of five or more incremental backups to be recovered to their current state:
REPORT NEED BACKUP INCREMENTAL 5 DATABASE; Report of files that need more than 5 incrementals during recovery File Incrementals Name ---- ------------ ---------------------------------------------- 1 9 /vobs/oracle/dbs/tbs_01.f 2 9 /vobs/oracle/dbs/tbs_02.f 3 9 /vobs/oracle/dbs/tbs_11.f 4 9 /vobs/oracle/dbs/tbs_12.f
The following example reports all datafiles from tablespace SYSTEM
that will need more than two days of archived redo logs to be applied during recovery after being restored from the most recent backup:
REPORT NEED BACKUP DAYS 2 TABLESPACE SYSTEM; Report of files whose recovery needs more than 2 days of archived logs File Days Name ---- ----- ----------------------------------------------------- 1 3 /vobs/oracle/dbs/tbs_01.f 2 3 /vobs/oracle/dbs/tbs_02.f 16 3 /vobs/oracle/dbs/tbs_03.f
The following example reports all datafiles that cannot be recovered from existing backups because redo may be missing:
REPORT UNRECOVERABLE; Report of files that need backup due to unrecoverable operations File Type of Backup Required Name ---- ----------------------- ----------------------------------- 4 FULL /vobs/oracle/dbs/tbs_12.f
The following example reports obsolete backups and copies with a redundancy of 1
:
REPORT OBSOLETE; Report of obsolete backups and copies Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 836 04-OCT-00 Backup Piece 839 04-OCT-00 /vobs/oracle/dbs/05aetj6b_1_1 Backup Set 807 04-OCT-00 Backup Piece 810 04-OCT-00 /vobs/oracle/dbs/03aetj1f_1_1
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|