|
|
|
RMAN Crosscheck Clause
Check whether backup pieces, proxy copies, or disk copies
still exist.
Syntax:
CROSSCHECK
{
{ BACKUP [OF listObjList]
| COPY [OF listObjList]
| archivelogRecordSpecifier
} [maintQualifier [maintQualifier]...]
| recordSpec [DEVICE TYPE deviceSpecifier [, deviceSpecifier]...]
};
listObjList::=
[ DATAFILE datafileSpec [, datafileSpec]...
| TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]...
| archivelogRecordSpecifier
| DATABASE [SKIP TABLESPACE ['] tablespace_name [']
[, ['] tablespace_name [']]...]
| CONTROLFILE
| SPFILE
]...
recordSpec::=
{ { BACKUPPIECE | PROXY }
{ 'media_handle' [, 'media_handle']...
| primary_key [, primary_key]...
| TAG [=] ['] tag_name [']
}
| BACKUPSET primary_key [, primary_key]...
| { CONTROLFILECOPY | DATAFILECOPY }
{ { primary_key [, primary_key]...
| 'filename' [, 'filename']...
}
| TAG [=] ['] tag_name ['] [, ['] tag_name [']]...
}
| ARCHIVELOG
{ primary_key [, primary_key]...
| 'filename' [, 'filename']...
}
}
Examples:
Assuming you have configured automatic channels:
RMAN> CROSSCHECK BACKUP;
RMAN> CROSSCHECK COPY;
Query the media manager for the status of backup sets in a given date range:
RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
RMAN> CROSSCHECK BACKUP DEVICE TYPE sbt COMPLETED BETWEEN '01-AUG-04' AND
'31-DEC-04';
"We don't want to go back to tomorrow, we want to go
forward" - Dan
Quale
Related Commands:
CHANGE - Update the status of a backup in the RMAN repository.
CONFIGURE - Persistent RMAN settings.
DELETE - Delete backups from disk or tape
LIST - List backups and copies
REPORT - Report backup status: database, files, backups
NLS_DATE_FORMAT parameter
Related Views:
RC_BACKUP_FILES V$BACKUP_FILES RMAN backups and copies in the repository. RC_BACKUP_PIECE V$BACKUP_PIECE Backup pieces
