| How to display an archived redo log name from backup set/piece? [message #230890] |
Fri, 13 April 2007 04:04  |
patrick_tahiri
Messages: 3
Registered: April 2007
|
Junior Member |
|
|
Hi,
I receive this error:
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability.
ORA-19625: error identifying file /u02/arch/ABX/ABXarch679701603993675.0001
How can I check with an rman command if this archive redo log has already been backuped (included in a backup set/piece)?
When I checked ABXarch679701603993675.0001 in /u02/arch/ABX, it was not there anymore. So the delete command from the rman has deleted it.
1. list backup of archivelog all completed after 'SYSDATE-1';
or
list backup tag 'TAGXXXXX';
or
list backup of archivelog all tag 'TAGXXX';
==> It shows/dislpays only the backup set, the sequence number, and the backup piece NOT the name of the archive redo log (format: ABXarch679701603993675.0001).
2. crosscheck backup of archivelog from sequence 67970;
or
crosscheck backup piece tag 'TAGXXXXX';
or
crosscheck backupset 2209107;
==> It shows/dislpays only the backup pieces NOT the name of the archive redo log (format: ABXarch679701603993675.0001).
3. list archivelog from sequence 67970;
==> Shows/Displays the name of the archived redo log but not ABXarch679701603993675.0001?! ==>> Means that this archive redo log was not backuped?
How based upon my archived redo log name could I check that it is well backuped and included in which backup set/piece? Or maybe not backed up?
Thank you in advance!
Best regards,
Patrick.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
