Database Reference
In-Depth Information
121 RMAN backup & recovery I/O 47
129 SQL*Net message from client 1
129 SQL*Net message from client 2
129 SQL*Net message from client 2
130 SQL*Net message from client 1000
130 SQL*Net message from client 1000
130 SQL*Net message from client 1000
130 SQL*Net message from client 1000
130 SQL*Net message from client 1000
The difference in session 121's wait titled RMAN backup & recovery I/O might indicate
a problem with the disk subsystem that we are backing up to (which is quite correct in this
situation, since we ran this on a slow computer).
Administering RMAN Operations
For the OCP exam, you will be expected to know how to administer RMAN. The principal
commands used to administer RMAN are the
DELETE
command, the
CROSSCHECK
command,
the
CATALOG
command, and finally, the
RESYNC
command.
Using the
DELETE
Command
The
DELETE
command is used to mark backup set pieces, image copies, or archived redo
logs as deleted if they have been previously marked as expired (missing) or obsolete (reten-
tion criteria-related). Previously in this chapter, you saw the
LIST EXPIRED
command used
to indicate which backup set pieces were expired. After running the
LIST EXPIRED
com-
mand, we would use the
DELETE EXPIRED BACKUP
command to mark those as permanently
deleted from the control file and the recovery catalog.
When the
DELETE EXPIRED
command is executed, all records for those backup set pieces
in the control file and/or the recovery catalog are marked as deleted. When the
DELETE
OBSOLETE
command is executed, that command will mark the records for the backup set
pieces as deleted in the control file and recovery catalog. The
DELETE OBSOLETE
command
will also remove any physical-backup set pieces present on the backup media.
Here is an example where we list the expired (missing) backup set pieces and then
delete them:
RMAN> list expired backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
425 Full 176.72M DISK 00:06:02 11-OCT-13
BP Key: 433 Status: EXPIRED Compressed: YES Tag: TAG20131011T142622
Piece Name: C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_11
Search WWH ::
Custom Search