Database Reference
In-Depth Information
exeRCiSe 6.1
Using the RePORT Command
1. Log into RMAN, connecting to your recovery catalog.
C:\>rman target=/ catalog=rcat_user/rcat_user@rcat
Recovery Manager: Release 12.1.0.1.0 -
Production on Sat Jan 4 20:01:34 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1195614221)
connected to recovery catalog database
2. Just type in the command REPORT; . Review the output. Notice how RMAN prompts
you for the syntax it is expecting. For example, in this case it's expecting something
akin to report device , report need , report obsolete , and so on.
RMAN> report;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of:
"device, need, obsolete, schema, unrecoverable"
RMAN-01007: at line 1 column 7 file: standard input
3. See what data files and tempfiles are in the database by using the REPORT SCHEMA
command:
RMAN> report schema;
Report of database schema for database with db_unique_name ORCL
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- ----------------- ------- ------------------------
1 680 SYSTEM YES C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
2 631 SYSAUX NO C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
3 25 UNDOTBS1 YES C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
4 5 USERS NO C:\ORACLE\ORADATA\ORCL\USERS01.DBF
5 50 MY_DATA NO C:\ORACLE\ORADATA\ORCL\MY_DATA_01.DBF
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- ----------------- ----------- --------------------
1 20 TEMP 32767 C:\ORACLE\ORADATA\ORCL\TEMP01.DBF
Search WWH ::




Custom Search