Shulou(Shulou.com)06/03 Report--

When deleting obsolete backup files with the DELETE OBSOLETE command, if the following error occurs (RMAN-06207 & RMAN-06208), you need to use the CROSSCHECK command to solve the problem:

RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel (s) due

RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status

The CROSSCHECK command is used to check the backup files to ensure that the RMAN database is synchronized with the backup files. When executing this command, if the status of the RMAN database record does not match the actual backup file, the status in the database will be updated to make it consistent with the actual backup file; if the backup file is in expired state, then the backup is invalid and can be deleted

Introduction to common commands:

1.CROSSCHECK BACKUP

Used to check the backup set of databases, tablespaces, data files, control files, archive logs, and SPFILE.

CROSSCHECK BACKUP;-- check all backups (including valid and invalid backups)

CROSSCHECK BACKUP of database;-check backup files except control files and archived files

CROSSCHECK BACKUP of tablespace system

CROSSCHECK BACKUP of datafile 1

CROSSCHECK BACKUP of controlfile

CROSSCHECK BACKUP of archivelog all

CROSSCHECK BACKUP of archivelog sequence 3

CROSSCHECK BACKUP of spfile

2.CROSSCHECK BACKUPPIECE

Used to check a specific backup film, this command needs to determine the BP value or backup film name of the backup film.

CROSSCHECK BACKUPPIECE 24

CROSSCHECK BACKUPPIECE'/ u01qqappActionoracle.rmancy backup.OCPYJGmail 28'

3.CROSSCHECK BACKUPSET

Used to check a specific backup set, this command requires you to determine the BP value of the backup set

CROSSCHECK BACKUPSET 24

4.CROSSCHECK COPY

Used to check the image copies of databases, tablespaces, data files, control files, and archive files (that is, the backup is made with COPY DATAFILE. Or BACKUP AS COPY. Datale. Command to back up the image of the data file)

CROSSCHECK COPY

CROSSCHECK COPY of database

CROSSCHECK COPY of tablespace system

CROSSCHECK COPY of datafile 1

CROSSCHECK COPY of controlfile

CROSSCHECK COPY of archivelog all

CROSSCHECK COPY of archivelog from sequence 24 until sequence 32

5.CROSSCHECK DTAFILECOPY

Used to check a specific data file image copy, this command needs to specify the file name or key value of the image copy

CROSSCHECK DATAFILECOPY 2

CROSSCHECK DATAFILECOPY'/ u01amp appActionoracleUniplex rmancy backupUniple tp9.dbf'

6.CROSSCHECK CONTROLFILECOPY

Used to check a specific control file image copy, this command needs to specify the file name or key value of the control file image copy

CROSSCHECK CONTROLFILECOPY 3

CROSSCHECK CONTROLFILECOPY'/ u01/app/oracle/rman_backup/controlfile01.ctl

7.CROSSCHECK ARCHIVELOG

Used to check a specific archive log, this command needs to specify the file name or key value or sequence value of the archive log

CROSSCHECK ARCHIVELOG 36

CROSSCHECK ARCHIVELOG 'crosscheck archivelog' / u01ActionAccording to an oracle, the product is 11g Universe, dbsUnique, arch2equal, 813161833.dbf'.

CROSSCHECK ARCHIVELOG sequence 7

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.