Database Reference
In-Depth Information
exeRCiSe 6.1
(continued)
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition
Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and
Real Application Testing options
7.
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
8.
Now generate a report of data files that need to be backed up with the
REPORT NEED
BACKUP
command. You will see that the new data file shows up as needing a backup.
Note that as long as you have the archived redo logs that were generated since the data
file was created, you can still recover this data file and any data in it.
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
---- ----- -----------------------------------------
6 0 C:\ORACLE\ORADATA\ORCL\TESTTBS.DBF
Using the RMAN
LIST
Command
The RMAN
LIST
command provides information on backups in your Oracle database. The
LIST
command has the following functionality:
■
Listing expired backups
■
Listing the database incarnation
■
Listing database restore points
■
Listing scripts
■
Listing information on database backups and image copies
Additionally, information can often be listed in two formats, detail and summary, as
you will see in the following sections.
Search WWH ::
Custom Search