Question: I want to
understand when to use the RMAN crosscheck command. When do I
use the RMAN crosscheck command?
Answer: The RMAN crosscheck
command is used when RMAN indicates that a file is "missing:
RMAN>
crosscheck backuppiece xxx;
crosschecked backup
piece: found to be 'EXPIRED'
backup piece handle=xxx
crosschecked 1 objects
As we see the RMAN crosscheck command
compares the RMAN catalog entries with the actual OS files and
reports to locate "expired" or "obsolete" RMAN catalog entries.
Once a RMAN crosscheck identified expired,
deleted on on obsolete catalog entries you can run an RMAN delete
command to remove these entries to synchronize the RMAN catalog with
the real database files:
RMAN> delete noprompt obsolete;
The RMAN crosscheck command can also
be used to archive RMAN catalog entries:
crosscheck archivelog all ;
This crosscheck command is used then you get a
RMAN-06059:
oracle> oerr RMAN 06059
RMAN-06059 expected
archived log not found, loss of archived log compromises
recoverability
Cause: The archived log was not found. The
repository thinks it does exist. If the archived log has in fact
been lost and there is no backup, then the database is no longer
recoverable across the point in time covered by the archived log.
This may occur because the archived log was removed by an outside
utility without updating the repository.
Action: If the archived
log has been removed with an outside utility and the archivelog has
already been backed up, then you can synchronize the repository by
running CROSSCHECK ARCHIVELOG ALL. If
the archivelog has not been previously backed up, then you should
take a full backup of the database and archivelogs to preserve
recoverability. Previous backups are not fully recoverable.
The syntax for the RMAN crosscheck
command is simple:
allocate channel ch1
type disk ;
crosscheck archivelog all ;
release channel ch1 ;
|
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|