Oracle® Database Backup and Recovery Basics 10g Release 2 (10.2) Part Number B14192-03 |
|
|
View PDF |
This section contains the following topics:
Run the CHANGE
...
UNCATALOG
command to perform the following actions on RMAN repository records:
Update a backup record in the control file repository to status DELETED
Delete a specific backup record from the recovery catalog (if you use one)
RMAN does not touch the specified physical files: it only alters the repository records for these files.
You can use this command when you have deleted a backup through a means other than RMAN. For example, if you delete archived redo logs with an operating system utility, then remove the record for this log from the repository by issuing CHANGE
ARCHIVELOG
...
UNCATALOG
.
To remove catalog records for files deleted with operating system utilities, run the CHANGE
...
UNCATALOG
command.
To remove the catalog record for a backup deleted with an operating system utility:
Run a CHANGE
...
UNCATALOG
command for the backups that you deleted from the operating system with operating system commands. This example deletes repository references to disk copies of the control file and datafile 1
:
CHANGE CONTROLFILECOPY '/tmp/control01.ctl' UNCATALOG; CHANGE DATAFILECOPY '/tmp/system01.dbf' UNCATALOG;
Optionally, view the relevant recovery catalog view, for example, RC_DATAFILE_COPY
or RC_CONTROLFILE_COPY
, to confirm that a given record was removed. For example, this query confirms that the record of copy 4833
was removed:
SELECT CDF_KEY, STATUS FROM RC_DATAFILE_COPY WHERE CDF_KEY = 4833; CDF_KEY STATUS ---------- ------ 0 rows selected.